Thursday, February 16, 2012

Can Reporting Serivces do THIS?

Hi, we have a business need that would
1. allow a user to select and order the columns from a table in the UI
2. The user would then provide filtering on those columns (CLIENT SIDE)
3. User will then execute this report to return data based on criteria
** The initial UI screen will have data driven from a Stored Procedure
The filtering should be done on the client side, showing only the columns
that have been selected in the order that they were selected
4. User can then have this ad hoc query saved
Is there a process of method that Reporting Services provides out of the box
to have this functionality?
--
MCSD.NETI suggest reading up on Report Builder in RS 2005 (released in November). It
is a new addition to the product that is web based end user reporting. It
sounds close to what you want.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ramzi" <Ramzi@.discussions.microsoft.com> wrote in message
news:A419C5CB-370A-4678-9D58-BAA69E9006CA@.microsoft.com...
> Hi, we have a business need that would
> 1. allow a user to select and order the columns from a table in the UI
> 2. The user would then provide filtering on those columns (CLIENT SIDE)
> 3. User will then execute this report to return data based on criteria
> ** The initial UI screen will have data driven from a Stored Procedure
> The filtering should be done on the client side, showing only the columns
> that have been selected in the order that they were selected
> 4. User can then have this ad hoc query saved
> Is there a process of method that Reporting Services provides out of the
> box
> to have this functionality?
> --
> MCSD.NET

No comments:

Post a Comment