Excel 2002 output is running fine but the same is not working in excel 2007.

[krishnadwbi]

Hi All,

In environment, we can able to run the report studio report in Excel 2002 but the same is not working in 2007. Version is Cognos 10.2.2 FP6.

Please suggest me any solution.

Please find the attached screen shot for reference of the error.

Regards
Krishna M

[MFGF]

Hi All,

In environment, we can able to run the report studio report in Excel 2002 but the same is not working in 2007. Version is Cognos 10.2.2 FP6.

Please suggest me any solution.

Please find the attached screen shot for reference of the error.

Regards
Krishna M

Hi,

RSV-SRV-0040 is a generic error that means the report service crashed for some reason. Are there any entries in cogserver.log that give any clues? I would start removing queries one by one to see if the error is caused by a specific query in the report. If you can isolate which one, you can then dig into the items/prompts etc to see if any of them are causing the issue.

Cheers!

MF.

[krishnadwbi]

Thanks MF,

As per your suggestion  I have verified report design but no use.

When we try to run with less data like 1 month we are able to see output in Excel 2007. If we try same running for 6 months we are getting mentioned error.

Not understanding how to resolve. Users are waiting for this resolution.

Regards
Krishna M

[MFGF]

Thanks MF,

As per your suggestion  I have verified report design but no use.

When we try to run with less data like 1 month we are able to see output in Excel 2007. If we try same running for 6 months we are getting mentioned error.

Not understanding how to resolve. Users are waiting for this resolution.

Regards
Krishna M

How many rows of data are we talking about rendering here? Is your report service set to 32-bit or 64-bit? Did you look in cogserver.log to see if there are any errors reported there?

What do you mean by "I have verified report design but no use"? Is it a multi-query report? Have you tried removing individual queries to see if you can isolate which one? If it still happens with a single query, how much can it be simplified before the problem doesn't happen?

MF.

If it's a critical issue and users are waiting for you to resolve it, I'd seriously consider logging it as a support call with IBM.