In your properties window - Select "Report"...

Piotr Ryszkowski (7/16/2009)

---

I know it's very old question but i think explanation here is wrong. Output is 0 not because there's no rows updated but because @@rowcount holds number of...

You right SSRS will put a "Select All" option for Multi-Value Parameters. However, if you want the user to only select either one option or everything it won't work. Also,...

Your main Report Dataset needs to look something like this

select * from cateogortTbl

where cateogoryID=@Cateogory or @Cateogory = 'All Cateogories'

Now you create a new Report Dataset that just Lists the Dropdown...

WOW Hugo. Thanks for the question. Really had me thinking.

unibrow

Great question Carlo and thank you Hugo for the great explanations.

Thanks Hugo. Great Question.

da-zero (8/11/2010)

---

Developer 2005 (8/11/2010)

---

Both Question and answer don't have sufficient information about target.

What is the purpose of IDENTITY_INSERT ?

And answer

SET IDENTITY_INSERT allows explicit values to be inserted into the...

Great question and even better explanation. Thank You.

Great Question. Thank you.

Wow. Really great article. I will never again use pivot. CROSS TAB all the way.

Nice question.

Great DMV. Thanks for the question.

Good Question. Thank you