Export Cross-Tab to Excel

[OT2]

Hello, I am using Crystal 11 to create a Cross-Tab report. The cross-tab has two rows and one column. I have created custom row headers and placed them in the page header, also underlayed all sections so that the headers match up with the cross-tab rows. On screen everything looks good but when I export the results to Excel (data only) the headers dont align with the cross-tab. Is there a way of exporting all fields to Excel with the proper alignment? Thank you for your help.

 

[Madawc]

Why not define a formula field that will give the names you want to the cross-tab rows? Then it would all be easy.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[OT2]

Hi Madwac, thank you for your response. How would I insert the formulas into the cross-tab? Here is what is going on:

On screen I see this:

Account Code Ticker1 Ticker2 Ticker3
XXXXXX XXXX shares shares shares
XXXXXX XXXX shares shares shares

-----------------------------------------

In Excel I see:

Ticker1 Ticker2 Ticker3
XXXXXX XXXX shares shares shares
XXXXXX XXXX shares shares shares

Account Code

-----------------------------------------

How can I modife the c-tab so that the Account and Code fields export to Excel?

Thanks.

 

[Madawc]

You create the formula, then use Cross-tab expert to replace whatever you are currently using for 'Row'

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You can add titles to crosstabs by creating formulas like this:

whilereadingrecords;
"My Title"

Make this your row #1. However this will appear to the left of your actual row fields. I often then rotate the text 90 degrees and narrow the width of this title column. Not sure this would be acceptable for you. I am not familiar with a way to successfully export the titles the way you would like, but then I don't generally use inserted crosstabs for exporting.

-LB