Method Community

How can I filter a report tio show the date range in the existing work orders grid from the generatr report action filter?

Hello Marcelo11756,

Can you please provide more detail on it. which report you are working with and what exactly you are trying to achieve? If you can provice me the detail, that will help me in giving you right answer.

-Inder

I made a copy of the job cost and profit by customer report

Created a buton in the work order list, existing work order

I want to show the profit and loss from the work order list in the date range.

I want only work orders with completed status

Hello Marcelo11756,

You mentioned that you want the report with Completed Workorder in the specified daterange. In that case you dont have to add any button you can produce that report based on the stock screen. 

Firstly, select the date range(From Date and To Date) on the Existing Workorder Screen, then on the Status filter type "Completed". It will filter all the workorder based on Completed status.

Select the Workorders, then Click on the third tab Print/Email, then click on Selected only and then click on Job Cost Profitability by Customer button. This will generate the desired report.

I hopr this helps!

-INder