Link to home
Start Free TrialLog in
Avatar of Yogeshup
Yogeshup

asked on

How to change the sub-report links dynamically in crystal reports 10.x?

I  have a main report called "Main.rpt". There are 3 more reports named as "One.rpt", "Two.rpt" and "Three.rpt" separately.

I want to have a sub-report in the "Main.rpt" page which initially points to "One.rpt" file. And at runtime, i need to change the sub-report's pointing link to "Two.rpt" or "Three.rpt".

How can I accomplish this?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

How do you determine which subreport to use

You can conditionally suppress a section by
Right click the left margin of the section you want to suppress
Click SECTION EXPERT
Click the formula button to the right of SUPPRESS
Enter a formula that returns TRUE when you want the section suppress

mlmcc
I agree.

I don't think you can change it at runtime because you must authenticate to the db before you can make changes but if you change the subreport then you haven't authenticated with the correct info - it's an endless cycle.

mlmcc's suggestion to include all 3 and suppress the unneeded ones is the best approach.

frodoman
Forced accept.

Computer101
EE Admin