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. -
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. -
Visual accessibility Re: field/button/control labeling enforcement in Visual Studio sometime: who agrees with this proposal?
Katherine, I'm a lurker on this list. Not being visually impaired myself, I hadn't thought about people such as yourself having such frustration with the tools we use, as most attention goes to online accessiblity. Perhaps Microsoft and others aren't aware (or aware enough) that blind people do write code. You mention open source so from your point of view how does Eclipse stack up in impaired accessibility compared to Visual Studio? As for website accessibility, I'm hoping you're better served. When I designed and built the online public litter and illegal dumping reporting system for the Queensland Government there was a strong mandate in the requirements to make it accessible to visually impaired people, at least for all the public-facing components. Alt tags, no flash, caption tags, careful Javascript use, no frames and other strict requirements were set. TO achieve this I found the US government Section 508 Web Accessibility Standards to be very helpful, as well as the Illinois Center for Information Technology and Web Accessibility guidelines. To test accessibility I found browser plug-ins such as the JAWS and WAVE toolbars to be very helpful as these allowed me to see what the page would look like to an e-reader as well as in contrasting large fonts for use by a partially sighted person. If you had a few minutes time I'd be interested in what your e-reader makes of the accessibility of my litter reporting site https://report-littering-dumping.ehp.qld.gov.au (Written in C# / .NET / MVC2 / LINQ to SQL / SQL Server 2008) Steve Malikoff. Hello guys, I was just wondering how many of you agree with this. I, who's desire it is to become an open source .NET Framework programmer, look at all of the both open source, and not to mention, Microsoft-provided products, and I can't tell you how much lazy programming I see out there. I'm not calling you lazy programmers, so please, please don't take it that way. I'm just saying, that for the masses, and especially for the many blind and visually impaired users like me who rely on everything being labeled so that screen readers, or software that converts text on screen to speech, can understand and provide the right information. Half of the time, I will download a piece of software whether open source or otherwise, and I will never be able to utilize it due to nothing being labeled, or some things being labeled and others not, giving only half the experience to someone hard of seeing like me. Now, what I am proposing is strong and provocative, but I think that it could pote! ntially be a good thing if implemented correctly. I think that it would be a good idea for Visual Studio to have a compilation requirement that all elements are labeled, and all UIA properties exposable by a control are implemented. Microsoft themselves are lazy when it comes to that; a lot of their new interface for Windows server 2012 for instance, has so much mislabeled and missing UIA content that either screen readers don't read at all, or they read spurious content, as if they are reading .NET classes, instead of application-generated, administrator-friendly messages. My friend thinks that this would only work if Microsoft themselves built this in, and he may be right. But I definitely think that it should be required on most open source projects and open source frameworks that all elements be labled and exposed that way people of all abilities and disabilities alike can benefit. I don't see how it would work in the commercial sector unless Microsoft implemented ! it. Tell me what you guys think.
RE: field/button/control labeling enforcement in Visual Studio sometime: who agrees with this proposal?
(Don't work on Windows Server so can't answer this for them) Are you see this in Visual Studio itself? We do accessibility test runs and the like to try and catch most of these - but I wouldn't be surprised if we missed this in some places due to the how much UI we actually have. I'd be happy to start filing bugs against teams if you point them out to me. -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Katherine Moss Sent: Tuesday, December 11, 2012 7:08 PM To: ozdotnet@ozdotnet.com Subject: field/button/control labeling enforcement in Visual Studio sometime: who agrees with this proposal? Hello guys, I was just wondering how many of you agree with this. I, who's desire it is to become an open source .NET Framework programmer, look at all of the both open source, and not to mention, Microsoft-provided products, and I can't tell you how much lazy programming I see out there. I'm not calling you lazy programmers, so please, please don't take it that way. I'm just saying, that for the masses, and especially for the many blind and visually impaired users like me who rely on everything being labeled so that screen readers, or software that converts text on screen to speech, can understand and provide the right information. Half of the time, I will download a piece of software whether open source or otherwise, and I will never be able to utilize it due to nothing being labeled, or some things being labeled and others not, giving only half the experience to someone hard of seeing like me. Now, what I am proposing is strong and provocative, but I think that it could potentially be a good thing if implemented correctly. I think that it would be a good idea for Visual Studio to have a compilation requirement that all elements are labeled, and all UIA properties exposable by a control are implemented. Microsoft themselves are lazy when it comes to that; a lot of their new interface for Windows server 2012 for instance, has so much mislabeled and missing UIA content that either screen readers don't read at all, or they read spurious content, as if they are reading .NET classes, instead of application-generated, administrator-friendly messages. My friend thinks that this would only work if Microsoft themselves built this in, and he may be right. But I definitely think that it should be required on most open source projects and open source frameworks that all elements be labled and exposed that way people of all abilities and disabilities alike can benefit. I don't see how it would work in the commercial sector unless Microsoft implemented it. Tell me what you guys think.
What is the most cost effective way of getting VS 2012 Pro + MS Office for development ?
Hello everyone, What is the most cost effective way of getting VS 2012 Pro + MS Office for development ? Anyone knows a VS 2012 pro allows for 2 non-concurrent use? ( one at home and one at work?) Thank you all for any ideas/suggestions Arjang