Cascading parameters provide a way of managing large amounts of report data. With cascading parameters, the list of values for one parameter depends on the value chosen in preceding parameter. Order is important for cascading parameters because the dataset query for a parameter later in the list includes references to parameters earlier in the list.
A data source view is a logical data model based on one or more data sources.
- Connect to SQL Server and create employee and Department below tables (Click her for table creation script).
- Open required solution.
- Right click on "Data Source Views" and select "Add New Data Source View".
- "Data Source View Wizard" window will open.
- Click on "Next >" button. Then "Select a Data Source" page will open.
- Click on "Next >" button.Then "Name Matching" page will open.
- Click on "Next >" button. Then "Select Tables and Views" page will open.
- Click on "Next >" button. Then "Completing the Wizard" page will open.
- Give the required name (Employee) and click on "Finish" button.
- Data source view is created.
No comments:
Post a Comment