Get a SQL Reporting Services report to only show selected rows in a datagrid.

Posted on 2006-03-20
Medium Priority
Last Modified: 2012-06-27
Hello all,

In an asp.net page (I'm using VB.Net) can you have a user select rows in a datagrid, using say a check box and then trigger a reporting services report to only report on the selected items. Reporting all items is not an issue I can just use the same SP that populated the datagrid in the first place.

If I could find the reference to include in my project that allows me to work with Reporting Services items, that might set me on my way?

I want to avoid having to create some long winded dynamically created query string if possible. Not only because of the security risk but it could end up being to long.

Any lateral thoughts and suggestion much appreciated.
Question by:Martin_Currie1
  • 2
LVL 12

Accepted Solution

craskin earned 1000 total points
ID: 16238401
see if you can adapt this tutorial on the detailsview control to your problem

LVL 12

Expert Comment

ID: 16238417
it goes through the basics of capturing the primary key value of the selected row of a gridview to display details in a detailsview control. you should be able to parlay this into reporting on the selected row in your own fashion.

Author Comment

ID: 16238541
I'll have to have a look tomorrow. It's got to late to do it now. I'm also looking into this


Which may be what you mention anyway, sorry I haven't had chance to read it.

Thanks for the rapid feedback. I hope to have it cracked tomorrow.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question