Solved

Reporting Services - Text filters similar to those in Office 2007

Posted on 2007-03-30
1
285 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 15

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

In this article I will describe the Backup & Restore 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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

734 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