Preserving parameter formatting

[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 ?

[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