Export to CSV Misses Columns

building reports webintelligence
1

Hello all,

I have a report which generates too many lines to export directly into Excel - yes, I know they shouldn’t but the client needs this. The workaround is that I’ve tried exporting to a CSV file and then opening this from within Excel 2007.

However the CSV file which is created misses three columns. One column is a duplicate of another and the other two hold fixed text (I don’t know whether this is relevant). Exporting the report directly to Excel gives the correct format but only a limited number of results

Has anyone come across before, and more importantly found a way around it?

Regards

Rich

RichUK :moldova: (BOB member since 2007-10-01)

2

This is how csv works, it takes objects directly from query (data provider) so if you are showing duplicate columns or report level variables, they will be missed out in csv extract.

A way around is to store data in multiple tabs in excel, you will find many posts explaining that process.

Prashant Purohit :india: (BOB member since 2009-02-18)

3

Well, I did not know that.

Thanks very much for your reply.

RichUK :moldova: (BOB member since 2007-10-01)