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
 Filter question

Author  Topic 

Isabel
Starting Member

6 Posts

Posted - 2006-03-29 : 12:58:44

I have built a Matrix report which takes a parameter account number as input and displays company info and all the sales data for the company.I am using access database and SQL database to get the data for this report.Everything works fine till here.
Now, I want to incorporate the ability for the user to choose multiple companynames and pass these values to generate the report.How can i achieve this?

I appreciate all the help
Thanks,

jhermiz

3564 Posts

Posted - 2006-03-29 : 13:03:22
RS 2k or RS2k5 ?


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

Isabel
Starting Member

6 Posts

Posted - 2006-03-29 : 13:05:24
RS 2K
Go to Top of Page

jhermiz

3564 Posts

Posted - 2006-03-29 : 14:44:55
Read this for multi parameters in rs 2000

http://weblogs.sqlteam.com/jhermiz/archive/2006/01/03/8678.aspx




Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

Isabel
Starting Member

6 Posts

Posted - 2006-03-29 : 15:33:37
Thanks Jon.I read the atricle & will try to implement it.
Go to Top of Page

jhermiz

3564 Posts

Posted - 2006-03-29 : 15:53:20
If you need any help please post back.



Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page
   

- Advertisement -