How to export cross tab to excel without the step appearance

[tcbc]

How can I export a cross tab to excel with the spreadsheet looking like steps.


domestic
longhair
cat
xxx

I want it to look like
xxx cat longhair domestic

 

[lbass]

We don't know how you got the step appearance in the first place. Please describe the layout of the crosstab, columns, rows, summary field, and what you have set in the customize style tab. You might need to create a manual crosstab--not sure.

-LB

 

[tcbc]

lbass. I tried the cross tab that you helped me with on the weekend.

How to flatten table. the 123 cat shorthair domesitic both.

You crystal report works great and appears as I want it to but when I export to excel it comes out in the steps.

 

[lbass]

Sorry, but I don't know what you are referring to, so please cite the thread number.

-LB

 

[tcbc]

Answer was to export to excel without using the Data only option but rather with header and footer

 

[lbass]

Please use the second solution in that
thread149-1529329. Also, it would have been better had you stayed within that thread.

-LB