help required for setting parameter values for sub reports

[jayaramuds]

I am using CE 11 for report generation. I am facing problem in setting parameter for a on-demand report which has sub reports. Can some body post the code, setting values for parameters of subreports?

Thanks in advance

Jayaramu

 

[Turkbear]

Hi,
IIRC, you set the parameters is the main report and the main report's link(s) to the sub controls what data is returned..I am not sure you can have sub-report only user-entered parameters.

 

[jayaramuds]

Hi Turkbear

If I set the values for parameters present in main report then crystal is throwing page for entering values for parameters present in sub report even though I have linked the parameters from main report to sub report. I am running reports in Java environment.

 

[Turkbear]

Hi,
Try removing the parameters from the Sub and using the main report's parameter values as the selection criteria..In other words, if your sub has a parameter called
{?ThisRecord} and it is used in the sub's selection criteria as
{subreporttablename.field} = {?ThisRecord}

You would create that parameter in the Main report instead(after removing both the parameter and the selection criteria formula from the sub) - Use the Change Subreport Links to link the parameter to the same
{subreporttablename.field}. that was in the original selection criteria.

 

[jraheja]

I just attended a training. I haven't used it. But he said you can define the variable scope as 'global' and use it in subreports. You still have to declare it every time you use it. Hope that helps...