none
Managing visibility for group columns RRS feed

  • Question

  • Hi All,

    I have a problem. On a report matrix I have a group. Columns within the group are

    Total | Column1 |  Columns2

       5             2                3

       3             2                1

    When user selects a Parameter value - Column 1, obviously Column 1 is visible but also Total column is visible. How can I make only one column (within a group) visible based on a parameter. Users want to view only one column when they select parameter to show only one value.

    I'm researched InScope() but quite honestly I had difficulties applying that to the request above.

    Any help would be appreciated.


    Thomas Pollack

    Friday, August 31, 2012 6:14 AM

Answers

  • Hi,

    You can do this by performing following steps

    1. If you do not have the dataset for selecting Columns create one as below. As also add union all for 'Total'

    select distinct columnGrp  from TableName 
    union all
    select 'Total'

    2. Create a parameter from selecting column. Lets say parameter name is "Column" . Now Parameter property page, set this to "allow multiple values". Go to Available Values and select "get value from a query" and use dataset created in step 1

    3. Open the column group property and set the filter as shown in below screen

    4. For Total column set below expression for total column visibility

    =IIF(InStr(join(Parameters!Column.Value),"Total") > 0, FALSE, TRUE)

    Kindly revert for any more information.

    - Chintak (My Blog)

    Friday, August 31, 2012 9:12 AM

All replies

  • Hi,

    You can do this by performing following steps

    1. If you do not have the dataset for selecting Columns create one as below. As also add union all for 'Total'

    select distinct columnGrp  from TableName 
    union all
    select 'Total'

    2. Create a parameter from selecting column. Lets say parameter name is "Column" . Now Parameter property page, set this to "allow multiple values". Go to Available Values and select "get value from a query" and use dataset created in step 1

    3. Open the column group property and set the filter as shown in below screen

    4. For Total column set below expression for total column visibility

    =IIF(InStr(join(Parameters!Column.Value),"Total") > 0, FALSE, TRUE)

    Kindly revert for any more information.

    - Chintak (My Blog)

    Friday, August 31, 2012 9:12 AM
  • Sorry for late reply Chintak. Thank you for the thorough response!!

    Thomas Pollack

    Tuesday, September 4, 2012 1:41 AM