ta -- sql server reporting services

Michael
4/26/2005 5:34:04 AM

Here is an example

Input Text: tester#$#bullet_1#$#bullet_2#$#bullet_3#$#bullet_4

Regular Expression: (ASCII char Octal) \043\044\043

Replace Expression: (ASCII char Octal) \015\011\052\040\040\040

Question: Is there a Code Customization example for parsing a textbox field
and replacing regular expression characters with HTML Bullets - like
<BR><FONT family=Wingding>something_bullet_symbol</FONT><TAB>

Please advise.

[quoted text, click to view]

Michael
4/27/2005 6:28:12 AM

I tried this expression

=IIF(Fields!product_Bullets.Value=#$#, Fields!product_Bullets.Value=*)

Got the following error

The value expression for the textbox â€˜Product_Bulletsâ€™ contains an error:
[BC30201] Expression expected.

Please advise the correct expression syntax.

[quoted text, click to view]

Michael
4/27/2005 2:53:30 PM

I tried this expression -

=IIF(Fields!product_Bullets.Value="chr(35) + chr(36) + chr(35)", "",chr(13)
+ chr(42) + chr(9))

[quoted text, click to view]

Michael
5/3/2005 10:34:07 AM

Please help with regular expression syntax.

I have tried both these two expressions, using ascii hex - but I am still
getting lost on the on whether or not Reporting Services will support the
Replace function including a ascii hex Carriage Return or an ascii hex
Horizontal Tab replace string...?

=Replace(Fields!product_Bullets.Value, "[chr(35) + chr(36) + chr(35)]",
"chr(13) + chr(42) + chr(9)", "1", "-1", "1")

=Replace(Fields!product_Bullets.Value, "([\x23][\x24][\x23])",
"([\xD][\x2A][\x9])", "1", "-1", "1")

Please advise any suggestions for correct regular expression syntax.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : ta