Allow passing of the current user ID to crystal reports.
A standard parameter eg USERID could be added to the print function. Allows reports to be easily customised for that user - great for security and precise reporting.
For example, a client has asked us for a PO commitment report that only shows commitments for the Accpac user running the report,as executive's POs shouldn't be displayed to all report users.

by: William W. | over a year ago | Reports / BI

Comments

• we now have this tool if anyone needs it

  by: Stacey O. | over a year ago

• How do I get my hands on this tool?

  by: Curt D. | over a year ago

• Try adding the parameter ACCPACUSERID. I don't know if this is available to us due to Norming security add-on, or if it's standard Accpac.

  by: Aart V. | over a year ago

• How about the user's first and last name (Username) what is the parameter name for it?

  by: Michael B. | over a year ago

• Need the current Sage 300 user ID and full name in Crystal for the person printing the document.

  by: Alex A. | over a year ago