Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / May 2008

Tip: Looking for answers? Try searching our database.

Passing Parameter

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mohit - 29 May 2008 13:18 GMT
Hi All,
I know how to pass parameter for static value like select * from emp
where @empid='10' in SSRS 2005.
Can any1 tell how to pass parameter if i want to select from multiple
value like @storename = (???)
What should i pass in place of ??? if i want to select value from
multiple stores.

I dont know whether i am able to explain exactly what i want so with
other example i will try.
Suppose my company operates in 10 countries and i want to pass this
countries as a parameter so that in preview from the dropdown box i
can select any country from the available countries.
Please give any example for passing parameter for multiple value.
It will be a great help from u guys.
Thanks in advance.
Antoon - 29 May 2008 13:50 GMT
simply use a multi-value parameter and write
select ...where  storename in @p_storenames

> Hi All,
> I know how to pass parameter for static value like select * from emp
[quoted text clipped - 12 lines]
> It will be a great help from u guys.
> Thanks in advance.
mohit - 30 May 2008 04:44 GMT
> simply use a multi-value parameter and write
> select ...where  storename in @p_storenames
[quoted text clipped - 17 lines]
>
> - Show quoted text -

Thanks
Dan Bass - 29 May 2008 13:53 GMT
There's quite a bit to be found on google about this...

for eg: http://msdn.microsoft.com/en-us/magazine/cc188691.aspx

(http://www.google.co.uk/search?hl=en&q=multiple+reporting+services+stored+proced
ure+parameter&meta
=)

> Hi All,
> I know how to pass parameter for static value like select * from emp
[quoted text clipped - 12 lines]
> It will be a great help from u guys.
> Thanks in advance.
mohit - 30 May 2008 04:45 GMT
On May 29, 5:53 pm, Dan Bass <DanB...@discussions.microsoft.com>
wrote:
> There's quite a bit to be found on google about this...
>
[quoted text clipped - 20 lines]
>
> - Show quoted text -

Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.