Hi Stuart,
Are you setting the visibility of the tablix itself with an expression or just hiding the rows? You might also get better responses for SQL issues on the SQL list: <http://www.sqldownunder.com/Resources/EMailSupportListserver.aspx> http://www.sqldownunder.com/Resources/EMailSupportListserver.aspx Another good option is #sqlhelp on twitter. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: <http://www.sqldownunder.com/> www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stuart Kinnear Sent: Friday, 14 December 2012 10:45 AM To: ozDotNet Subject: Re: SQL Reports driving me nuts I think the adage "if at first you don't succeed, never try again" can be applied to this problem. No co-operation here so I've dropped it. The solution is to write separate reports for each scenario, not ideal nor elegant but it will have to do. I tried in both client side reports - Visual Studio 10 and server side SSRS 2008 & the same problem occurs. A trivial exercise in other event driven report managers is a nightmare in this beast. - Stuart On 13 December 2012 22:59, Stuart Kinnear <stu...@skproactive.com> wrote: 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) <g...@greglow.com <mailto:g...@greglow.com> > wrote: Hey Stuart, Which version are you using? Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775 <tel:%281300%20775%20775> ) office | +61 419201410 <tel:%2B61%20419201410> mobile│ +61 3 8676 4913 <tel:%2B61%203%208676%204913> fax SQL Down Under | Web: <http://www.sqldownunder.com/> www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com <mailto:ozdotnet-boun...@ozdotnet.com> [mailto:ozdotnet-boun...@ozdotnet.com <mailto:ozdotnet-boun...@ozdotnet.com> ] 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 <tel:040%20704%205686> . Office: 03 9589 6502 <tel:03%209589%206502> 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 <tel:040%20704%205686> . Office: 03 9589 6502 <tel:03%209589%206502> 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. -----------------------------------------------------------------------------