AnsweredAssumed Answered

Querying data between two dates and creating a report with that data

Question asked by xxx202xxx on Mar 11, 2010

Title

Querying data between two dates and creating a report with that data

Post

I have a project I would like to complete but I am having problems with the behind the scenes stuff.  I want to be able to compile a report where I am pulling data from different layouts to complete the report.  Here are the parameters;

 

1. Time range = 05:00 Monday thru 18:00 Friday.

2. Report to be generated automatically and saved as a PDF file.

3. Fields from the "Trouble" Layout are "Site", "Tech" and their "ticketsopened", "Ticketsclosed", "TicketCarryOvers".

4. I would like a talley for each field for each day of the date range with the total talley at the end for each ticket field. 

 

The report could very well be a excel spreadsheet that is created.  I just want it automated so I don't have to enter data multiple times.

Outcomes