Hi All, This is related to REPORT MODEL using report builder. report builder 3.0 on sql server 2008 R2 1.how to use cascade parameter for example I have entity employee , fields: empID,empName,empCounty,EmpCity what I want to have is when user select empCounty only the respective cities to show up in the city parameter dropdown.(ofcourse it uses two parameters) report contains all the fields listed above. any ideas, again this is report model , cant directly use sql queries, it is symantic XML query that report model is using. 2.how to use parameter on datasource Lets say we have a report created using REPORT MODEL. is that possible for that report to use a different datasource? ex. I know when we create a report using report model ........x01.ds--->x01.dsv--->x01.smdl and then x01.rdl but is it possible x01.rdl to have some kind of parameter and can use x02.ds Note: the database structures of the two datasources are identical, only the data is different. Thanks, Daniel

Hi DanMsdn2010, How to use cascade parameter(report builder 3.0), please refer to the steps below: Step 1. Create Datasets. In the Report Data pane, right-click a data source, and then click Add Dataset. In Name, type the name of the dataset. In Data source, choose the name of the data source or click New to create one. In Query type, choose the type of query for the selected data source. In this topic, query type Text is assumed. In Query, Click Query designer to open the Query Designer page. Select the Entity in the Entities list (which you would use to generate dataset). Double-click the filed in the Fields list to specify which field to be contained in your dataset. Click ok. Repeat the 1~8^th steps to create main dataset ds_employee, parameterize dataset ds_ empCounty and ds_EmpCity. Step 2. Parameter settings. In the Report Data pane, right-click Parameters item, and then click Add parameter, to create parameter @empCounty and @EmpCity, and set their Available Values related to the corresponding data sets. Right-click dataset ds_employee, select Dataset Properties, Switch to Filters tab. click Add ,select empCounty in the Expression drop down list, set operator to =, click fx to specify the Value expression to =Parameters! empCounty.Value. repeat 12^th step to add Filter EmpCity to ds_employee. Repeat 11~12 steps to add Filter empCounty to dataset ds_EmpCity. After you complete the step above, you can click preview to have try. More information about How to: Add Cascading Parameters to a Report (Report Builder 3.0 and SSRS), please refer to the link below: http://technet.microsoft.com/en-us/library/dd255197.aspx How to use parameter on datasource(report builder 3.0): According to your description, you would like to use different datasource in your report, please refer to the steps below: I assume that you have published the different data source you needed to your report server. 1. Right-click the dataset, select Dataset Properties to open the Dataset Properties window box. 2. Switch to Query tab, click New button next to Data source option. 3. Click Browse to switch to your report server to select one data source you need. If you have anything unclear, please feel free to let me know. thanks, Bill Lu

Thanks That will do it.