[pravs]

I have a parameter in the main report that is for a date range and returns the cost within the date range selected. Now i want to compare the costs between the selected date range and a year before. So i want to pass this parameter to the sub report and subtract a year so i can compare the two costs. Please could you help me to pass the parameter from the main report to the sub report is there a way to do it?

Thank you so much for your help.

[DrewAllen]

In the sub-report, create a parameter by adding "pm-?" to the beginning of your main report parameter's name. So if your main parameter is {?Date} then your sub-report parameter would be {?pm-?Date}. Then link you sub-report to the main report using the two parameters.

Drew

[pravs]

i have created the parameter in the subreport as you mentioned but am not able to link the main report to the subreport with the parameters. Right now they work as individual parameters. The one on the main report is called {?posting year} and on the subreport is called {?pm-?posting year} - it prompts twice for the two parameters. How can i link it to the main parameter. Please let me know.

Thanks a lot for your quick response!

[DrewAllen]

Right-click on the sub-report and select "Change Sub-Report Links". Add the parameter to the list of fields to link on. It should show the name of the parameter it will use to link in the lower left corner. If this doesn't match your sub-report parameter, change the sub-report parameter to match it.

Drew

[pravs]

Thank you it works!!!

[wagoneer]

Hi - I'm attempting to do exactly the same thing and having some troubles as well...the main report parameter has {?Start_Date} and {?End_Date}, in the subreport, I added the parameters {?Pm-?Start_Date} and {?Pm-?End_Date}. If I attempt to go and link the start_date and End_Date from the main to the sub report, the parameters from the subreport are not available in the dropdown for 'fields to link to'. In the Subreport editing, if I expand the 'Parameter Fields' the pm-?Start_Date and Pm-?End_Date are present. The only available field to link to is Employee Number, which I am already linking to get the information to break on each employee.

[DrewAllen]

The "Fields to Link To" will only show fields and parameters from the main report. There is another box in the lower left hand corner labeled "Subreport parameter field to use". When you select {?Start_Date} in the "Fields to Link To", the parameter {?Pm-?Start_Date} will automatically appear in the "Subreport parameter field to use." When you select a parameter, the "Select data in subreport based on field" will be grayed out. If it's not, then you are not selecting a parameter from the main report.

Drew

[wagoneer]

Thanks for the help! it worked like a charm!