PDA

Click to See Complete Forum and Search --> : [RESOLVED] An addendum to a preivous post - Parameter Prompt!


blakemckenna
Jul 16th, 2008, 04:58 PM
I have tried everything I can think of, searched the net far and wide and found no answers to eliminate the "Parameter Prompt" for a Crystal Report. So, I was wondering this:

I have a main report that has 2 parameters. This report has 3 subreports with the exact same parameters.

Is it possible to remove the parameters from the main report and pass the values into the main report via a SelectionFormula coded in the VB app and then move these values into the subreport parameters?

If this is possible, can someone show me how to do it in the CR IDE?

Thanks,

rasinc
Jul 16th, 2008, 11:17 PM
Normally I use the Edit, Subreport Links option to link the parameters in the main form to the same parameters copied to the subreport. Do this for each of the subreports. Then you can pass the values to the paramaters to the main form and then the report will carry it forward.

Hope this helps

blakemckenna
Jul 17th, 2008, 08:51 AM
I think I already do this. I'm in my subreport...I right click on a parameter from the field explorer list and select "Edit". Is that what you mean. But I don't see any option on the "Edit" form that does any linking to the main report.

Or do you mean right-clicking on a subreport from the main report and using the "Change Subreport Links" option?

rasinc
Jul 17th, 2008, 09:49 PM
Try the actual Edit Menu from the Main Report either in Design or Preview modes.

blakemckenna
Jul 18th, 2008, 08:49 AM
Rasinc,

I have resolved this problem by taking a completely different approach. These 3 subreports were driven by Stored Procedures (1 for each report). So, iInstead of using parameters I created a dynamic dataset as a result of each SP and created a Datasource XSD and then made the datasets the actual datasource for each report. That solved the problem.