Can a parameter span across all subreports in a report?

[longlam]

Hello All,

I am looking to recreate a income statement in Netsuite, and am creating this via multiple subreports within a report. I want to create two parameter fields that will indicate the start date and end date of the report. How can I specify the parameter at the report level and have it trickle down to all the other subreports.

Thanks,
Long

 

[synapsevampire]

When you insert the subreport link your parameter to the appropriate field(s) in the subreport.

See, you don't state anything specific about the data so it's hard to advise you, try to take the time to state what FIELD or FIELDS would be used in these subreports, we don't know if you have a field called start and one called end, or just one field.

If you have a start and end date, then the above will work, if you're suing them against a single date field, after you've done the linking, go into the subreport->report->Selection formula->Record and edit the links to be >= and <= rather than the default +.

-k

 

[longlam]

It is actually one field. Sorry about that. Will we also be able to somehow have a parameter affect a sql command? In the command itself there is a date check, that says what dates spans to use. I want to have the parameter update the command itself as well.

 

[longlam]

I also forgot to add I am using Crystal Reports 11.

 

[lbass]

Yes, and you should create the parameter within the command and use it in the where clause of the command. The parameter will then be available for linking in the subreport linking screen.

-LB