Report based on Date with multiple different tables

  • Thread starter Thread starter John B
  • Start date Start date
J

John B

I am attempting to create a Status report that contains information from two
tables (lists in Sharepoint). One is status text that contains a week ending
date. The other is a task list with both a due date and complete date.

What I need to do is allow the user to pick the week ending date and
generate a report that includes
Status Text
Tasks complete in the last week
Tasks Planned in next 30 days

I can create queries that get the data.

I have created a form and used a function to open the report with a where
clause.
But the report only shows one table of information.
What I want to do is 'append' three reports so the users get one printed
report with the different types of informaiton.
Any assistance is greatly appreciated.
 
Yep,
I created a master report with three separate sub-reports and use a date
field on an unbounded form in each of the queries that drive each sub-report.
Thanks
 
Back
Top