Solved

Reporting Services - Text filters similar to those in Office 2007

Posted on 2007-03-30
1
278 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

778 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