HOw to Trim parameter value

[sregmi]

hi everyone,

Is there anyway I could trim the parameter value displayed. Here is the situation:
I am displaying the parameter values along with, "Filtered by" at the bottom of the report page using Layout expression of the Calculation. If I am filtering, let's say, by region: 'NorthTexas, ' and 'CentralTexas' I would like to have Just 'NorthTexas, CentralTexas'. Instead, it is printing 'NorthTexas , CentralTexas' or something like that.

Any help/suggestions/tips most appreciated!
(Substring won't help; rtrim does not seem to be helping either!)

 

[sregmi]

I am in CRN.... Sorry

 

[ChillAPAC]

What database are you using?

 

[sregmi]

Hi ChillAPAC,

I am in SQL Server 2000. Thanks for the response and sorry for not getting back right a way.

Regards.......SR

 

[DataVixen]

There should be a common functions folder with a trim function. The syntax is : trim(<value>)

 

[sregmi]

Thanks to Chillapac and TataVixen,

I got it resolved by trimming the value at the report query itself.

Thanks to everyone trying to help me.

Regards.........SR