Skip to Content
0
Former Member
May 15, 2013 at 08:56 AM

Current logged user in a Crystal Report

678 Views

Hello,

I need to create a CR report that use the current logged user in his session. The report is running in SB1 and as source we want to use a stored procedure.

The report shows some sales figures. The idea is that when a sales person is logged in, the report compare the user name against the sales employee in the sales orders for the results.

Is this possible? I now the trick with the FMS ‘SELECT T0.U_NAME FROM OUSR T0 WHERE INTERNAL_K = $[USER]‘ but this is not useful in a stored procedure.