- on the main report do the following for the first and second subreport
- subreport rightclick, Change Subreport Links
- remove all previous links
- select parameter for main report stored procedure click [>]
in "Subreport Parameter Field to use"
- select the parameter for the subreport main stored procedure
- the reports needs only one parameter and links it to the subreport, voila
- the datatypes MUST be of the same types
- for datetimes use DateDiff(day,date1,date2) to avoid time section problems
(this is for SQL Server)
- you can test it with Visual Studio Main Preview