Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Cross-Tab question Post Reply Post New Topic
Author Message
Dave@Unitus
Newbie
Newbie


Joined: 14 Aug 2012
Location: United States
Online Status: Offline
Posts: 2
Quote Dave@Unitus Replybullet Topic: Cross-Tab question
    Posted: 14 Aug 2012 at 12:53pm
Hello!
 
I'm building a new report using cross-tab. This report is for our call center. I'm trying to get a sum of the number of wrap up codes used by the representatives between two dates. The two parameters i'm using are:
   1) Customer Service Rep
   2) Date
 
I've organized the Cross-Tab with the different wrapup codes on as columns & the CSR's as rows.
 
                                    Transfer    Hours    History
                             CSR1
                             CSR2
                             CSR3
 
I was able to get the parameter setup and working for the CSR portion, but need help with the parameter for the dates. To get the CSR's portion working, I needed to add the CSR parameter to the first column and take out the original CSR field. Since i'm not showing any date fields, i'm not sure how to handle this problem. Any help would be greatly appreciated!
 
I'm pretty new at crystal reports. I'm using Crystal Reports XI. I'm decent at SQL.
 
Thanks in advance!
 
Dave
IP IP Logged
XCom69
Newbie
Newbie
Avatar

Joined: 14 Aug 2012
Location: South Africa
Online Status: Offline
Posts: 7
Quote XCom69 Replybullet Posted: 14 Aug 2012 at 9:32pm
I am not really understanding your question, but I think if you take a look at the display string function for the CSR rows you might find what you are looking for.

You can just right click on the CSR row -> Format Field -> Common Tab -> just look for the 1-x button next to display string and then create your own logic in there
IP IP Logged
Dave@Unitus
Newbie
Newbie


Joined: 14 Aug 2012
Location: United States
Online Status: Offline
Posts: 2
Quote Dave@Unitus Replybullet Posted: 15 Aug 2012 at 5:54am
This helps! Thanks. To clarify, i'm attempting to get the cross tab to filter on the date parameter and the CSR parameter. I got the CSR parameter to work, but having problems with the date parameter.
 
Again, thanks!
 
Dave
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.