COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: tianna9 on 04 Feb 2009 12:35:06 PM

Title: Conditional Output for Excel Report
Post by: tianna9 on 04 Feb 2009 12:35:06 PM
Hello!

I'm working with Report Studio version 1.1 via OpenPages CommandCenter 8.1.

I have three questions  ???  ???  ???:

1.  It appears we are using 'Rich-Text' fields.  When the report is exported via PDF, the fields disappear.  Does anyone have a solution that they've successfully implemented that might at least print the fields on the PDF report (even if it has the HTML tags embedded within the output)?

2.  Some of the fields (description text only fields as well as Rich-Text) on the Excel outputs are '########' (Text) rather than the actual data. Only after a user changes the field to 'General' rather than 'Text' or 'Date' for example, does the data display properly.

3.  There are headers on the report which wrap in column 'A' rather than span the length of the report.


Any help is appreciated!
Title: Re: Conditional Output for Excel Report
Post by: Gopinath on 11 Feb 2009 04:23:32 AM
Quote from: tianna9 on 04 Feb 2009 12:35:06 PM
Hello!

2.  Some of the fields (description text only fields as well as Rich-Text) on the Excel outputs are '########' (Text) rather than the actual data. Only after a user changes the field to 'General' rather than 'Text' or 'Date' for example, does the data display properly.


Trim and cast those fields which appear as ##### in excel like trim(cast([Field] as varchar(100)))


Quote from: tianna9 on 04 Feb 2009 12:35:06 PM
Hello!
3.  There are headers on the report which wrap in column 'A' rather than span the length of the report.

Try placing the objects in your header inside a block