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
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Filter in a view...

Author  Topic 

Lukesb
Starting Member

6 Posts

Posted - 2009-05-02 : 05:53:49
Hi

I am using the report server to create a report that is based on views on my SQL 2008 server...

How do I get the drop downs at the top of the page to filter results in the first view that my report is based on.

e.g.

View 1 contains DateTime

There are then 5 other views before I then base my report on View 6. I want the user to select a date when the report is run, but put the criteria/filter on view 1

Hope this makes sense...

Cheers

Luke

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-07 : 14:05:50
you should probably use procedure instead of view and pass the filter criteria as a parameter to it.
Go to Top of Page
   

- Advertisement -