January 30, 2008 at 8:19 am
I have a matrix report that is showing whitespace in a drilldown because I am supressing duplicates. Based on what I read in other forums, if I set the ToggleItem to Len(FieldName)=0 that should supress the whitespace, right?
I can see that I have a field in the toggleitem called: Firstname. If I put the value Len(Firstname)=0 in the toggleitem property, then I get the error: The textbox 'textbox21' has Len(Firstname)=0' as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item. I think the code 'Len' is throwing it off.
If I put the value "Firstname" in the toggleitem property, then it doesn't return the error, so I know that firstname is a valid value for toggleitem, but setting the value to firstname doesn't suppress anything.
Does anyone know how to supress a textbox if the value is empty? Thanks...
May 6, 2008 at 10:19 am
I'm having (what I think is) the same issue-- how to suppress an entire matrix row when there is a particular value. Visibility is not a property when you click on the row, so I go to each cell in the row and set =Iif(ReportItems("cell name").Value ="whatevervalue)",True,False)
The result is a gap in the rows (the entire row is blank, but not collapsed).
If anyone has an idea, please help!
May 6, 2008 at 11:29 am
The answer to my problem isn't fixed by visibility, but by filtering:
On the Matrix itself's properties:
Add a filter where
Fields!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply