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?
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.