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
gilweber3Asked:
Who is Participating?
 
James0628Connect With a Mentor Commented:
Disclaimer: I haven't used Crystal Enterprise, so I've never been able to use that user name field.

 If you need to pass a value from a subreport to the main report, that can be done using a shared variable.  However, if you need to pass that to a SP that's used by the main report, I don't think you can do that.  CR will probably execute the SP in the main report before any subreports.

 Maybe someone else will be able to offer a solution.  And if I'm wrong, hopefully someone else will correct me.

 James
0
 
gilweber3Author Commented:
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.
0
 
James0628Commented:
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
0
 
gilweber3Author Commented:
no these are custom made function ins SQL (scalar valued)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.