COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: anjidwh.cognos on 11 Nov 2014 06:29:33 AM

Title: Not able to export report out put in excel
Post by: anjidwh.cognos on 11 Nov 2014 06:29:33 AM
Hi Folks,

I am using cognos 10.2 version. The report is running fine HTML. But when I am trying to export to excel the report is throwing the following error.

An error occurred while performing operation 'sqlOpenResult' status='-28'

Please advise how to get rid of this issue. Looking forward for your suggestions.

Thanks,
SR
Title: Re: Not able to export report out put in excel
Post by: BigChris on 11 Nov 2014 06:56:27 AM
When you run the report in HTML can you press "Bottom"? When you do that do you get the same error message?
Title: Re: Not able to export report out put in excel
Post by: Raghuvir on 11 Nov 2014 07:02:30 AM
Quote from: anjidwh.cognos on 11 Nov 2014 06:29:33 AM
Hi Folks,

I am using cognos 10.2 version. The report is running fine HTML. But when I am trying to export to excel the report is throwing the following error.

An error occurred while performing operation 'sqlOpenResult' status='-28'

Please advise how to get rid of this issue. Looking forward for your suggestions.

Thanks,
SR
Quote from: anjidwh.cognos on 11 Nov 2014 06:29:33 AM
Hi Folks,

I am using cognos 10.2 version. The report is running fine HTML. But when I am trying to export to excel the report is throwing the following error.

An error occurred while performing operation 'sqlOpenResult' status='-28'

Please advise how to get rid of this issue. Looking forward for your suggestions.

Thanks,
SR


Hi,

Could you please attach the detailed error screenshot ? once i was facing such issue while running the report in PDF. just want to confirm if its the same error.

Regards
Title: Re: Not able to export report out put in excel
Post by: anjidwh.cognos on 11 Nov 2014 07:05:30 AM
Sorry!!! I am not able to view the complete errror message. Only it is showing the error code. Please suggest if you have any solution.

Thanks,
SRK
Title: Re: Not able to export report out put in excel
Post by: MFGF on 12 Nov 2014 04:55:12 AM
Quote from: anjidwh.cognos on 11 Nov 2014 07:05:30 AM
Sorry!!! I am not able to view the complete errror message. Only it is showing the error code. Please suggest if you have any solution.

Thanks,
SRK

Why not? Just run the report, copy the entire error message that displays, and post it up.

Did you see Chris's question above? What happens when you try his suggestion?

MF.