What export option do you select when the report is in multiple columns? 1

[kernal]

I'm working with Crystal 9 and I've got the data in multiple columns but what export option do I select to export it?

Thanks

 

[hilfy]

What format are you trying to export it to?

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[kernal]

I was able to get what I needed using a different program than Crystal.

Thanks

 

[AndersonCJA]

In the Details Section Expert, check the box to format with multiple columns

 

[SkipVought]

I've often faced the situation of being given a REPORT, often a pivot of some kind, on which to perform some analysis for the boss. And that's a challenge for a spreadsheet user, because rather than using data in columns, now you also have data in rows. Very dicey! Not to mention the spreadsheet problems related to wrapped rows with headings in multiple rows or multiple row types with headings in multiple rows.

Bottom line: reports make lousy analytics.

Reports are made to tell a story at a glance. Something a manager or VP might find useful. If you've got to dig beyond that, your source should not be a report. It should be the place from which the report originated or beyond.

In almost every instance that I pulled data from business objects (stuff I could not get from our old Oracle databases) I exported a .csv simple table that I imported into my report tool (Excel) for analysis and reporting. If anyone needed DATA, I could give them the .csv to work with, NOT A REPORT!

It's is a waste of time to try to use a report to dig for data!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]