I am trying to figure out how to add Sage User names to custom Crystal Reports that the users run in Sage.
Well it would help if we knew if this is a report on the reports menu or a custom report. Also what tables you are using if custom.
For something like this I try and duplicate the way it is done in stock reports. In this case, a formula field @PrintedByUser with a blank formula. The value might be passed in to the field automatically. (I know this works for company code, but have not done it with the User field).
User names for transactions that are reported in the report? I'm wondering to, the closest I could find was a UserName field but it only listed the user that updated the transaction, not of the person that originated the transaction.
It would really help a whole lot if you identified which module and which tables you were talking about.
Thank you Kevin M. I too have been trying to find the answer to the question Rick K posted. Your response lead me to the answer and I successfully added the Printed By User information to a couple forms. Thank you!
It is a custom report like the question said "CUSTOM Crystal Reports". Mostly in the Sales Order module, but need this for any of the modules that a custom report is created in. Mostly the AR_InvoiceHistoryDetail and AR_InvoiceHistoryHeader, but need this for any of the tables that a custom report is created in.
I have tried copying from a canned report, but it does not work in the reports that I created.
The Invoice History tables will only contain the ID of the person who updated the file. If you want to know who created the original sales order then you would need to do some work. You would need to create a UDF in the sales order files and have it flow to AR Invoice History, other wise you would need to use the Sales Order History files.
Further to what BigLouie wrote, I believe AR invoice history's user field might be the ID that posted the sales journal, not who last edited the invoice.
Rick K,
I don't know why that method wouldn't work for you.
Are you wanting to know who printed the report or who created the record?
*Community Hub is the new name for Sage City