DrillThrough Passing multiple values in single par

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

DrillThrough Passing multiple values in single par

Author

Topic

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2009-12-29 : 09:04:15

properties->navigations tab and then clicking on the parameter button. Now i have a parameter name callid and i have given it the value as:

=Fields!callid.Value(there are actually 4 callid's)

And after the drill through i want to use all these 4 callid's in the target report (in(@callid))
But only the first callid is sent
is there any workaround for this so that i can send all the 4 callid's on a single event

SOURCE REPORT

Product Callid Total Calls
P1
11
12
13
14
4
P2
15
16
17
3

Note: Product is group by

what i want is, if the user clicks on 4 all the 4 callid's(11,12,13,14) should be sent to the target report where i can use them (in(@callid))
i m using the value for callid as:

=Fields!callid.Value, but it just sends the first call id i.e 11 if i click on 4 and 15 if i click on 3

byrdzeye
Starting Member

14 Posts

Posted - 2009-12-29 : 14:46:52

parse out the values in the parameter and put them in a temp table or table variable. use the table in a join or use a select in the in condition

inner join #temp on myid = #temp.id

where myid in (select id from #temp)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-02 : 01:48:24

quote:
Originally posted by nitsmooth

properties->navigations tab and then clicking on the parameter button. Now i have a parameter name callid and i have given it the value as:

=Fields!callid.Value(there are actually 4 callid's)

And after the drill through i want to use all these 4 callid's in the target report (in(@callid))
But only the first callid is sent
is there any workaround for this so that i can send all the 4 callid's on a single event

SOURCE REPORT

Product Callid Total Calls
P1
11
12
13
14
4
P2
15
16
17
3

Note: Product is group by

what i want is, if the user clicks on 4 all the 4 callid's(11,12,13,14) should be sent to the target report where i can use them (in(@callid))
i m using the value for callid as:

=Fields!callid.Value, but it just sends the first call id i.e 11 if i click on 4 and 15 if i click on 3

have you applied any grouping on your reports? where does 4,5 etc appear? is it on a group footer?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources