Post reply

How to find out the visibility state of the parent group in Matrix

  • June 1, 2005 at 9:55 am

    #110452

    I have a matrix, which has 2 rows groupings and 2 column groupings. Now the cell which contains the data (highlighted with black border, in the figure below) displays the number of entities having the X & Y attributes.

    Matrix in Design Mode

    When the user clicks on the cell containing the count, it should navigate to another report showing the list of values. In order to achive that, the parameters are set and the "Jump to Report" property is filled up for cell. The parameter to be passed include XParentValue, XChildValue, YParentValue, YChildValue.

    Now the problem is that we need to find out a way to find out if XParent (Fields!Scope, in the figure above) OR YParent (Fields!ParentRowGroup, in the above figure)  is in the collapsed mode and then pass NULL for XChildValue & YChildValue or else pass all the four parameters.

    I have tried with ReportItems!TicketMatrix_ChildCOLGROUP.Hidden property but I guess the only property for the collection "ReportItems" that we can use in expressions is "Value".

    Please let me know if there a solution to it.

  • June 6, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • June 7, 2005 at 12:40 am

    #563397

    Me having exactly the same problem of unable to quoting other property than value, would appreciate for any workaround.

  • June 7, 2005 at 1:19 am

    #563402

    You can only reference the value property of the other report items, which is a bi tlimiting.  One way that I have worked around this (NB, it's ugly and time consuming) is to use the same functions/tests that I used in the parent, within the chold item, and then added my child level tests on top of that.  So in psuedo code, where I *should* (or make that *would like*) to be able to say Iif(ReportItems!txtSometextBox.BackgroundColor , "Blue", [do something], [do something else])  I actually wrote out the test from the txtSomeTextBox into the current object, and then did the subsequent tests.  Not pretty, n not good for long or complicated formulas (ie a change in the formula means a change in many, many places).

     

     

    Steve.

  • July 5, 2005 at 9:45 am

    #570903

    Use the function - "InScope".

  • July 6, 2007 at 4:10 am

    #717627

    Did you ever solve this. I am trying to conditionally send through an all parameter to a drill through report in a matrix and this hidden visible thing seems like ti could be the answer

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

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