SSRS: My Filter is not Working!!!

Who is online?  0 guests and 0 members
Home  »  Blogs  »  PatrickLeBlanc  »  SSRS: My Filter is not Working!!!
 
0
/5
Avg: 0/5: (0 votes)

Comments (4)

meganathank
meganathank said:

This is cool, Patrick. Thanks

3/7/2011
 · 
 
by
Daniel
Daniel said:

I use VARCHAR in most situations, but this is a useful tidbit of knowledge for those situations when a CHAR is in play.

Also, I am curious.  The secion above you have highlighted in yellow.  I would have written it like:

CAST(ISNULL(Color,'N/A') AS CHAR(10))  Color,

Did you have a reason for using the CASE statement, or is that just the way it came out?  There are always several ways to write the same thing and I like to learn why others make the choices they do.

Thanks,

3/8/2011
 · 
 
by
PatrickLeBlanc

I did not have a reason for using the CASE statement.  I actually did not think about it.  Thank.

3/8/2011
 · 
 
by
user809339
user809339 said:
All I can say is that this saved me a huge amount to time and effort. I have 4 tables using the same dataset but filtering on green, blue, yellow and red. Sometimes the blue table would not display and sometimes the blue and yellow. I just get this feeling that I could have WASTED a huge amount of time trying to sort out this MS problem! Thanks for this article!!!
24 days ago
 · 
 
by
Blogs RSS Feed

PatrickLeBlanc's latest blog posts

Blogs RSS Feed

Latest community blog posts