I have a Crystal Report that is based on an Oracle Stored Procedure. This was created using Crystal Reports 2008, and it is published on a Business Objects 3.1 environment.
There are actually 7 parameters in the stored procedure, of which only 2 require the user to select. When the report is opened the user is asked for a date and a type to be evaluated. The report opens for a specific location, and the data associated is returned. When the WebElements submit button is hit it passes these 3 pieces of information, along with original information, new information, reason and user passing information. All of this is functioning.
The issue is when I publish the report. I set the location and do not pass it along. What I need is for the information the user does not enter to not appear on the input parameters in InfoView. I tried setting them as nulls initially, and not showing them on the parameter panel. Once these were set I was not able to change them on the second pass (with use of the submit button). Next I set them to specific values which the stored procedure looks for. That way I set them on the CMC and do not pass them. Once again this locks the parameters and I can not change them on second pass of the report. If I show the parameters and populate them on first pass, they can be changed on second pass.
Is there a setting in Crystal Reports I need to set to allow the parameters to not show on the startup parameter panel and yet still be changed?
Thanks
Scott