0 Replies Latest reply on Mar 11, 2010 1:43 PM by xxx202xxx

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

    xxx202xxx

      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.