Add a Prompt to an Entity in a Report Builder Model

Question

I am trying to add a prompt (or parameter) to a Report Builder model.  My goal is to create a prompt so that everytime a user builds a report that includes a particular entity within the model. 

I see how to add a Filter object to an Entity in the model, but I do not see any method to change the filter to a prompt.  When I create the Filter, I right click on the Attribute the Filter is based on, but all I see is "Edit as Formula" and "Remove Condition" options.

I have seen many examples of how to create a prompt when building a report, but none that show how to do it when building the actual model.  Is this supported in Report Builder 1.0?

I am using SQL SSRS 2005 and Report Builder 1.0. 

Thanks in advance for your assistance.

Answer 1

Hi,

Yes, this is supported in Report Builder 1.0.

Click the Filter button on the toolbar of report builder, it will pop up the Filter Data dialogue window. In this window, double click any field you want in the Fields pane and it will be added in the "Orders With" pane, then you can click or right click this newly added field and there will be 3 options: Edit as Formula, Prompt and Remove condition. If you want this filter object will be prompt, click it and it will be marked with "selected" sign.

See this MSDN article http://msdn.microsoft.com/en-us/library/aa337145(SQL.90).aspx for more details on how to add a filter in report builder 1.0.

thanks,
Jerry

Answer 2

Thanks Jerry,

I think your reply is on how to add a prompt to a report in Report Builder click once application, not when designing the actual model in Visual Studio.  What I am looking for is to add the filter prompt to an attribute of an Entity in the model when building the model in Visual Studio.

Thanks.

Answer 3

Hi,

There is no Prompt option for the filter in the report designer, it only can be added for the filter in Report builder.

thanks,
Jerry