Michael Katz
asked on
Crystal Menu..to run Reports
I would like to have a Parameter within a Crystal report that will only call other reports and their parameters...
The embedded reports would not be linked to each other...I thought i had done this before but I can't remember how.
The embedded reports would not be linked to each other...I thought i had done this before but I can't remember how.
Create parameters on the report level, add subreports and link the subreports' parameters to the report parameters by riggt clicking the subreport and select "Link parameters" menu
ASKER
Either I am not understanding what you are saying or you are not understanding what I am saying...
The parameters on the Main Report..need to link to the Name of the sub reports...
Example..
1. Report1.rpt
2. Report2.rpt
After clicking on the 1. The Report1.rpt launches and then the prompts for that report are presented..
The parameters on the Main Report..need to link to the Name of the sub reports...
Example..
1. Report1.rpt
2. Report2.rpt
After clicking on the 1. The Report1.rpt launches and then the prompts for that report are presented..
I don't know how to do that with Crystal.
I don't believe you could do it automatically but you could create hyperlinks using formulas for the report names. The formulas would convert the parameter into the appropriate report path/url and then when clicked it would open.
mlmcc
mlmcc
To extend mlmcc idea, you can suppress each of the subreports based on the value of the parameter. So if the parameter is saying report1 you will suppress all other subreports and just report 1 will be visible.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.