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 Studio Category
This entry focuses on the code developers add to reports make them work, look better or expose custom functionality. Sometimes it’s simply adding green-bar but when these expressions get complex or have to be incorporated in many places in the report or in many reports (or both) productivity suffers.
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…
This week I’m transitioning my existing Reporting Services catalog to SQL Server 2008 R2. I’m also building a separate VM where I can demonstrate the differences in “native” vs. SharePoint integration. This blog will serve as a notepad to log the issues I encounter along the way. Incidentally, I had to bump up the VM RAM to 3GB to get this install sequence to run without swapping. I also allocated 3 processors to the VM as it was also CPU bound with only one processor. I noticed that deploy performance was noticeably longer once SharePoint integration was enabled.
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.
I’ve been tuning my monthly webinar again to include more information about SQL Server Reporting Services (R2) and Visual Studio 2010. This high-impact series of six 90-minute webinars held over three mornings 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. The fee also includes both of my Reporting Services and Visual Studio books.
Incidentally, Progressive does not care how many people sit in on the sessions so you can fill a meeting room or the local theater if you want to. These are also designed to be interactive—that is, I encourage the attendees to chat in questions anytime or ask over the phone at the end.
In the latest offering I stripped out the “Connecting” session and pushed in a brand-new session “Report Design Foundations” even though the online outline does not reflect this change.
Want a front-row seat in my next Webinar? If so, I’m accepting applications for the live studio audience. All you need to do is send me an note saying why you would like to attend. I can comfortably sit about four people so get your application in early. Let me worry about the conference $999 fee, but if you bring doughnuts for everyone... I’ll pick the audience the Friday before the next talk (which is Monday April 26th at 09:00 Pacific time).
The next offering is May 19-21 09:00 Pacific time.
We’re also introducing a more “basic” workshop “Introduction to Reporting Services” in early June. Stay tuned for more details.