Have you tried putting the two tablixes into seperate tablixes and utilising the column visibility of the parent tablixes?
>>> Yes I tried this but the problem I outlined below is that the inner tablix adopts the recordsource of the outer. I could live with that but the second exception occurs - it don't apply to Tablix. No matter what I do - column or row visibility, hidden on otherwise, that inner tablix is a stubborn creature and insists it's personal space is not going to be vacated. The joys of software development ! - Stuart On 14 December 2012 15:00, William Luu <[email protected]> wrote: > 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. >> >> ----------------------------------------------------------------------------- >> >> > -- ----------------------------------------------------------------------------- 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. -----------------------------------------------------------------------------
