Export to Excel Data Only

[AnnieRider]

Is there anyway to do this as there was in Crystal, we don't have the option in the drop down menu for exporting but was wondering if there is anywhere in the report I can set this?

Many Thanks
Annie

 

[xlbo]

Maybe try export to CSV...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AnnieRider]

Hi Geoff, thanks for your reply.

Unfortunately exporting to .csv means that the whole of one row is entered into one cell and the Users cannot sort on column.

What we really need to do is export just the data and not all the report formating.

Regards
Annie

 

[xlbo]

Shouldn;t do that - that would indicate that the import from csv into excel is not working properly

I have exported data into csv and then into excel and it seems to work fine

Maybe try changing the file extension to .txt and then using the import wizard into excel to determine your field delimiters or use "Text To columns" once in excel to acheive the same thing

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question