I've spoken to the person who requested this in the first place, it seems that the time it would take to build something reliable isn't worth it for its use...

Bah! - I read your original response and thought great! but how, I was just going to ask for further explanation.

:/ ah well... thanks anyway 🙂

Thank you so much, I name my parameters in SSRS reports the same as I do within the SP - makes this fix a breeze. As with others I couldn't...

Okay so I sussed out my own problem here... create the parameters on the main report, add the parameters on the sub report with identical names, for the Values use...

Oh right, cool 😀

thanks for pointing that out

On and it's probably obvious but why are the last 3 tutorials greyed out?!

I've looked at bits of those articles yes, I'll look at all of them in more detail though.

Somebody suggested a learning tree course and said they were good. It...

I've been using SSRS for a few months but I seem to run into problems with a few things and then sometimes am able to solve them via the web,...

Gah, I got well into looking at this and then discovered that it's only in the Enterprise edition of SQL 🙁

Thanks for the pointer - it's exactly what I'm looking...

Well, it's good that I'm not going mental, but it's a bit crap that that bodge is the best way to do it! - Gah!

Can't believe I have a Sams...

Ahh so essentially use the query behind the stored procedure and then change code from query with text to SP? - Theoretically the columns should be the same too.

I...

Finally sorted it out! - I was joining to another database which the user account I'm using in SSRS did not have permissions to access. I only got a half...

I've not tried that no, because whilst it would be a trivial exercise in this example it's real world usage would be on a report which has quite a few...

Happening on another report now. The same error as above, the report has quite a few columns so I guess is fairly hefty from a data perspective - 49 columns,...

Daniel, I've made some progress on the colour front. I used the iif side of things for my first attempt which seemed to work, not sure why it didn't before!...