Conditional Output for Excel Report

[tianna9]

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!

[Gopinath]

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)))

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