Also on the sorts do you have to use a Parameter? SSRS/Report Builder let you create Interactive sorting on the column. After the report is run the user can decide...

Not that I am aware of, however you may be able to get crafty with some cascading parameters. Just built one today that is very slick:-D

Not sure why its giving you a hard time. I had built a dashboard that compares the current year vs the past year two different datasets. Here is from one...

I could have sworn I have done this before. Let me look at some of my old rdl's. I don't think I used look up either. I may have done...

If you just need the one result percentage then use a calculated field possible?

If you cant resolve this via SQL code or use any kind of Groupings in the rdl then you could try something like this "Psuedo Code"

[Code="sql"]SUM(IIF(Fields!Month.Value = "January" ,...

Doesn't SSRS allow active user sorting on the column. I could swear I have done that before. Interactive sorting on the Text box. Have you played with that at all?

Ignore my first attempt here you go.

SELECT substring('99.78%',1,len('99.78%')-2) + '%'

Thanks!

I'm not too god with these but this works as long as the % doesn't go over 99.99

SELECT SUBSTRING('99.87%', LEN('99.87%') -5,4)+'%'

That's what I meant. Bad choice of words on my part again. It is no longer offered is what I meant to say.

I thought the 2008 cert was expired anyway? Am I wrong on that? I'm currently studying for the 2012 myself even though I only work on 2008 R2. Most of...

Jack Corbett (9/9/2014)

---

KoldCoffee (9/9/2014)

---

Yeah, I'm learning SSRS. My boss knows that.

I'm asking for help with one small part of a report and not for advise on...

I saw that very bad wording on my part.

I'm a noob but Predicates only evaluate to TRUE. Also NULL is not a value. Query 3 is correct as far as my very limited knowledge goes.

So it skips in...