then switch to preview tab and I haven't tried this myself, but I saw an example where they configured Available Values to come from a query, then used an expression to specify the query.
The expression included the value of the first parameter.
Then, having got that parameter value, it can populate the second parameter's dropdown. IN your report paramenter, you click on agentid parameter and then from a Query on available values.
You select dataset1 and ID as value and Agent Name as Label. In this You create your statement like : In reporting service, you go to parameter and the set Order to get value from Dataset2 So the Order of parameter should be agentid, orderid.
And that’s a shame, here is how you can find out if you are in a compatibility mode Excel: The Excel compatibility mode shown in the top of the Excel file " data-medium-file="https://i2com/ fit=660,47" class="alignnone wp-image-1154 size-full" src="https://i1com/theprojectcornerblog.com/wp-content/uploads/2015/03/compatibility-mode-excel-ribbon.png? resize=660,47" alt="Compatibility mode Excel ribbon" width="660" height="47" srcset="https://i2com/ Within the latest version (and if you are reading this in the future, I am relating to Microsoft Project 2013) there is a new rich reporting module that is build within the application. I particularly like the “Project overview” report within the Dashboards, because it is usable for any client.
With the new reports it will not be needed to move to another application such as Excel. fit=660,168" class="alignnone wp-image-1163 size-large" src="https://i1com/theprojectcornerblog.com/wp-content/uploads/2015/03/new-reports-in-ms-project-2013.png? resize=660,168" alt="New Reports in Ms Project 2013" width="660" height="168" srcset="https://i2com/ And you can even create your own dashboard by selecting and copying items from reports you like and insert them in your own report. Here you have the tools at your command to create company wide reports related to resource capacity by department, team, or skillset.
Summary: This is in an example of using reporting services for something other than just displaying data.
By creating an action on a report that calls itself you can pass values to hidden parameters and then use those parameters in stored procedures that are called from a dataset to insert/update data.
It concerns the Visual Reports within Microsoft Project 20.
Obviously the parameter values will come from a query, but I don't know how to make it rebind the list once they select an agent.
menu is crucial; because the datasets must be executed in the order shown above, and the @t parameter is in a dataset that relies on the @p parameter being set first, we move @p to the top of the list.
Reporting Service will automatically prompt for parameter by order.
Important note: in case the report did not render or exception was thrown, just switch to data tab again, select the report dataset and execute the query, you will be prompted to enter a value for param_name...enter it and execute it...