Prompt Parameter in Ad Hoc Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tk_Neo - 27 Feb 2007 17:47 GMT

Can i do this?

In the filter window, i want to add a field and make it into a prompt. But
then when the users run the report they should have the ability to not select
anything from the prompt and hence see the report for all values of that
field....

Reply to this Message

EMartinez - 28 Feb 2007 04:26 GMT

> Can i do this?
>
> In the filter window, i want to add a field and make it into a prompt. But
> then when the users run the report they should have the ability to not select
> anything from the prompt and hence see the report for all values of that
> field....

One way of doing it is to create a report parameter for the filter
options (incl. no filter as an option) and either use the report
parameter value selected to filter with -or- use the report parameter
in the query or stored procedure to filter the results. Hope this
helps.

Regards,

Enrique Martinez
Sr. SQL Server Developer

Reply to this Message

Helen Warn - 28 Feb 2007 23:04 GMT

I posted a way to do this in the msdn forum:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1285083&SiteID=1

hth

Helen

>> Can i do this?
>>
[quoted text clipped - 15 lines]
> Enrique Martinez
> Sr. SQL Server Developer

Reply to this Message