Reporting Services (2005) uses the ReportServerTempDb database to store cached reports and temporary snapshots. Two of the stored procedure calls I see are WriteChunkPortion and ReadChunkPortion. Because I see that the MS ASP Session state manager also use the WriteChunkPortion call, and the parameter values, I am inclined to think these ...

Buck Woody has a great series going on SQL Server ManagementStudio Standard Reports. The SQL Server team did a great job developing these insightful and intuitive reports. I often show them to customers and during presentations and the response is always positive. :{> Andy

I had a great discussion while teaching a class on Reporting Services today, discussing the basics of report design (yes, I make them consider basic principles of report design before I start talking about the technical details - I'm a stickler that way). That made me consider some of the most common design issues that I see with SSRS and the ...

Brian Welcker (who is leaving SSRS team - good luck Brian!) has announced a long explanation of the Report Builder 2008 positioning. For me (and all of you who live in the multidimensional business...) the most important part of the post is this simple sentence: [...] However, for folks building reports against Analysis Services cubes, ...

Microsoft has severed the IIS dependency for SQL Server Reporting Services (SSRS) in the 2008 version, according to a couple sources. Reasons cited include : Deployment considerations (some enterprises prohibit IIS on database servers). Better configuration. Better resource management.  :{> Andy

I have a new Dell desktop. The first thing I did was install Vista 64-bit and bumped it up to 4GB of RAM. I'm now trying to install a default instance of SQL Server 2005 Developer and can't get Reporting Services to run because IIS isn't installed. After trying the click-a-bunch-of-stuff in the ''Turn Windows features on or off'' dialog, I ...

I'm attending a session about SQL Server Reporting Services 2008 where I've seen one of the mostly wanted missing features of previous versions of Reporting Services: it is the Rich TextBox component, that can embed placeholders to compose text with data producing reports for contracts and documentation. The RDL still maintain a complete ...

I just attended the session named ''Applied Microsoft SQL Server 2005 Reporting Services'' held by of Teo Lachev . Teo developed a complex solution that allow an end user to build its own reports with financial data, using Reporting Services as a back-end engine but defining its own custom report designer. While someone may object that there ...

I deployed an ASP.NET  application to another server and the page that includes a few ReportViewer controls started showing the ''ASP.NET session has expired'' error in each report. The same web app worked totally fine on my box. I didn’t have time to investigate before I moved on to other work and then a few days later I came across a ...

Almost ten years ago (...ouch!) I visited Australia and I had a real love for Sydney. I got these memories tonight because I found a detailed list when I was looking for some existing request for new features in Reporting Services. One is the Rich TextBox feature. Another is the lack of support for styles: there are many possible implementations, ...