Page 1 of 1

How to remove &nbsp from report

Posted: Fri May 20, 2011 7:35 am
by myintw
Hi,

I want to remove &nbsp from my rtf report. In my report, I get value from GridView and export it to rtf. The problem I have in my report is, null value or blank/no value is filled by &nbsp. For instance,

I would like to display like:

Company| Address | Contact | Country | Email
AAA LA 989877 USA aa@AAA.com
BBB CA 879989 bb@BBB.com
CCC 889977 cc@CCC.com

In my report is like:

Company | Address | Contact | Country | Email
AAA LA 989877 USA aa@AAA.com
BBB CA 879989 &nbsp bb@BBB.com
CCC &nbsp 889977 &nbsp cc@CCC.com

Could you please tell me how to remove this &nbsp from my report and just display blank instead of this. I tried with Text.Trim(); But it doesn't work. Any idea, to solve this out, please. Thanks in advance to Stimulsoft team.

Regards,
Win

How to remove &nbsp from report

Posted: Mon May 23, 2011 12:42 am
by Alex K.
Hello,

As a way, you can try to use the following expression:
DataSource.Column.Replace("&nbsp", "")

Thank you.

How to remove &nbsp from report

Posted: Tue May 24, 2011 7:00 am
by myintw
Hi Aleksey,
Thanks, I tried the way you said and it worked.

Cheers

How to remove &nbsp from report

Posted: Tue May 24, 2011 1:04 pm
by Andrew
Hello,

Perfect.

Have a nice day!
Thank you.