If you would actually do an effort and read my SQL you'll see that it's a self join as I use 'table' twice with different aliases. I realize you might...

I agree, if you add a Group Total Row in SSRS you can easily make that one bold. Also, you should avoid hard coding field values into your report as...

why don't yo do it in SQL?

Fill your data set with

Select

T1.TotalMins - (T2.TotalMins/T1.TotalMins) as Change%,

|AllNeededFields|,

FROM table T1

join table T2

on T2.|PKey|= T1.|PKey|

and T2.[Year]= T1.[Year]+ 1

where T1.[Year] = @CurrentYear

your images are down...

but if you're talking about NULL, you should use isnothing() in SSRS

I don't know even know if that works but it's worth a try.

If you add a case statement to the start of your stored procedure like

case when @Filter = 1...

I suppose it's for SSRS? I recognize you from that forum.

Then you could use the expression =MonthName(Month(Fields!Date.Value),true) in your report.

try HAVING ( (convert(date,admdate_dte,101) >= @ADMDATESTART) AND (convert(date,admdate_dte,101) <= @ADMDATEEND))

Or 103, depends your date encoding.

I'm not sure how it goes with ASP. But in normal execution I would make the user parameter hidden (not internal) and provide no default values for other parameters. This...

Try

iif(IsNothing(Fields!attend_edate.Value)=1 AND ...)

Using AND does work correctly

I've found this...

But according to this blog the method I used should definately work.

You might want to post on MSDN forums if noone can help you here

It beats me 🙁 I have this setup working on a 2008R2 but it shouldn't make any difference.

Does it also show this way in BIDS preview?

If you're a 100% sure then I'm clueless as I have it working right now in front of my eyes.

Select the placeholder, view properties F4, MarkupType should say HTML.

did you do the first step?

are you running SSRS 2005?

ok, that's why we're here.

Right click on your placeholder in SSRS and click Placeholder Properties.

Within the general tab, choose radio button "HTML - Interpret ..." and click OK.

Now go to...

as I already said, you can if you wrap them in html tags. You could use Replace() in you SQL query.