Link to home
Start Free TrialLog in
Avatar of gilweber3
gilweber3Flag for United States of America

asked on

CurrentCEUserName parameter in main report

Folks,

currently we have been 'hardcoding' the values we will use for CurrentCEUserName. The problem the outside report (main report) has the hiearchy we are using for the subreport data ( no hierarchy but uses the hardcode id and scope type) The problem is there is no way to pass CurrentCEUserName to the stored procedure in the main report or is there?

Mike
ASKER CERTIFIED SOLUTION
Avatar of James0628
James0628

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gilweber3

ASKER

James I think you are correct. Honestly we are just trying to explore our options after I spent many hours already coding this to perfection but did not take this into consideration.

We basically have come to a crossroad we can have it in the main report but you can not pass it to a stored procedure in the main report.  You can use it as a filter in the main report against the data returned in the record selection criteria for a stored procedure or using either a table or view and it will create dynamic sql which will be executed at the server.

the problem is we will probably have to push our select statements to the sub reports( gets our user base) or create views but a lot of how we get the user base is rooted in the use of functions which sql will not let us do I assume.
Avatar of James0628
James0628

I don't know what kind of functions you're referring to, but you can create functions in MS SQL, for example.  But I suspect that you're referring to specific functions or something like that.

 James
no these are custom made function ins SQL (scalar valued)