Problem in Report Paramtere for Passing Values

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

Development Tools

Reporting Services Development

Problem in Report Paramtere for Passing Values

Author

Topic

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2010-05-04 : 04:43:36

Hello All,

Currently my sql query is as follow for taking the selection paramtere value:-

Where Series_Name in (@Series)

For that i have created one ReportParameter as "Series".
In Label Name i have entered "AMCC" and entered the multiple values as AMCC8,AMCC9,AMCC10. In second label i have entered as "AMCN"
and entered values as AMCN8,AMCN9,AMCN10.

So now in Report view paramtere series displaying two value 1) AMCC 2) AMCC9

Now if i select both AMCC and AMCC9 then all the values should be passed to my sql query and returns data.

Please let me know how to do this?

Thanks,
ABHI

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-05-04 : 04:46:10

Read about dynamic queries

http://www.sommarskog.se/dynamic_sql.html

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2010-05-04 : 05:16:59

thanks for the reply.

Can you please give me the example.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-04 : 12:52:00

one way

Where ',' + @Series + ',' LIKE '%,' + Series_Name + ',%'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2010-05-05 : 04:21:21

This is get failed when i m selecting both value "AMCC" and "AMCN" in selection paramtere.

Error is :-

An expression of non-boolean type specified in a context where a condition is expected, near ','.

When i select only single i.e "AMCC" then its works.

Please help me

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-05 : 04:50:55

nope it will work if you pass as 'AMCC,AMCN'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

WinnerKnight
Starting Member

2 Posts

Posted - 2010-05-05 : 12:22:52

Hello ALL,
I'm trying to create a pie chart by using reporting services 2008, and cube dataset.
the problem is when I pass a single value in a parameter, the whole chart filled with the same color, i need to know the percent of this value compairing with the whole data with different color?
if I select multi values, or ALL, the chart is working fine.
anyone can help me?

Faris AL-Masri
Estarta Solutions-Amman
+962 777 517365

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-05 : 15:05:32

whats the expression you used to get percentage?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources