Is there anyway to create a cross-tab using the data/lines that are being showed in the preview section and NOT all of the detail in the report? I have a crystal report that has one grouping for transaction ID. So all of my data will be summarized and displayed as one line for each transaction ID. When I export to Excel, I get the data I want. However, I want to pull 13 months worth of data from Crystal. Pulling all the details will be too big; hence the cross-tab.

 

However, when I'm creating the cross-tab, it is summarizing the information from all the details; and not the grouped view. Is there a way to create a cross-tab utilizing just the information that is in the grouped view?

 

Thanks in advance.

 

I was able to do a distinct count off of my only grouping to produce the number I wanted in the report. So I'm making progress there. However, I want to split that distinct count number off into another grouping via a cross-tab. When I attempt to do this, I'm unable to get anything to match.

 

 

 

 

TX ID     Financial Class       Charge Amount

 

 

 

 

For the detail, I only want one TX ID represented; even though a TX ID can have multiple Financial Classes and multiple charges. So I grouped these columns by TX ID, then displayed them on the Group Footer with a Sum for the Charge Amount to tie everything out.

 

What I would like to do is to create a small 13 month cross-tab that looks like this:

 

                                             Jan 12          Dec 11           Nov 11        

 

Financial Class 1                 Sum Amt        Sum Amt         Sum Amt

                                           TX ID Count   TX ID Count    TX ID Count

 

Financial Class 2                 Sum  Amt       Sum Amt         Sum Amt

                                          TX ID Count    TX ID Count    TX ID Count

 

 

I can get the Sum Amount to distribute on the cross-tab just fine. However, the grouping of TX ID is causing issues with the count in the cross tab. The number I want to distribute is taking a Running Total  of the Distinct Count of the TX ID that evaluates on the changing of the TX ID grouping, but does not reset. That total is the correct number I want, and the number I want distributed throughout this cross-tab.

 

Hope this makes sense. I can add numbers to the visual if you would like, but I didn't know if that would cloud things further.

 

 

 

I want to take that one number and spread it out across their respective Financial Classes. I have 14 static financial classes, so the totals of those 14 finanical class TX ID counts should total out to the number I obtained through the detail section.

 

Once I get that tied back, I want to then simply go back 13 months and gather the same information.

 

I know it's probably easier to do this via logic in the detail section, but my issue is that there's so much data for 13 months, my Crystal will bomb out; thus having to go the route of the cross tab.