Post reply

Linked Reports in SSRS

  • January 26, 2012 at 7:28 am

    #267212

    Hello everyone

    I have two reports in RS 2008. The first shows some basic activity in a matrix table - number of sales month on month. The table includes RAG rating using the SWITCH function. The other report shows a number of text boxes. What i need to do - and i have no idea whether it is possible or not - is to reflect the current months RAG rating from the matrix table in one of the text boxes on the other report (the text boxes have been designed to look like a Dashboard - each represents a different performance area of the business). I don't want to show the numbers from the matrix report i just want the text box to appear red, amber or green depending on the current months performance from the other reports matrix table. I know how to link reports together not how I'd be able to do this.

    Is this possible and if so, how?!

    Thanks in advance...

    BO

  • January 26, 2012 at 1:41 pm

    #1439018

    Try this:

    Add RAG parameter to other report.

    Add your Switch expression to the BackgroundColor property for your textbox, using the RAG parameter as the switching value.

    Pass month RAG value from first report as parameter to other report

  • January 27, 2012 at 3:00 am

    #1439219

    Thanks for getting back to me!

    I'm a little confused about the RAG paramater on the other report. The report shows a matrix table with month names acros the top (columns) and departments as the rows - the vaues are the sales per department by month. How would i create the paramater here to pull through to the other 'dashboard' report? I also need the textbox on the 'dashboard' to only show the current months performance rather than the whole year - so where our position is at the present time (although the ytd figure might be useful i suppose...)

    Hope this is clear...

  • January 27, 2012 at 8:41 am

    #1439425

    I made the assumption that when you clicked in the matrix report the action was to open the dashboard report, you add the parameter passing in the same tab where you link to the dashboard report (Textbox properties, action). Once you have selected your dashboard report, add a parameter. Then select your dashboard parameter from the dropdown list, and give it the appropriate value.

    I’m guessing that the current month performance number is something like this (Sum(Current Month Sales) – Sum(Current Month Expenses))/Sum(Current Month Expenses) since your query returns all departments.

  • January 27, 2012 at 8:47 am

    #1439433

    Cheers for that - I'll give it a go...

    Thanks again for all your help!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply