Method:Classic General Q&A

Re: Report Designer

andy — Fri, 21 Jun 2013 09:47:18 GMT

Ashur,

that's a great help, many thanks.

Re: Report Designer

Method_Ashur — Thu, 20 Jun 2013 21:58:12 GMT

Hey andy,

I'm still looking into hiding the months that have 0 cases created in them but I can give you some info on how to show only the last 6 months. You'll need to add some actions to your screen which is generating the report and then use that data as the filter in the Generate Report action.

In a nutshell I assigned the current date/time to an Action Result, used that in a Date Function action to grab the first day of the current month, used that in a Date Add action to add -6 months (subtract 6 months) from the first day of the current month, then used that as my filter in the Generate Report action. Screenshot of my actions below.

- Ashur

Report Designer

andy — Thu, 20 Jun 2013 10:25:01 GMT

I'm creating some custom dashboard reports for cases.

I have a bar graph showing number of cases created by month.

Is there a way of hiding those months where no cases were created, or only showing values for the last six months.? Just looking at ways of reducing the size of tthe graph on-screen.