Post reply

Filter Table based on value clicked in matrix

  • July 28, 2008 at 10:03 am

    #190227

    All information is from one data set

    I need to filter table based on the clicked value in matrix. i.e user should click KOB type in matrix and Table will be visible with only matching KOB type rows.

    Right now Table is shown when header title of matrix (+) is clicked.

    Will appreciate your help. I am very basic in SQL Reporting Services.

    Please refer to attach image.

  • July 28, 2008 at 1:11 pm

    #849380

    I need to filter table based on the clicked value in matrix. i.e user should click KOB type in matrix and Table will be visible with only matching KOB type rows.

    Right now Table is shown when header title of matrix (+) is clicked

    I think my preference would be to create the table report as another separate report, and one that is called by clicking on the KOB cell in the matrix. This report should have a parameter for the KOBType which you can then use as a filter on the table (or you could filter the dataset).

    Once you have created the second report you can use the navigation property on the KOB Cell (or other cells) to call the second report and add the parameter value.

    Good luck,

    Nigel West
    UK

Viewing 2 posts - 1 through 1 (of 1 total)

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