How do I pass the same parameter to multiple Command statements in Crystal Reports XI?

Question

My DB does not have the tables I need, so I have to create custom SQL queries (commands in Crystal terminology), embed the results in a subreport, and fill my report with subreports. Here's what I want to happen:

1. Report asks user for a date

2. That date gets passed into the subreports

3. The date passed into subreports gets used in the query.

4. User only has to enter date once, everything else happens behind the scenes

Here's what actually happens:

1. User is asked for date for subreport 1

2. User is asked for date for subreport 2

3. etc etc

4. User gets frustrated and report is unsuccessful.

I know I can link parameter fields between reports, but as I understand it, I cannot do the same with commands. How can I rectify this?

Answer 1

Right-click on the subreport object and choose Change SubReport Links, then select how the parameter is to be used by the subreport.

Courtesy: @MartW