I need some guidance to what functionality (by name) in SSRS I can achieve the below.
Need a one page SSRS performance summary report for each organization we partner with. Each report must have 4 tables on it, showing *different* views of the *same* dataset.
DETAILS about the dataset
SQL dataset returns:
DETAILS about the report
SSRS 1 page report to have 4 tables:
Table 1, to have 3 columns: Divisions, sum(Sent_Leads), sum(referrals) grouped by division for the most recent month.
Table 2, to have 13 columns. 12 to show how many sent_leads and referrals for each of the twelve months of current year that have elapsed so far, and the 13th one for labeling the sum(referrals) and sum(move-ins) under each Month header.
Table 3, to have 13 columns, just like Table 2, but to be for displaying sent_leads and referrals last year.
Table 4, just like table 2 and 3, but displaying sent_leads and referrals for 2 years ago.
Please see the attached image. Because of my computer's screen size image shows only 3 tables, but it gives the general idea.
I'm totally unable to figure out how to get each of tables 2,3,4 to display a different years worth of data, and table 1 to show only the current month's data. What is it that am I trying to achieve in SSRS terms so that I can search for it and find some good tutorials?