I'm new to CR. I created a CR report that uses an Oracle stored procedure as its data source. The stored procedure has two input parameters and an OUT parameter which is a reference cursor.
The report is able to retrieve and display the rows in the result set. However, I would like to retrieve another piece of information from the database that will be displayed on the report header. This info applies to the entire report, not to individual rows on the report, so I would rather not include it as part of the result set.
I tried adding another OUT parameter to the stored procedure but CR gave me an error that it cannot be null. I changed it to an IN OUT parameter and assigned a value to it, but CR returned the same error.
Is there another option other than adding another column (with the same value) to the result set?
Thanks for your help.