A developer asked a question on MSDN that was similar to a question a few days earlier so I decided to help folks get over the problems of setting report parameters in ReportViewer projects.
Recently in Visual Basic .NET Category
My new webinar/lab class launches next week on February 8-10. It’s the premier edition of a series of lectures and lab exercises that walk report developers through the process of learning enough Visual Basic to create serious report expressions for use with Reporting Services reports.
We follow the introduction to Visual Basic with an in-depth discussion of how to add code-based expressions to your reports, but more importantly, how to share the code between reports. The final session shows how to create managed-code DLLs that can be developed in C#, VB.NET or any .NET CLR language and leveraged by the report processor when rendering your report.
The mentored lab exercises walk you through the process of creating a Visual Basic test-harness, coding and debugging complex code expressions and finally, you’ll create your own sharable managed-code DLL that can be used in all kinds of deployed reports.
Here’s the link to the Progressive site.
It was brought to my attention that there was some concern that the “amateur” LightSwitch developers would be incapable of writing stored procedures so the tool should not support accessing them—it doesn’t. Here is my response along with a couple of other questions for Microsoft…
Microsoft is gearing up to announce “LightSwitch”, it’s newest data application developer tool. Targeted to developers of “…all skill levels” it’s designed to permit access to local or remote data sources including SQL Server, Azure and SharePoint. I assume this means that amateur developers will have another tool to work with—assuming they can afford it and their IT organization will let them use it.
Frankly, I’ve known about this new offering for some time but until now, I was under NDA and could not reveal any of its details (or even the name). Now that it’s been released, I have a few choice words to add to the drumbeat…
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 12 2010 at THE MIXER on the Microsoft campus, 15255 NE 40th Street, North Commons, REDMOND, WA 98052. Admittance to this event is free, all costs are covered by donations and sponsorships.
Please register soon as seating is limited, and let friends and colleagues know about the event.
A third-party report generator (Pebble Reports) sent me this IBM presentation (see page 71) when I asked if their tool supported 2005, 2008 or 2010 RDL (they only support 2005).
“We depend on ReportViewer control for printing purposes and we are as miffed as you are that ReportViewer is always out of sync with ReportServer. Even MS competitors are taking advantage of this situation, for example see slide 71 of this IBM presentation where they talk about Microsoft's version incompatibilities.”
This further adds to the argument that Microsoft is not seen as capable of keeping their various development paradigms and the metadata they support in sync. I pounded on this issue two years ago when Visual Studio 2008 was getting ready to ship. However, two years later Visual Studio BI and ReportViewer developers are facing the same lack of compatibility with the latest RDL (about to ship with SQL Server 2008 R2). Are developers expected to wait another two years before the ReportViewer control will work with RDL 2010 in local mode? By then I expect additional innovations to be out of reach as RDL evolves—leaving the ReportViewer control perpetually one version behind.
Progressive Business and Beta V have partnered together to present another series of technical webinars. The current series focuses on SQL Server and Reporting Services and consists of six 90-minute talks given two a day for three days. The next scheduled offerings are September 9-11, October 13-15 and November 2-5th. See the following link for an outline and pricing details. Note that this series includes a copy of Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition) as well as a copy of Hitchhiker’s Guide to SQL Server 2000 Reporting Services—once we get them from the publisher…
Visual Studio, SQL Server & Reporting Services: 6 High Impact Training Sessions
This is a set of 6 seminars given in two parts—one that focuses on SQL Server, the second on Reporting Services. This high-impact series of training webinars is for anyone who wants to leverage Visual Studio, SQL Server and Reporting Services best practices—learning what works, what doesn't and why. These sessions are for developers, architects and managers who want to know how and (more importantly) when to leverage the power and benefits of SQL Server and Reporting Services.