Re: SQL Reports driving me nuts
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 will@gmail.com 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 stu...@skproactive.com 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. -
RE: SQL Reports driving me nuts
Hey Stuart, Which version are you using? 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: 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. -
Re: SQL Reports driving me nuts
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 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:* 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. 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. -
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.comwrote: 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:* 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. 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. - -- - 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. -
RE: SQL Reports driving me nuts
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. -