Excel Output in Reportnet

[damzi]

I have this file of abt 26 megs in excel that is saved frm Reportnet. It takes abt an hour to open on my PC. Yet another excel file of about 57 mgs - not created in Reportnet takes just a few seconds to open. Does anyone know why; and if we have a solution to this. Is this a known issue in Reportnet.

 

[indcaking]

it's suggested to use filters to avoid high volume, as cognos is reporting not extracting tool.
ther is not enough horse power for excel on l/c m/c.
but u can beat around the bush, if u cant apply filters.
try to go to ur temperary internet files folder, and save the file as .xls. and then try to open it.

 

[xoopus]

some of the excel output tyes are actually html files in an office format. They will take much longer to open as they are text, not binary.

 

[damzi]

Thanks so much for your input. Is there any solution to running these in excel on the web without the performance issues due to the html output. Like conversion to the binary as the report is running.

Am also trying to find a solution to report performance in reportnet. It seems that the reports take a longer time to run than when i use the query and run against the database. I am using SQL Server.

Thanks...