Multiple queries in a report.

[Matt Brown]

I am trying to create a report where the user can enter 5 "from" and "to" dates and then the data would be listed in the report across all of these date ranges.The date ranges are various weeks in a month
ie 01/08/00 to 07/08/00.
I am trying to get the report to list the data in 5 separate columns on the same report , each column has its own "From" and "To" dates from an underlying query.
IOs this possible to do and how can i create this report?
Thanx in advance
Matt

 

[dhoffman]

I have absolutely no idea if this would work, but the first idea that came to my mind would be to use five subreports inserted onto the one main report. Each of the five subreports would be the same report with a parameter query (the parameters being the beg and end dates) as the data source. Possibly each subreport would run independently so five different ranges could be entered. But maybe the subreports, being the same, would only run once and then be duplicated four times, though I doubt it.

 

[sfarr]

In versions 97 and 95, dhoffman's suggestion does work. I've had to create reports which have different date (another other paramaters). These reports do take some time to generate.What I haven't done is put the different data in column form. Instead, my subreports are found in group footers; viewed as different rows.

 

[Matt Brown]

Thanks dhoffman and sfarr,
I will give this a go and let you know how i get on with it.
Matt