Main report parameter as a subreport command parameter

building reports crystal reports
1

I need to pass a parameter from the main crystal report to a series of sub reports and have that parameter be available for usage in a command in the subreports

mrmulliganman (BOB member since 2008-11-24)

2

Did you find a way to do this? I’m having exact same issue but don’t see any instructions.

jfini (BOB member since 2008-11-11)

3

Ok, here’s how I did it.

Create the command with a parameter, ie “NC” in your original report.

Then create your command in the subreport.

Here’s my command statement in the subreport

select *
from F_View
where NC like ‘{?NC}’

The link between the 2 reports is Command.NC

Hope this helps, it worked like a champ.

khorn (BOB member since 2008-04-18)