Grouping on a value that may exist in 3 different fields.

[jlbsloan]

I have a report that deals with phone calls and the database has a call number and 3 different fields of operator1, operator2, and operator3. I need to be able to group the calls by operator. How can I make the call show up in the operators group whether they were the 1st, 2nd, or 3rd operator on the call.I just want to list the calls under each operator that they were a part of.

Thanks for any help offered.

 

[kenhamady]

When you have all three operators on the call, you want the record to show up in all three groups? Crystal won't do that.

You would have to do something like a union query to get three copies of the records appended into one table with all three fields showing in one column.

Or, you could do a linked subreport for each operator, looking for them in any one of the three fields each time. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[jlbsloan]

I am only using crystal reports 8. Is there a way to create this table or query where it will refresh every time before the report is run. This report is to be distributed to customers and run through a viewer control in an application. If so, then where do I write the SQL statement to do this, this is in a linked subreport with a SQL database.

Thanks.

 

[kenhamady]

This is already a single subreport linked to a main report? The main report isn't grouped by operator, by any chance. You can't put a subreport in a subreport.

Can you create a stored procedure in the SQL level or are you limited to report tools? Crystal has a SQL editor that can feed a report, but they don't recommend using it in conjunction with an application. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[jlbsloan]

this is one of 7 subreports linked to a main report and no , none of the others are grouped by operator. I am limited to only the crystal tools.

 

[kenhamady]

Unless the main report is grouped by operator , and you can run a separate subreport for each group of the main report, I can see now way to do what you want within Crystal.

You could create a separate report for this (Group by operator, subreport for each) but this can't then be a subreport of the original. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)