COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: jgigliotti on 08 Apr 2006 10:17:49 AM

Title: Preserving parameter formatting
Post by: jgigliotti on 08 Apr 2006 10:17:49 AM
We are running into problems when it comes to formatting parameters within a report.Ã,  We need to preserve formatting that is entered into a parameter text field such as line breaking, tabbing, etc.Ã,  Our displays are only returning one long string when generating in PDF.Ã,  Does anyone have a solution for this?

Thank you!
Title: Re: Preserving parameter formatting
Post by: zenith on 10 Apr 2006 12:40:34 AM
Can you be a bit more specific in this case , what formating are u applying on the parameters ? ;D
Title: Re: Preserving parameter formatting
Post by: jgigliotti on 10 Apr 2006 09:09:00 AM
The parameter is just a large text area (should be able to accomodate up to 2000 characters).   The client would like to preserve carriage returns and tabbing within the text.   For instance, the client is to type in the services provided by a community as a list, ie:

WIC - ABC Consulting
Counseling Services - Columbus Health

When this is passed into the report, it's reformatted to just be one long string "WIC - ABC Consulting Counseling Services - Columbus Health"

Thanks for your assistance.
Title: Re: Preserving parameter formatting
Post by: zenith on 10 Apr 2006 11:06:04 AM
Have one suggestion have you tried using 2 input boxes for your list
This might help instead of using 1 and then u can probably merge your parameter inputs
so that the reformating is avoided
Or there could be some way thru using tabular sql in this case
Title: Re: Preserving parameter formatting
Post by: jgigliotti on 12 Apr 2006 12:50:18 PM
Unfortunately, we need to be able to accomodate up to 2000 characters, so breaking into 2 different text boxes would not be sufficient.
Title: Re: Preserving parameter formatting
Post by: zenith on 15 Apr 2006 05:32:49 AM
Have you also tried changing the data type at the Dbase level
Like using long instead of varchar , this also might help in accomodating ur large string