SSRS 2008. I think I am getting closer but still struggling. I set both tablix to the same dataset and filtered it. This way I was able to embed the two tablix within a parent tablix.
But setting the row visibility did not do anything different - Arrgh ! Anyway, I've come across another article suggesting a static row group. This I'll try tomorrow when I've cooled down a bit. - Stuart On 13 December 2012 21:12, Greg Low (GregLow.com) <[email protected]> wrote: > Hey Stuart,**** > > ** ** > > Which version are you using?**** > > ** ** > > Regards,**** > > ** ** > > Greg**** > > ** ** > > Dr Greg Low**** > > ** ** > > 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913fax > **** > > SQL Down Under | Web: www.sqldownunder.com**** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Stuart Kinnear > *Sent:* Thursday, 13 December 2012 9:03 PM > *To:* ozDotNet > *Subject:* SQL Reports driving me nuts**** > > ** ** > > 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. -----------------------------------------------------------------------------
