asked on

SSRS report with filterable (like Excel filter by form) column headers: Any workaround?

Hi All

I have a client that is asking me if SSRS 2008 can accommodate column headers where the user can click and filter by form, like Excel.

Looks like the answer is you can't do that.

My question: Has anyone been in this situation, and proposed any graceful work-arounds?

At the moment I'm about to pitch parameters for all column headers, where the parameters call various views that contain all values, and then the user re-runs the report with every change in parameter.

Thanks.
Jim

SOLUTION

liija

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

ValentinoV

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

liija

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim Horn

ASKER

Thanks for the design help.

On this project I have a BA that is not very good, and a PM that is enforcing that client contact be solely through the BA, and the project has had a number of internal and external client business SME's, so my contacting the client directly with a 'what do you really want' is not permitted. Because of all of this, I'm trying to minimize my time on the project so I can spend it on others where I can be a rock star.

I decided to kick out an Excel 2010 Spreadsheet with links to the SQL SP's, and the ability to manipulate the parameters via cells and refresh with a Go button. This allows the tinkerers to tinker, with minimal development time.

>The above is of course simplified as well, but let's say a user is only interested in certain specific filter combinations. In that case it could be more interested to build a couple of tables that store the user credentials and the filter combinations in which their interested.
Excellent idea, I'll have to work with this.

>Looks nice but of course, the dynamic sql is not compiled.
At that moment that's not an issue, but you are correct in that I don't want to open the door to performance issues down the road.

Thanks guys.
Jim

ValentinoV

Good to hear you found a solution that works for the client! If they want Excel behavior, give them Excel: I like that!
(and sorry to hear they're such a pita, but at least there's some BA being done :)

Good luck,
Valentino.