Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pumza.magona
Starting Member
6 Posts |
 Posted - 2010-07-26 : 03:50:20
|
| Hi All,I need your help:The main report on Report Server is as follows:Subscriber State Number of SubsActive 1000Deleted 1500So I want to be able to click on the Active subscriber state and then a second report shows (select * from tblA where SubscriberState = 'Active') or when I click on the Deleted subscriber state.I would really appreciate your assistance.Kind Regards,Pushy |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-26 : 13:12:05
|
| can you post your query? and describe what exactly are you trying to achieve. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-27 : 01:15:21
|
| What the Op wants is some kind of subreport.In the main report he has values like Active & Deleted which should be displayed as a linkbutton & when clicked either one of them i.e if clicked Active the query "select * from tblA where SubscriberState = 'Active'" should get executed & the corresponding resultset displayed.Try posting your question herehttp://www.sqlteam.com/forums/forum.asp?FORUM_ID=35Maybe you have get a better chance of response.Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
|
|
|
Report Server 2008 - Go to Report