Method:Classic General Q&A

Re: Summary report for Work Orders

fran — Thu, 17 Mar 2016 14:50:53 GMT

Hi ITfrom Valor,

One of the tricks used to generate report filters is to add two variable fields to the COMPANY table, Like RptDate1, RptDate2. The Company table has only 1 record and it is available for every report.

Then on your screen - set up fields to choose your dates. Through actions, populate these values to your company table fields.

In report designer, then use these fields to filter your report.

Summary report for Work Orders

ITfromValor — Tue, 15 Mar 2016 20:26:47 GMT

Hi. I would like to create a report that would provide us with detailed list of each date (from a chosen date range) and would print out summary of how many WO were opened, completed, accepted etc. at that date. Of course I am quite uncertain it can be done in Report Designer as I am not sure how to loop through a date range selected on a screen. I will keep on thinking but any help would be greatly appreciated. Thanks,