SSRS report navigation - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

SSRS report navigation

Author

Topic

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2009-12-21 : 07:12:55

[code]
select product,
count(callid) as Total,
count(case when answerc1='Y' then callid end) as Rush,
convert(decimal,count(case when answerc1='Y' then callid end)*100/count(callid)) as PercentRush
from
(
select pr.product, d.callid, d.AnswerC1 from detail d
join calllog cg on cg.callid = d.callid
join profile pr on pr.custid = cg.custid
where
(CAST(Cg.RecvdDate + ' ' + Cg.RecvdTime AS DateTime) BETWEEN @StartDate and @EndDate ) and
cg.calltype = 'campaign' and
cg.custid in (@Customer) and
pr.product in(@Product)
)T
group by product
[/code]

The result is:

Product TotalTicket's Rush %Rush
------------------------------------------------
DREAM 24 3 12
DREAMMAIL 4 4 100

Now what i want is that when a user clicks a Total Tickets value like 24 he gets redirected to a report where all callid's where product is DREAM are displayed
Is it possible thru SSRS. also i dont have any separate parameter callid in my dataset

svicky9
Posting Yak Master

232 Posts

Posted - 2009-12-21 : 16:05:52

a. Create a seperate report with parameters as product and all the callid's
b. Right click on the textbox and go to action
c. You can specify report as a link and can specify parameters also

http://www.sqlserver007.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources