cancel
Showing results for 
Search instead for 
Did you mean: 

Setting context in Crystal Reports 2013 SP7 Oracle Database

bljonesut
Discoverer
0 Kudos

Hi. I have a requirement to set an application context value for the session before running a crystal report. I have tried to select from a function using a sub report in the header or including the select in my main query. These do not work for the main query but do have the proper effect on the sub reports that follow. Is there a way to force a sub report to execute first or a method to call the procedure in something like a before report trigger similar to Oracle Reports? I would prefer not to have to rewrite reports to put the main query in a stored procedure. Anyone have a suggestion? I have seen some very old posts with this question but nothing recent. Hoping the answer has changed.

Thanks.

Bonnie

Accepted Solutions (0)

Answers (1)

Answers (1)

bljonesut
Discoverer
0 Kudos

SAP Support confirmed still no work-a-round to execute a query before the main query and still no nested sub-reports. Will request an enhancement.