Custom or 3rd party report filtering tool

Hi,
I am looking for a tool/application that can be used by users to select and
filter reports. The report list and field list would be pulled from a
database along with field type, and query to use to populate drop down list
filters.
User would select the report they want from a drop down list. The form
would populate with the fields required for the filter and the user would
enter into the filter as required. This information would then be sent to
the report server as either report paramaters, or have the filter items
combined into a where clause and passed as a single parameter to the report
where it would be used to filter the SQL coming from the data source.
Has anyone seen anything like this? I can't find anything on google. We'd
like an easy to use reporting interface for our users and are not willing
allow our users to use the standard RS interface for report filtering.Maybe use the Windows Sharepoint Services report explorer to let users
select their report and enable the filtering in the report.
"Dan" <kgh@.kg.com> wrote in message
news:uueqfouzHHA.3788@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I am looking for a tool/application that can be used by users to select
> and filter reports. The report list and field list would be pulled from a
> database along with field type, and query to use to populate drop down
> list filters.
> User would select the report they want from a drop down list. The form
> would populate with the fields required for the filter and the user would
> enter into the filter as required. This information would then be sent to
> the report server as either report paramaters, or have the filter items
> combined into a where clause and passed as a single parameter to the
> report where it would be used to filter the SQL coming from the data
> source.
> Has anyone seen anything like this? I can't find anything on google.
> We'd like an easy to use reporting interface for our users and are not
> willing allow our users to use the standard RS interface for report
> filtering.
>
>|||That's the standard sharepoint site for reports that comes with RS?
I don't mind this interface too much, but it's not as intuitive as I like.
One majour problem is in the difference in which we do filtering with our
reports. All of our reports have only 1 parameter and we call it
WhereAndSort. We just append this parameter value to the SQL statement in
the dataset. We do not create a parameter for every field we want the user
to potentially filter on because 1)we like to be able to add new filtering
options without re-compiling the report. 2) We recieve better performance
filtering on the SQL query rather than pulling all records and do report
filtering...
Thanks...
....still looking for another option.
Dan
"Joel Lindstrom" <joel.lindstrom@.customereffective.com> wrote in message
news:2425A0D9-A741-4A05-B694-1C9F6E7FB086@.microsoft.com...
> Maybe use the Windows Sharepoint Services report explorer to let users
> select their report and enable the filtering in the report.
> "Dan" <kgh@.kg.com> wrote in message
> news:uueqfouzHHA.3788@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I am looking for a tool/application that can be used by users to select
>> and filter reports. The report list and field list would be pulled from
>> a database along with field type, and query to use to populate drop down
>> list filters.
>> User would select the report they want from a drop down list. The form
>> would populate with the fields required for the filter and the user would
>> enter into the filter as required. This information would then be sent
>> to the report server as either report paramaters, or have the filter
>> items combined into a where clause and passed as a single parameter to
>> the report where it would be used to filter the SQL coming from the data
>> source.
>> Has anyone seen anything like this? I can't find anything on google.
>> We'd like an easy to use reporting interface for our users and are not
>> willing allow our users to use the standard RS interface for report
>> filtering.
>>
>