If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Excel issues

Started by ntmyslftdy, 01 Jun 2007 10:38:25 AM

Previous topic - Next topic

ntmyslftdy

We have a report that delivers data, but it's too many rows for one sheet of excel. Currently we run three separate occurences that deliver different sections of the report. Is there a better way? I would like to be able to deliver the whole report in one workbook, with the data segragated by row numbers.

Any ideas?

COGNOiSe administrator

There was a trick that used pagebreaks and rowcounts, but I'm unabel to find it at the moment ... Anyone?

MDXpressor

Not that this is a solution, but how is someone consuming more than 66,000 rows in a single file?

Is the issue that the report is just not fully developed yet?  What I mean to say is, what is the consumer doing with the file once it is in Excel?  Surely they must then be working with it and summarizing it in order to get some value from the data.  If you could replicate the work they are doing in the report, then that might serve everyone better.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

ntmyslftdy

We do summary reports as well, but we also archive data files in Excel for other purposes. Any additional help would be appreciated.

COGNOiSe administrator

If it is for archiving only, then save it a CSV and don't bother with Excel.