Grouping

[Guest_imported]

I have a table which has status of all order

User Order Id status
A 1 Open
A 1 "REPAIR" in Process
A 1 Closed
A 2 Open
A 2 "REPLACEMENT" in process
A 3 Open
A 3 "blahblah" IN process

Now my report should show that as follows
Open == all the status like "%IN PROCESS%"
------------------
User | Open | Closed
------------------
A | 3 | 1
------------------
Can any body help me do this .
Thank you.

 

[Guest_imported]

Actually I missed to say that the report has to show count of open orders and Count(closed orders) by that user.
Thanks.

 

[Piperp]

I'm new, but I just did something similar. There is probably a much easier way so if anyone else answers ignore me

I would create an if then formula to identify closed cases...if status = closed then 2 else 1.

Create a report sorted by name then by order#, then by closed formula. Put in the totals fields counts for distinct order number and the count for status formula .

this should give you the following
(1st detail)
A 1 1
A 1 1
A 2 1
A 2 1
A 3 1
A 3 1

(sub group total)
A 3 6

( 2nd DETAIL)
A 1 2

(2nd sub group total)
A 1 1

(Grand total_)
A 3 2

Now hide pull the total for status f(formula = 2) into the grand total line. HIDE everything but the grand total line.. Insert text boxes labeling the grand total of order id as open and the formula field as closed.

 

[Guest_imported]

Here requirment is different .
If we do as u suggested it will show all the orders with status other than "Closed" as "Open Orders", What I want to show is all orders with "%IN PROCESS%" as "OPEN ORDERS" (which does not include orders with "Open status&quot.
And the closed orders is easy it will be all the orders with "closed" status.

I need to create a formula somethis like this

If ({STATUS) like '%IN PROCESS%' then
"Open"
Else if {STATUS}='CLOSED' then
"Closed"

But this is not working . Hope u understand my requirement now.

Thank you,

 

[Guest_imported]

Hi Piperp ,
I could get this report with your idea. Thank You very much.

Thanks

 

[Guest_imported]

Now the problem if if there is closed order for user b and I am showing all users on the report. It showing up plike this

User Open Closed
A 3 1
B 4 0
C 5 3 (Where he actually closed only 2 orders, this is adding the previous running total value like this 1+0+2) Any help.....

Thanks,