multi-select drill-through reports...

Today I'm trying to work on improving my Sql 2005 Reporting Services report based on all the feedback I've been getting.

Basically this report currently provides a way to drill-through to get more detailed information, if someone clicks on an ID number for any of the given rows returned from the database.

One of the pieces of feedback was it would be nice to be able to flag all the rows a person wants more details on and to be able to click a button to retrieve those details on all the flagged rows.

So far I haven't had any luck in figuring out a way to do this.  I've been looking all through Books Online and all over the internet, looking for "multi-select drill-through" but so far I haven't come up with anything.

If I figure it out I'll post the answer, but if anyone has any suggestion on how to do something like this (or an example of some sort) please speak up and share the knowledge.  :)

Comments

• Anonymous
  March 29, 2006
  Well there are a couple of ways to do it, you can put checkboxes beside the rows you want. That way they can jut check them, probably eone of the easier ways. Another way would be to put them in a select control however make it a multiline select. Or another way more trickier. You need to write some javascript and use an onclick method on a row and then that would add the ID into a hidden field on the form.
  
  However you didn't say are you doing this in asp.net or a windows form?