If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Preserving parameter formatting

Started by jgigliotti, 08 Apr 2006 10:17:49 AM

Previous topic - Next topic

jgigliotti

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!

zenith

Can you be a bit more specific in this case , what formating are u applying on the parameters ? ;D

jgigliotti

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.

zenith

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

jgigliotti

Unfortunately, we need to be able to accomodate up to 2000 characters, so breaking into 2 different text boxes would not be sufficient.

zenith

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