Dropdown parameter in Report Builder

Hi, Is it possible to create a dropdown parameter in Report Builder?
The result I want to get is (for example):

The parameter is "Project". Next to the parameter should be a dropdown box from where I can select a project (for example: project1, project2, ...). Once the parameter is selected, and I click "view report", the report should only display data from the selected project.

The only other options available in the Filter dialog screen are:
"Field" is in list
"Field" contains
"Field" equals

But none of these methods of creating a parameter generate a dropdownbox from where items can be selected, equal to those in the database.

So ... is it even possible to create a dropdown parameter with values out of the db? Or are there any workarounds?

You could create a second dataset for the paramaters. Then in that data set something like this to call the data from the db:

Select project_name
from project_name_table
Group by project_name

Then set your paramater equal to the new dataset.

|||

rs12345 wrote:

You could create a second dataset for the paramaters. Then in that data set something like this to call the data from the db:

Select project_name
from project_name_table
Group by project_name

Then set your paramater equal to the new dataset.

You are talking about reports generated through a Report Server Project. But I created a model (from a Report Model Project) and then I want to generate a report on that model through the Report Builder! There it is not possible to create datasets.

Aren't there any MS people on here who can confirm if it is possible or not? (Possible to work with a parameter displayed as a dropdownbox containing values from the database)

|||

To create a filter condition based on a report parameter, open the Filter dialog, add a filter condition based on the appropriate field, then click on the field name (not the operator) and choose "Prompt" from the menu that appears.

Note that you will only get a dropdown when running the report if you see a dropdown in the Filter dialog as well. The presence of the dropdown in both cases is determined by the Entity.InstanceSelection or Attribute.ValueSelection property in the report model (whichever applies).

Hope that helps!

|||Thanks!

Changing those properties did the trick!

Drillthrough help in Report Builder

Hi,

I've looked at all of the published materials related to this subject that I could find but cannot find a good answer.

I'm trying to find out if there is a way to directly influence what details are shown when a figure is clicked on in a report.

I know it shows related data but it does not seem to show it all, infact it seems to pick pretty arbitrary things.

I've tried messing around with the attribute properties (in particular the EnableDrillthrough one) but to no avail.

Is there anything I am missing?

Thanks in advance.

Report Builder drillthroughs are determined using a combination of attributes in the model. There are two types of drillthroughs - single instance for when only one "result row" is returned" and multiple instance for when multiple rows will be returned. In the case of single instance, we return all the attributes of the entity you are going to and all the DefaultAggregates for entities that are to many from the drill entity. Example: if you click on a product name you get all the fields of the Product entity and all the DefaultAggregates for entities that are to many from Product - perhaps sales and returns. For multiple instance, you get the DefaultDetailAttributes of the entity and the DefaultAggregates of entities that are to many from the drill entity. Example: if you have a report listing customers and the number of distinct products per customer, if you click on number of products you will get a list of products where we will show the DefaultDetailAttributes for each product and the DefaultAggregates for all entities that are to many from product (sales, for example). So, the attributes in the model to change are DefaultDetailAttributes and DefaultAggregates.

Hope this helps.

Carolyn [MSFT]

|||Thanks Carolyn that's exacly what I needed to know!

Drill Through bringing back too many results

I have created a Matrix Report through the Report Builder and specified a filter on a Date field so it only shows the current months work. This works for the initial Totals within the Matrix but when you click on the Totals to show the Drill Down it will show all the results regardless of the Parameter.

How do I make the results in the Drill Through look at the Parameter I am passing to the Report?

Many Thanks

I'm not sure I understand your scenario, and I can't repro the behavior you describe using my best guess. Can you clarify:

1. What fields are in your report?

2. Did you actually create a report parameter by setting Prompt on the filter condition, or did you just create a normal report filter?

Any other info you can provide to further clarify your scenario would be helpful. Thanks!