Hi Stuart, Have you tried putting the two tablixes into seperate tablixes and utilising the column visibility of the parent tablixes?
So essentially, what is outlined here - http://www.sqlchick.com/entries/2011/3/5/dealing-with-white-space-due-to-a-hidden-textbox-in-reportin.html But where they say TextBox, put a Tablix in there. And follow what they say about setting the ColumnVisiblity of the parent Tablix (and there being two parent tablixes with a single tablix with your data in each of the two parent tablixes). Disclaimer: This is just an idea, I haven't actually tried this approach. I have however, dynamically hidden elements in SSRS and it leaves a bit of whitespace (the exact amount being the initial size of the element - such as a TextBox). So I end up just resizing my textbox to as minimum height as possible. You might also have more luck with the SQLDownUnder mailing list as Greg suggested. Will On 13 December 2012 21:02, Stuart Kinnear <[email protected]> wrote: > I am trawling the net for solutions but haven't come up with one yet, so > hopefully someone out there can assist. > > I have a report that is composed of two tablix controls one above another. > > Tablix A has an unique set data > Tablix B has an unique set data . > > If tablix A or B has no data the control should hide itself and collapse > its presence ie zero height. > > The problem is that if Tablix A has no data it uses up its allocated > height, however, if we swap the scenario and have no data in Tablix B no > height is taken, because of the report property > 'ConsumeContainerWhiteSpace'. > > Next I thought I could embed the tablix controls within a host tablix, > then set the rowVisibility property based on the tablix A or B Hidden > property or its underlying dataset's row count. Much cussing and > infuriation - the child tablix controls cannot have independent data > sources. > > Where to next ? toss the whole lot in the bin and go back to ComponentOne > ? Surely this can't be that difficult ! > > > > -- > > ----------------------------------------------------------------------------- > Stuart Kinnear > Mobile: 040 704 5686. Office: 03 9589 6502 > > SK Pro-Active! Pty Ltd > acn. 81 072 778 262 > PO Box 6117 Cromer, Vic 3193. Australia > > Business software developers. > SQL Server, Visual Basic, C# , Asp.Net, Microsoft Office. > > ----------------------------------------------------------------------------- > >
