John Gallardo's Weblog

From Windows Phone

Browse by Tags

Tagged Content List
  • Blog Post: Hiding parameter area when viewing reports

    When rendering reports, oftentimes the application would like to minimize as much of the non-report area of the viewer control as possible.  This is easily accomplished when rendering the report through the built-in report viewer control hosted in the ReportServer web site (http://servername/reportserver...
  • Blog Post: Hiding Rendering Extensions

    This is documented behavior, but we see lots of questions on it.  A good mechanism for preventing users from accidently exporting reports to a format that you don’t want (for example, you might know that the report doesn’t render quite right in a particular format) is to mark the extension as “invisible...
  • Blog Post: Scaling out the Viewer Control and rsExecutionNotFound

    One of the criteria that the report server uses to match the provided SessionID with a stored report is that the SessionID has to be provided by the same user that initially created the session. Usually, this is the case. Someone browses the report in IE, they click around to paginate or expand toggles...
  • Blog Post: Scaling Up: SSRS 2008 vs. SSRS 2005 (spoiler: 2008 wins)

    The SQL Customer Advisory Team just released a Technical Note comparing SQL Server Reporting Services 2008 vs. 2005 from a scale-up perspective. Its good to see that a lot of the work that we did over this release focusing on performance and scalability (across the board, from the core server/processing...
  • Blog Post: All those temporary files (RSTempFiles)

    When you install Reporting Services, we create a few directories: LogFiles ReportManager ReportServer RSTempFiles Most of these are fairly self explanatory. LogFiles... well we put our log files in there. ReportManager contains the Report Manager application (what you get when you browse to http://<server>...
  • Blog Post: Where has John been?

    Ok, it has been a little while. But I have been pretty busy lately . His name is Christopher. We have also been pretty busy locking down Katmai to get CTP6 (aka known as the "February CTP") out the door and working bugs. I recommend that people head over towards the "Katmai" forum on MSDN for Reporting...
  • Blog Post: SQL Server 2008 (Katmai) and Reporting Services

    Today the first public release of SQL Server 2008 is shipping. Of course, Reporting Services is still there in the box. You can find general information about the release here: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395&wa=wsignin1.0 There are also some Katmai specific...
  • Blog Post: Diagnosing Reporting Services Issues

    I was poking around some other SSRS blogs from folks here on the product team, and I found this post from Lukasz about troubleshooting Reporting Services . It is a great overview of some of the guidance we have given in the form of whitepapers, KB artciles, and a bunch of other sources. I highly recommend...
  • Blog Post: ReportServerTempDB IO Saturation

    Reporting Services uses a temporary database for storage of objects which are, well, temporary . For example, report snapshots which are associated with a particular user session as the result of a live execution. Cached report snapshots are also stored here because they begin life as a result of a live...
  • Blog Post: Aggregating rsExecutionNotFound Posts

    The posts about things dealing with rsExecutionNotFound seem to be what people find most interesting these days. In order to aggregate the posts into one place, I will be adding links that deal with this error here. Maybe I will add a tag as well... Careful when using rc-Toolbar=false Session...
  • Blog Post: Careful when using rc:Toolbar=false

    I'm in the middle of reinstalling Visual Studio, and so I thought I would share an interesting story from a couple of weeks ago. An internal customer (Microsoft-speak for some other team at Microsoft) of Reporting Services was encountering seemingly random rsExecutionNotFound errors when navigating around...
  • Blog Post: Load Testing Reporting Services

    This question came across one of our internal discussion aliases, and it wasn't the first time I had seen it... so I thought it might be interesting to other people as well. Oftentimes, when people configure a load testing tool they set it up so that all of the connections come from the same logical...
  • Blog Post: Diagnosing rsInternalError

    You know the one. You try to render a report and you end up hitting the dreaded "An internal catalog exception has occurred" error message. Generally speaking, this is an indication that something very bad happened within the server which is not necessarily due to any particular action you performed...
  • Blog Post: A Great Place to Ask a Question

    Recently I have had a couple of people send questions directly to me via the " Email " tab asking me for some specific one-on-one technical support for Reporting Services. I thank you very much for your interest in our product, but unfortunately I am not the best person to direct specific questions towards...
  • Blog Post: Transitioning between SOAP and URL Access

    The SSRS Web Server supports two basic protocols, SOAP and URL Access. The SOAP API is great for managing the catalog and doing some session management within the context of a report session, but is generally not the greatest thing in the world when actually rendering a report. The problem is that since...
  • Blog Post: SQL Express and Reporting Services Catalog

    SQL Server Express with Advanced Services SP1 shipped a while ago and it includes Reporting Services. There is a bit of an annoying issue though. In the Express SKU, the database engine automatically creates databases with AutoClose on. This behavior means that when all of the connections to the database...
  • Blog Post: Session Timeout during execution

    Reporting Services has a notion of a user session. This is not the same as ASP.Net's notion of a user session, and in fact the two are completely orthogonal to each other. SSRS's session maintains information about which report a user is looking at, the data that is in that report (we call this a snapshot...
  • Blog Post: Live Reports and rsReportNotReady Error

    rsReportNotReady is only supposed to be thrown when a report is configured to run from an execution snapshot, and the execution snapshot has not yet been created. It is a pretty rare occurrence and the whole error code is really meant to cover the small window between setting the report to run from an...
  • Blog Post: Should I modify Reporting Services stored procedures?

    The answer, is quite simply "No." Someone shot a post from Google Groups through my inbox this morning where some people were having problems with session timeouts (they were seeing rsExecutionNotFound exceptions). Their "solution" was to edit the stored procedures that manage user session in our...
  • Blog Post: Reporting Services and Windows Authentication

    Windows Authentication is good stuff, and rightly so many people are using it in their Reporting Services deployments. Lately, there has been quite a rash of questions that people have regarding the inability to connect to their data sources when using Windows Authentication. Usually the scenario is...
  • Blog Post: Using XML value() method to take advantage of a relational index

    The Performance Optimizations for XML Data Type in SQL Server 2005 whitepaper written by Shankar gives some pretty good advice for writing your XQuery statements so that they take advantage of an available XML Index. However, oftentimes you will have to deal with incoming XML data which is represented...
  • Blog Post: Transforming XML data into a rowset using the nodes() method

    Usually there are a couple of scenarios in which you want to take XML data and convert it into a regular relational rowset. In SQL 2000, you probably used OpenXML for this, which works pretty well if you are only working on a single piece of XML data, but as soon as you want to convert a rowset of XML...
  • Blog Post: SQL Server Query Optimizer Blog

    Ian Jose, an Architect here in SQL Engine working on the Query Optimizer, has just started a blog . Lots of good tips and practical advice for getting the most out of SQL Server's query optimizer.
  • Blog Post: Using fixed values does not result in smaller instances...

    XML Schema has an interesting feature where you can define a value as being "fixed" . The meaning here is basically that an attribute or element has to have a particular value, and if it is not there in the instance, then that value is implied. However, it is important to realize that this doesn't have...
  • Blog Post: Answer: Fulltext and XML in SQL Server 2005

    A little while ago I threw out this quiz regarding XML and SQL Server 2005's full text search support. As I stated in the quiz, there is a subtle difference between what you can get with contains() and the fulltext support. Specifically, the difference lies in how our full text engine injects whitespace...
Page 1 of 2 (38 items) 12