ansaurus

Question

How to hide certain on SQL Reporting Services 2005

Answer 1

+1 A:

Use string.replace in the eypressions field to strip out the tags, perhaps.

The tags are most likely not coming from SSRS but are in your data. At least, I've never seen it SSRS add HTML tags...

gbn 2009-08-04 20:12:45

I dont want replace any string. All I need write somehting that those HTML tags not to show. For example I want to write an expression saying if or occurs then do not show or hide otherwise show all the text. Let me know how to write an expression for this to make it happen and not to show. I really appreciate your help and kind support. Talk to you later.

2009-08-06 12:28:10

The tags are not coming from Report Server though. They must be in your data. To hide them, you'll have to replace them

gbn 2009-08-06 14:17:33

Answer 2

+2 A:

The values must be coming from the source. I've not ever seen this in SSRS.

You'll need to use an expression to remove them and depending on how many are in your data this could become burdensome. The expression Replace(Replace(Fields!Comment.Value,"",""),"","") will remove them from a field name Comment.

StrateSQL 2009-08-07 04:11:47

Thanks for the information I tried it and it works for part of it. Here what I did on the expressions.=Replace(Fields!COMMENTS.Value,"","")This expression works fine to hide only one i.e. but how to write If I have multiple text not to show such as not only but also , etc. How to write an expression by using my example above for multiple things not to show on the report.

2009-08-10 13:15:54

You'll need to keep expanding on the values to suppress. Such as, Replace(Replace(Replace(Replace(Fields!Comment.Value,"",""),"",""),"",""),"","") to suppress both the and the tags. This is likely to get combersome if there are a lot of HTML tags.

StrateSQL 2009-08-10 21:15:12

Answer 3

A:

If you want to hide any comment that uses , then try putting this in the Hidden property:

=iif(instr(Fields!Comment.Value,"<p>") > 0, True, False)

Rob Farley 2009-08-07 04:24:24

ansaurus

tags:

views:

answers:

How to hide certain on SQL Reporting Services 2005

related questions