How to combine several status into one reporting value

ibetts · ‎11-09-2017

I am trying to take a list of records with multiple status values and create a report with just two values ... open and closed so...

select from table where status in (open, pending, working, etc). open

select from table where status in (closed, cancelled, etc) closed

so on a report I get a group by x, stack by status and end up with two stack values.

Deepak Kumar5 · ‎11-09-2017

You can use "Active" field = true/false.

Bill Tang · ‎11-09-2017

I think it can be done by using 'Report ranges'

Let me run some tests and confirm it. But I am pretty sure it can be done.

Bill Tang · ‎11-12-2017

Hi Irvin, I wrote a blog to solve this with report ranges. Hopefully it is published now.