Couple of things before you set up a drill through report:

1. Have a second report ready which displays the desired output when you pass parameters like $5,000, $10,000 or the...

It worked!!

Thanks HappyCat, it was a great idea!

Hey dude, did you assign the parameters to the drill through report while defining it in the action section? If not, then click 'ADD' and you will get the...

Me neither lol! I usually modify the xml and change the servers before handing over the rdls to another team. It would be great if SSRS 2008 had a feature...

Oops..sorry dude, I forgot to include this in the problem statement: The reports will be deployed onto MS Dynamix. So there is no provision for having a shared DS.

But...

I tried different approaches but I think I have to create the object manually in the destination before I do the load as a last resort. Any suggestions about creating...

Oh shit! You made it look so easy loll...You're awesome

Thanks Lynn 🙂

Umhm ok. I will play with it. thank you Luis

I'm barely decent with Sql and I never understood how CTEs work. So I used the Cross Apply route :-p

P.S: How do you paste your code in separate box...

@luis

works like a charm. Thank you very much 🙂

Thanks guys fpr the replies.

@Craig

If March doesnt have data and in case this procedure runs for the first ever run in March, nothing happens with my code.

I am assuming you are displaying the selected parameters in the report. I don't have an answer for your question but just in case if you don't have to necessarily...

Thanks for trying it out Sean. I appreciate your time.

I hope I can explain it better in take 3 :p (This post will be epic when I look back at it 1yr from now, loll!)

Background:

There is a fact...

Apologies everybody, here is my refined version of my post.

I am new here and I will make sure I will abide by the etiquette from now. could do you...