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

Answer 2

I was wrong about the links not working. They do work, with modification.

As long as your queries are using parameters named the same way, this can work. With the default linking, you'll get a parameter window that looks like this: https://i.stack.imgur.com/zuCxA.jpg. If you modify your linking to look like this: https://i.stack.imgur.com/8N4Wi.jpg, then the reportingDate parameter used in the main report will be passed into the individual SQL queries of the subreports, as expected. Thanks to Nepali for pushing me in the right direction!