MetaManager - Administrative Tools for IBM CognosPricing starting at $2,100Download Now Learn More
Started by tinas, 01 Jun 2007 12:55:09 PM
Quote from: MDXpressor on 02 Jun 2007 09:11:41 PMThere is a knack to rendering Excel, for sure. The secret is in creating tables in the Header and Footer which match the same number columns you have in your list/container. You can then use cell-merge to create structure in your Header or Footer. The most important part of it is to leave 1 row in the table with no merged cells. In order to hide that row, I will then normally select the Row (through the parentage selector on the Properties pane) and set it's box type to 'None'. By setting the unmerged line to None it doesn't create the blank row, but more importantly, it keeps the integrity of the auto-size on the data container instead a text item in the Header or Footer.
Quote from: bbtresoo on 16 Dec 2014 11:07:31 PMHi MDX,Ur work around works fine except for image , I have an image right aligned in a table cell which looks fine on pdf but shows up left aligned in Excel, Do u have any ideas how Can I nail it.Any help will be appreciated . Tks Cognos 10.2.2Report Studio
Quote from: MFGF on 17 Dec 2014 03:54:29 AMNot all formatting options in Report Studio are supported in Excel - for example, table widths in % are not supported, nested tables are merged into a single table etc. Take a look at Appendix E of the Report Studio User Guide to see what is not supported - this might give you ideas about how you can change the structure of your report to something Excel can handle.http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1.1/ug_cr_rptstd.pdfCheers!MF.