quite urgent... I have 3 matix tables.. all the same row headings. I need to be able to make these visible/invisible depending on the user parameters. The reason for this, if a user hides table on the left.. the middle table needs to show the row headings. and last table must not.
The problem:
When making the row headings invisible it doesnt exactly chop off the textboxes... so the tables look disjoint.. and a big gap appears between both tables...
Is there a way to join these tables without leavings gaps ?
any help is appreciated.
Neil
Try putting each matrix inside a rectangle, then hide the rectangle containing the table based on the user parameter.
Additionally, put all 3 rectangles within one parent rectangle. Should help with the spacing.|||Hi Andy
thanks for the reply!
While I like that idea and provides a lot more control over the positioning of the tables.. the problem still exits...
It seems that making a textbox "visibility = true" just produces an empty textbox..but still leaves the space allocated to textbox in place... and therefore the gap.. the rectangles dont seem to help.. unless im doing something wrong..
Does this seem right ?
|||I also just tried making the middle rectangle hidden = true and it didnt close the gap as expected.. very confused.. I just draggged the rectangles into the parent rectangle... ?
very strange.. any idea's why this may not be working for me ?
|||Well now I'm confused about what you're doing. One partyou're talking about matrixes, the next you're talking about tables. Which are you using? Matrixes or tables? Do you have 3 separate matrixes or 3 rows in one matrix?
Have you tried setting the visibility property for the whole row (or column) instead of the individual textboxes?|||
Using Matrix
Select appropriate textbox in matrix
Right click
Select Edit Group...
Visibility tab
Select Expression
Add your expression
It will not work if you put it on the textbox properties.
Using Table
Select appropriate column
Go to properties
Go down to visibility tag and select expression
Add your expression
You can use a variety of expressions to hide the columns like parameters or counts.
=IIF(Fields!City.Value=@.City, FALSE, TRUE)
or
=IIF(Trim(Fields!City.Value) = "", TRUE, FALSE)
Hope this helps
|||Sorry, I mean matrix...My problem is not making the whole matrix invisible... I have 3 of them lined from left to right.
All three have the same row (group headings - sorry I should have made that clear). I dont need all the to show the same headings on the row groups. So, I just want to beable to hide these headings depending on the users selection.
The problem is that making the row headings + total header hidden, leaves a gap between the matrices as if the headers were there but just with no text or borders in them (invisible to the human eye but as if its like a brick stopping the matrix from moving closer to the other ones)
Sorry for the confusion.. thanks for helps !
But any idea.. anyone ?
|||Hi Brady,
Thanks for the suggestion.. while I have been trying that.. the problem there is that bigger Textbox located in the top left of the matrix.. that wont be invisible and therefore will stop my matrix from moving closer to the other matrix..
Is there a way to get rid of that Textbox...?
I have tried deleting it , but does not go away...
