I have followed what is suggested. Here is what I get in the report
Order 1 --- Item 1 Shipped
Order 2 --- Item 1 Shipped
Order 2 --- Item 2 Shipped.
But I do not want Order 1 because it has an outstanding order. I only want to prit out order with all items shipped.
I have two tables one has the order number and the other has the item being ordered and shipment status like below
order1 ------ Item 1, Shipped
------ Item 2, On-order
order 2 ----- Item 1, Shipped
----- Item 2, Shipped
How can I show only order with all items being...
I have two tables like below
Table 1 Table 2
seq1 timestamp status seq1 timestamp status
seq2 timestamp status
There is no link betwenn the two tables. How can I plot the number of records by month in table 1 and 2 in the same line graph?
Thanks.
Thank you for the quick response.
As far as setting up a Formula, it is a simple way and works fine for the group with "Resolved".
If I want the group without "Resolved", I thought I flip the statement from 1 to 0 like below
if {table.status} = "Resolved" then 0
But it prints out both...
I have these groups of data
Group1
open 2011/04/04 12:00 AM
alert 2011/04/04 03:00 AM
resolved 2011/04/05 08:00 PM
Group2
open 2011/04/04 12:00 AM
alert 2011/04/04 03:00 AM
Group3
..
..
Group4
I only want to print out the group that does not have the line "resolved"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.