I am creating a report that contains 3 subreports. The main report and the subreports all pull from the same tables (3 tables - and 1 of these are brought in 5 times to join to different fields. It's not my database - I would not have set it up this way!!).
Subreport #1 gives weekly figures; subreport #2 gives monthly figures; and subreport #3 gives yearly figures. Each of the reports (main & subreports) use a StartDate parameter.
If I do not link the subreports with the main report, the data is correct - just just repeats itself 7 times, so instead of a 20 page report - I now have 140 page report.
If I link based on the FileID (primary key), I only get 1/2 the data, and repeats itself 49 times, so instead of a 1 page report - I now have a 49 page report.
If I link based on the ReportDate (field used in parameter) I get the same 1/2 data as with the File ID, and repeats itself 49 times, so instead of a 1 page report - I now have a 49 page report.
All of these happen if I add 1 subreport or all 3 subreport.
Please help - this is driving me nuts.
Subreport #1 gives weekly figures; subreport #2 gives monthly figures; and subreport #3 gives yearly figures. Each of the reports (main & subreports) use a StartDate parameter.
If I do not link the subreports with the main report, the data is correct - just just repeats itself 7 times, so instead of a 20 page report - I now have 140 page report.
If I link based on the FileID (primary key), I only get 1/2 the data, and repeats itself 49 times, so instead of a 1 page report - I now have a 49 page report.
If I link based on the ReportDate (field used in parameter) I get the same 1/2 data as with the File ID, and repeats itself 49 times, so instead of a 1 page report - I now have a 49 page report.
All of these happen if I add 1 subreport or all 3 subreport.
Please help - this is driving me nuts.