Cognos 10 output to excel 2002 or 2007 single sheet

[ajen7118]

Hi all,

Just want to see if there is any solution for this.

Recently my company upgraded Cognos report from 8 to 10. By doing so, we lost the option for generating the excel single sheet.

Now, every time when i generate the report, it is separated into multiple tabs /sheets. How can i combine those tabs as one tab? Is there any thing i can do?

Please help.

thank you.

[cognostechie]

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cra.10.2.1.doc/t_config_lgwrkst_ex.html

[ajen7118]

Thanks for your reply.

Can I do this settings in report studio? I dont think i have right for IBM Cognos Administration.

Could you please explain to me with more details?

thank you very much.

[cognostechie]

I don't think it's possible in Report Studio.  It has to be done only in Cognos Administration and once it is done, it will apply to all reports . Maybe someone else knows another way to achieve this and would post here.

[ajen7118]

I see.

Thanks again for your reply.

Cognos 10 doesn't support the output of excel single sheet anymore.

I am just trying to find another way around to do it. Thanks.

[Francis aka khayman]

try this:

http://cognosm.fm3online.com/tips-and-tricks/export-to-excel-single-worksheet/

[ajen7118]

Thank you very much for the Link.

I tried but it still didnt work out. The report still broke into multiple tabs.

In the report, I have group for "Organization" item and it breaks into tabs according to it.

However, it works in Cognos 8. Please help!

[Francis aka khayman]

you sure your report has only in 1 page? if it the report formatted in several pages, cognos has no choice but to break it to several tabs.

[cognostechie]

Thank you very much for the Link.

I tried but it still didnt work out. The report still broke into multiple tabs.

In the report, I have group for "Organization" item and it breaks into tabs according to it.

However, it works in Cognos 8. Please help!

Did you mention this in your original post ? Your post led everyone to believe that it was only an upgrade issue.

If the report has a Page Set grouped by Organization then it will definitely put it in separate tabs. Did you check if it has a Page Set which is grouped or just a grouping in a Container ? Did you check if the report in version 8 is exactly the same as in 10 or something changed during the upgrade process. Which version of 10 is it?

Post full information here otherwise nobody should help you. We are not mind readers.

[Lynn]

Or is it a massive data dump that is getting split at each 65k row interval?

[ajen7118]

Did you mention this in your original post ? Your post led everyone to believe that it was only an upgrade issue.

If the report has a Page Set grouped by Organization then it will definitely put it in separate tabs. Did you check if it has a Page Set which is grouped or just a grouping in a Container ? Did you check if the report in version 8 is exactly the same as in 10 or something changed during the upgrade process. Which version of 10 is it?

Post full information here otherwise nobody should help you. We are not mind readers.

Thank you all for your kind help and sorry that i didnt explain clearly earlier.
Yes, my report has Page Set grouped by Organization. and report in version 8 (we also have Page Set grouped by Organization) is exactly the same as in version 10.2.  We didnt change anything after upgrade.
In Cognos 8, there was an export --> run report - excel (single sheet). We had no problem to export the sheet excel file.
In Cognos 10.2, there is no excel  (single sheet) option to choose. Hence, it breaks into multiple tabs. Of course, i can remove "Page Set grouped by Organization" , but the format is weird.
I am just hoping there is a way to work around.  Also my total data is only about 17K rows.

thank you

[Lynn]

... but the format is weird ...

A page set is going to break the output into tabs when run to Excel. If you can elaborate on what is weird about the format then you might get further advice on how to work around it.

[ajen7118]

Hi Lynn,

What i meant is if Cognos 10 doesnt support single sheet for excel export, then there is no work around on that?

My ultimate goal is to generate the single sheet excel report like i did in Cognos 8.

Thanks.

[Lynn]

You will have to remove the page set. As I said in my last post, explain why that is a problem and you may get further assistance.


Sent from my iPhone using Tapatalk

[tgs728]

HI ,

You can use this .

http://www-01.ibm.com/support/docview.wss?uid=swg21419957

Thanks,
TGS