V10 Sub-report. Am I losing my mind?

[Kevinski]

I have a very simple report which tabulates service calls logged by their urgency. I have a parameter for the date and I have the Company ID 'hard-coded' (although this too may become a parameter).

Now I want to add a sub-report which simply lists a few details about all the priority 1 calls.

I have constructed this report and tried to add it linking it via date parameter and Company ID.

In other words when I run the main report I want to enter a parameter for the date and have the sub-report reflect all priority 1 calls for that customer for that date.

But I'm either getting all priority 1 calls for all dates or none at all.

Should I be constructing the sub-report with a date parameter too? I would have thought that if my sub-report was set up to return every P1 call for every customer I could then filter its contents simply by linking on the Customer ID and date parameter field in my main report rather than have to enter a parameter on my sub-report as well.

 

[lbass]

Try creating the same date parameter in the subreport and adding it to your subreport selection formula. Then when you create the link for the date parameter, in the bottom left corner (I'm not sure what the screen looks like in CR 10 though), instead of choosing {?pm-?date}, use the drop down to choose {?date}. The parameter prompt will appear only once for the main report.

I'm assuming that you are grouping on companyID and placing the subreport in the group header or footer.

-LB