I'm curious to know if anyone else has encountered an issue with toggling the visibility of the groups and sub groups within the new tablix object in VS/BIDS 2008.
In our legacy dev environment we were using VS 2005 for SRS Reporting and in using the Matrix object, we could easily create multiple levels of drill down within one Matrix, each Sub-Group toggling it's visibility off of the text box of the group above it (row groups, along the left side of the Matrix).
Now with the Tablix, it seems that if the visibility of the sub groups is defaulted to hidden and set to toggle off of each group prior (save for the top level group which does not toggle, and is defaulted to visible) then the entire row will disappear. It is only when you default just the first sub group to hidden, and allow all others to remain visible after the first drill down (which results in a huge explosion of data instead of a gradual reveal to just what you are interested in), only then does it allow the row to remain visible/accessible.
I'm sure I'm just missing something in the change from Matrix to Tablix, but several other developers I collaborate with have reported experiencing the same issue, so I wanted to see if anyone else had seen this, or found a solution, or if it was indeed an known bug that we need to patch for?
I should note, that it seems to work fine in the Preview Pane within VS/BIDS 2008, only when deployed to the Reporting Server does this hidden row issue crop up, which is what lead us to believe it may be a patching issue on that server.
Thanks in Advance,