on 09-26-2008 3:32 PM
This is a newbie question. I have created a crystal report and bar chart for trouble tickets entered against circuits. I have grouped the results based on the circuit name. I have also added a summary count for each circuit to show the circuit name and the total tickets entered.
My boss wants me to only show records where the count is greater than 2, so I used the select expert to show this:
Count ({Trouble_Ticket.CKT ID:}, {Trouble_Ticket.CKT ID:}) > 1 and
Count ({Trouble_Ticket.CKT ID:}, {Trouble_Ticket.Create Date}, "monthly") > 1
I ran the report and it works fine. However, the chart that is part of the report still shows records with a count of 1 or less. I want to suppress any records in the chart where the count of tickets against a circuit is less than or equal to one. For some reason, only the report seems to reflect the change in count. Any ideas?
Ben
Ben,
Try replacing the on change of field in the chart with a formula that outputs the onchange of field when the count is > 2.
If Count ({Trouble_Ticket.CKT ID:}, {Trouble_Ticket.CKT ID:}) > 1 and
Count ({Trouble_Ticket.CKT ID:}, {Trouble_Ticket.Create Date}, "monthly") > 1 then
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you try placing this condition in group selection expert?
Count ({Trouble_Ticket.CKT ID:}, {Trouble_Ticket.CKT ID:}) > 1 and
Count ({Trouble_Ticket.CKT ID:}, {Trouble_Ticket.Create Date}, "monthly") > 1
Regards,
Raghavendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.