Reports by Input Date

[liquidzoo]

I have one report that houses 6 sub reports. What I would like to do is have it prompt for, or accept date input from a form and filter that input to all of the sub reports.

I can get it to prompt, that's not the issue. What I want it to do is have 2 sub reports show for the day before the input date, 2 for the same date, and 2 for the next date. I can get this working in a single report just testing it with 3 text boxes, but I can't seem to figure out how to filter that to the sub reports. Can anyone point me in the right direction?

 

[HiTechCoach]

I have one report that houses 6 sub reports. What I would like to do is have it prompt for, or accept date input from a form and filter that input to all of the sub reports.

I can get it to prompt, that's not the issue. What I want it to do is have 2 sub reports show for the day before the input date, 2 for the same date, and 2 for the next date. I can get this working in a single report just testing it with 3 text boxes, but I can't seem to figure out how to filter that to the sub reports. Can anyone point me in the right direction?

Are you using a form to collect the data?

 

[liquidzoo]

Right now the date is hard coded into the queries of the reports. Ideally it would be done either through a form or just from a [Input Date] criteria in the query. If I used a form, would this be easier to accomplish?