• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

asp.net reports

L

linkgoron

Platinum Member
Well I'm using the reports tool (local reports, not Crystal reports) and I've build a bar chart with that lists qualified people.
Everything Is working fine. What I need though, is an option that every header in the x-Axis will be a link to another report with detailed information about the qualifications (a chart that shows how many people are qualified from more specific places).

I couldn't find a way to do this, maybe you guys can help me out?
 
We're using the MS built in Reports (I'm not sure how it's called...).

Basically I've built a stored proc in SQL server (2005) that generates the data, and sends it the rdlc file (I believe that's what it is) and then there I've build a basic 3D graph that shows the data.
 
You're using SQL Server Reporting Services. Do you have a front-end for Report Services, like an ASP.NET Web Page or a Windows Form? Or you're using the default Website that ships with Reporting Services?
 
Originally posted by: Dhaval00
You're using SQL Server Reporting Services. Do you have a front-end for Report Services, like an ASP.NET Web Page or a Windows Form? Or you're using the default Website that ships with Reporting Services?
Click to expand...

An ASP.NET Web Page.
 
I remember programming a drill through/sub report in one of my projects a few months ago where in I had tap into the DrillThrough event to handle the functionalty. I don't have the code in front of me, but refer to the examples at www.gotreportviewer.com. The site is by far the best resource for dealing with Reporting Services. Also, look at various examples here: http://msdn.microsoft.com/en-u...#moressrscharts_topic4.

Essentially, you'll probably have to design your 'schema' in the RDLC file, and then tap into either the SubreportProcessing or the Drillthrough event to handle the subsequent behavior. I remember roughly that the properties have an "Action" tab which allows you to "Jump to a subreport."

Warning: Your Export to Excel functionality will not work with sub reports. This has been "fixed" in SQL Server 2008.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top