I am looking for a non-trivial Microsoft SQL Server Reporting Services example that shows the efficient use of the following for calculated columns such as:
Profit = Revenue - Expense Margin = Profit / Revenue, etc.
- Stored Procedures
- Cascading Parameters
- User Selects values from dropdown list box to control the report output they want to see.
Example, User Selects Dept. Name from the Department Drop Down List Box and based on selected department the Employees working for that Department shows up in the Next Drop Down List box called Employee and based on the Employee Selection a user can run the report to see that Employee specific information in the Report.
Some of these information could be like "Total Compensation" and I want to see How and where the Total Compensation was calculated using Stored Procedures? How the Cascading Parameters pass those values down to the Report to see that Employee Specific data.
Any example based on AdventureWorks DB or any other would be useful since I want to recreate it to understand how SP and Cascading works together.