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
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
Crystal Reports
Last Comment
gilweber3
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
James
ASKER
no these are custom made function ins SQL (scalar valued)
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.