Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Reporting Services
»
Reporting Services 2005 Development
»
Charts and subreports
Charts and subreports
Rate Topic
Display Mode
Topic Options
Author
Message
dopydb
dopydb
Posted Monday, March 12, 2012 5:39 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 6:17 AM
Points: 126,
Visits: 282
hi all
if i have a simple bar chart in srs 2005, is it possible to design the report so that i can click on one bar and it will open a second table report with the information filtered by the selection in the chart?
if anyone has any good tutorial on this, and even general subreports in ssrs 2005 can you please help me by linking them?
anything i find online seems more directed towards 2008 - either that or i dont understand them
cheers
mal
Post #1265083
anthony.green
anthony.green
Posted Monday, March 12, 2012 6:15 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
you would want to take a look at the action tab on the chart properties
http://msdn.microsoft.com/en-us/library/aa964128%28v=sql.90%29.aspx
Around half way down is this sub heading "7. Add a drill-through action on the sales data value" so you get the right box
Then link it to a secondary report which takes in a parameter of which is the value of the bar which you click on, so needs to be the detail from the chart data source for it to drill through properly.
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1265109
dopydb
dopydb
Posted Monday, March 12, 2012 9:09 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 6:17 AM
Points: 126,
Visits: 282
thanks Anthony - looks just what i was after!
Post #1265280
dopydb
dopydb
Posted Monday, March 12, 2012 10:49 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 6:17 AM
Points: 126,
Visits: 282
report done! simple with the correct info :) - i just couldnt understand some of the websites i was reading!!
ssrs - some pretty good functionality in here !
Post #1265377
anthony.green
anthony.green
Posted Tuesday, March 13, 2012 2:42 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
yeah it can be a bit tricky SSRS in some places. luckily I had the joy of the 3 day SSRS admin course along with working along side a ex MS Trainer in a previous role who specialised in all things SQL so I picked a lot up from them.
Also I would recommend these two books if you want to go deeper into SSRS
http://www.amazon.co.uk/Microsoft-Server-Reporting-Services-Package/dp/0735626472/ref=sr_1_1?ie=UTF8&qid=1331627957&sr=8-1
http://www.amazon.co.uk/Microsoft-Server-Reporting-Services-Unleashed/dp/0672330261/ref=sr_1_9?ie=UTF8&qid=1331627957&sr=8-9
Happy I could point you in the right direction
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1265744
dopydb
dopydb
Posted Tuesday, March 13, 2012 3:25 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 6:17 AM
Points: 126,
Visits: 282
lucky indeed, i have always been on my todd on such things
lol
thanks for the links i must look into them !
Post #1265769
DuncEduardo
DuncEduardo
Posted Friday, March 01, 2013 8:25 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 10:41 AM
Points: 21,
Visits: 189
anthony.green (3/12/2012)
you would want to take a look at the action tab on the chart properties
http://msdn.microsoft.com/en-us/library/aa964128%28v=sql.90%29.aspx
Around half way down is this sub heading "7. Add a drill-through action on the sales data value" so you get the right box
Then link it to a secondary report which takes in a parameter of which is the value of the bar which you click on, so needs to be the detail from the chart data source for it to drill through properly.
Hi there, maybe I'm looking in the wrong place but for the life of me I can't find that reference.
Can you help?
Post #1425545
DuncEduardo
DuncEduardo
Posted Friday, March 01, 2013 8:28 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 10:41 AM
Points: 21,
Visits: 189
sorry ignore last post - I found it
Post #1425546
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.