Hello
I Was wondering if anybody is using the filters to filter data I've tried and have varying success with the results.
I wanted to create filters on several of the fields. The user clicks the filters to see the corresponding results..the user can also click nothing in the filters and view report..how do we do both using parameters .
Can somebody help me please...
Thanks for your valuable time.
Sankar
Filter
Hot Topic
- database: mssql
- print from report manager in landscape
- Suggest Column Types
- Problem in SQL 2000 Analysis Service installation on windows 2003
- Formal parameter '@P83' was defined as OUTPUT but the actual parameter not declared OUTPUT.
- Transmission Queue problem
- Connecting to Sybase
- Draging and Droping scripts
- Use SQLServer with Java
- What is the best way for users to view cubes?
SQL Server
- raw file destination and environment variables
- Dynamically edit DataSet
- Report Builder Query Timeout?
- Do you regularly reboot your server? (funny you should ask)
- An existing connection was forcibly closed by the remote host. ; 08S01
- Teradata, SSIS OLE DB Source error (0x80040E21)
- Stored Procedure Wizard
- DTS help
- Failed to generate a user instance of SQL Server
- Using SSMS to Manage SSIS
Filter
Puneet Minda
What you are describing is inline filters, which are not available in the current versions of Reporting Services. You can use parameters for this purpose. If you want an 'all' value for the parameters, you will have to do a bit of work. This blog has a technique: http://blogs.msdn.com/chrishays/archive/2004/07/27/AllParameterValue.aspx.