|
-
Jul 16th, 2008, 04:58 PM
#1
Thread Starter
PowerPoster
[RESOLVED] An addendum to a preivous post - Parameter Prompt!
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,
-
Jul 16th, 2008, 11:17 PM
#2
Hyperactive Member
Re: An addendum to a preivous post - Parameter Prompt!
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
-
Jul 17th, 2008, 08:51 AM
#3
Thread Starter
PowerPoster
Re: An addendum to a preivous post - Parameter Prompt!
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?
-
Jul 17th, 2008, 09:49 PM
#4
Hyperactive Member
Re: An addendum to a preivous post - Parameter Prompt!
Try the actual Edit Menu from the Main Report either in Design or Preview modes.
-
Jul 18th, 2008, 08:49 AM
#5
Thread Starter
PowerPoster
Re: An addendum to a preivous post - Parameter Prompt!
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|