Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
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.
 
Actually I missed to say that the report has to show count of open orders and Count(closed orders) by that user.
Thanks.
 
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.
 
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").
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,
 
Hi Piperp ,
I could get this report with your idea. Thank You very much.

Thanks
 
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,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top