Solved

Reporting Services - Text filters similar to those in Office 2007

Posted on 2007-03-30
1
276 Views
Last Modified: 2011-09-20
In reporting servcies, is there a way to do text filters similar to Excel 2007 where you click on an arrow on the column header and you have a list of checkboxes with the different items containied in that column. If you're familiar with this feature, it has an option to "Select All" or you can check one or more items and then the spreadsheet will only show the rows that have that item in that particular column.

Thanks,
CT
0
Comment
Question by:CoconutTelegraph
1 Comment
 
LVL 14

Accepted Solution

by:
Megan Brooks earned 500 total points
ID: 18826873
Reporting Services doesn't have built-in interactive filtering like Excel, but you can use report paramters to filter either in the dataset query or on the dataset output, and available parameter values can be displayed as checkbox lists. It doesn't look as nice, but you might be able to accomplish what you need to do.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now