Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

On Demand Excel Report to show user id

Hi,

I have developed a NPrinting on demand report in excel to export data into a predefined excel template.

The requirement is to show the user id of the user who executed the on demand report in excel.

Is this possible in NPrinting and if yes then how to achieve the same?

Regards,

Murali

3 Replies
Anonymous
Not applicable
Author

I will get you started at least.  I tried this in preview mode and it works, so it should work with on-demand  There are two QV functions that might help you achieve this.

=osuser()  will show you the name of the person logged into the operating system

=qvuser() will show you the user id of the individual if you are using section access.

As a general rule, if you can select a value in QV, you can display it in a NPrinting report.

So, if I was trying to do this, I would l would create a variable called vUser

vUser =osuser.

In your NPrinting template, add a variable with vUser.  Add to your Excel template.

I did a quick test and my variable displays my osuser() name in my Excel Report in the cell I place the variable.

Hope that helps move you forward


Not applicable
Author

Thanks for your quick reply. Let me try this solution.

I will update back shortly

Not applicable
Author

Sorry for late response.

This is only working on Desktop but not on server