Multiple Date parameters with subreport(s) to main report. on popup.

[larz34]

I'm having a strange problem with multiple date parameters showing up on a report I'm developing. Insead of only one date parameter showing up for the main report and all sub reports, I'm getting a date parameter for the main report, and every sub report enbedded within the report! I already linked the date parameters from the sub reports to the main report, and they are still showing up. I only want (1) date parameter value to drive all of the subreports and main report. Below is an example:
****************************************************
Enter StartDate: StartDate

Enter EndDate: EndDate

Enter DateType: DateType


Enter a Value:


Enter StartDate: StartDate


Enter EndDate: EndDate


Enter DateType: DateType


Enter a Value:


*******************************************************

 

[briangriffin]

When you're editing the subreport links, and select the main report parameter as the field to link to, you'll probably see two parameters in the 'Subreport parameter field to use' dropdown:

?Pm-?YourDateParameter
and
?YourDateParameter


Use the second one - the first one is created by CR but isn't needed when the subreports contain matching parameter fields.

 

[larz34]

The only (2) options I have under "subreport parameter field to use: are "Parameter Fields" and ?PM - Interpreted start date, ?PM end date, etc...

I pick "Parameter fields" rather than ?PM fields are it defaults back to ?PM fields.

Does this make sense?

Then I hit F5 and it still shows multiple date parameters for all subreports. I don't understand why on earth it CR would default in this manner, because when I link the subreports to the main report to me logically it should just default to (1) date parameter from the main report to drive all the subreports.. but there is probably a reason

 

[briangriffin]

I would bet you have a datatype mismatch in your parameter fields - for instance, the main parameter is defined as a date, but the subreport parameters are defined as datetime. That would explain this behavior.