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.
  2. Stored Procedures
  3. Cascading Parameters
  4. 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.

| improve this question | | | | |
  • Have you tried working your way through the Microsoft example? It's based on the AdventureWorks DB technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx – Mark Sinkinson Mar 10 '14 at 11:16
  • Thank You foor sharing information. I highly appreciatde it. Yes, I have looked at Microsoft site examples but I guess they ae not enough for my situation. Please allow me to be specific and upon reading let me know your thoughts and advice or input. I have a reporting need to view calculated columns by Employee, Location, Department, Service LIne, etc. My modeler is going to give me a single flat TABLE (No FACTS and Dimensions) so the question is how do I meet the reporting requirements? Do I create a Multi-dimensional Views or he should create Star-Schema model or its not doable?* – Samuel Mar 11 '14 at 17:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.