My report has a drop-down list which will be used to filter the process name.
I create new dataset "PackageName" in my report using below query.
select distinct process_package_namefrom [Work Breakdown Element Map] AS wbemapWHERE (wbemap.project_name =@Project)
Then, I set process_package_name from the PackageName dataset to ProcessName variable as an Available values and Default Values .
After that, set filter
=Fields!process_package_name.Value In =Parameters!ProcessName.Value
I pack this report to my process template and create new team project using this process template.
After I create some new instances and force the Warehouse to update by run the WebService.
The report also found the new process name (They shows in the drop-down list) but the detail of report is not show.
I test and it work in the report project but it does not work in the real project.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?