filtering data

[qster]

hi,
wanted to ask if anyone knew of a process
where I would be able to filter a certain end data so that is does not filter out the rest of the data.

eg. I want to filter out all tickets in a closed state done by a certain group, but would also like to see the stage processes that may include other groups while the ticket was open.

ticket group status
xx1 grp 1 WIP
xx1 grp 2 resolved
xx1 grp 1 closed

xx2 grp 3 WIP
xx2 grp 2 WIP
xx2 grp 1 resolved
xx2 grp 3 closed

xx3 grp 1 wip
xx3 grp 2 wip
xx3 grp 1 closed

now is this possible?
I was testing and testing and changing the filters using the 'select expect' but it was not getting the final result that I'm looking for. would I need to create a formula to do this?

 

[IdoMillet]

Assuming you simply don't want to see the rows with
closed status above:

In the suppress attribute of the detail section, you can enter an expression such as:

{status} = 'Closed'
---------------------------------------

If on the other hand, you want to remove all rows for the group that closed that ticket, please specify how you want to sort/group the tickets within the ticket group.

Cheers,
- Ido ixm7@psu.edu

 

[qster]

I would like to see all data that is in the closed state by a certain group regardless of which other groups may have worked on or updated the ticket.

essestially what I'd be querying is something like.
Give me all tickets "closed" by "group X" but also show which other groups may have worked/updated the ticket.

hope this clarifies

 

[IdoMillet]

What is your backend DBMS? Can you create VIEWs
or, if MS Access, queries on the DBMS.

If not, you have two choices:

1. Return all info from the DBMS and group by ticket.
Crate a total of how many tickets in that group were
closed by the group in question. Then suppress the
whole group (using the Suppress attribute of the section)
if the total is zero (meaning that this group was not closed by the group in question).

2. Alternatively, use Crystal SQL designer to create a query as the data source for the report. The SQL query would be something like:

SELECT...
FROM...
WHERE ticket_ID IN
(Select ticket_ID FROM
WHERE group_id = {?your_parameter} AND
{Status} = 'Closed'
)

hth,
- Ido


ixm7@psu.edu

 

[qster]

The data is pulled from "flat" files and imported to MS Access, then I create the report in CR 8.0

What I wanted to find out if there was an easier way to look up this query instead of fixing the data in Access.
the suggestion you gave I've already attempted and it will only show all tickets closed by 1 group.

what I'm trying to figure out is, if CR 8.0 will allow me to say; show me all tickets that are closed by group 1 but also show me all proir status for the ticekt as well as what other groups may have worked on the ticket.

i know it sounds tricky and at this point, I don't think CR will be able to understand this parameter/query

 

[IdoMillet]

You can do it using SQL designer as noted above.

Given that you are using Access, you could create a helper query within Access to get the same result.

Cheers,
- Ido ixm7@psu.edu

 

[ajca]

Group the report by Ticket ID. Create a detail line formula which = 1 if 'Group' = GRP1 AND Status = Closed. Sum that formula by the Ticket Group. Select based on Sum >= 1.

Should work!