John Gallardo's Weblog

From SQL Server Reporting Services

Posts
  • John Gallardo's Weblog

    RS PowerShell Gems – The WMI Provider

    • 0 Comments
    For IT administration of a Report Server instance, you will occasionally need to use WMI.  We try to ease this to some extent by exposing a command line tool rsconfig.exe as well as the RS Configuration Tool UI. That said, sometimes you just need...
  • John Gallardo's Weblog

    RunningJobContext.IsClientConnected

    • 1 Comments
    I’ve seen a few people get confused over what this error message in the Reporting Services log file indicates. This message is generated when the Reporting Services web server detects that an HTTP request has experienced a remote disconnect.  In...
  • John Gallardo's Weblog

    Hiding parameter area when viewing reports

    • 1 Comments
    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...
  • John Gallardo's Weblog

    Hiding Rendering Extensions

    • 1 Comments
    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...
  • John Gallardo's Weblog

    RS Blogger shout-outs

    • 1 Comments
    If you are interested in Reporting Services, you probably already know about these blogs … because frankly they have more interesting things to say than me!  At any rate, just in case they happened to slip through the cracks for you , I thought I...
  • John Gallardo's Weblog

    Avoid using HttpContext in your reports

    • 0 Comments
    On one of our internal mailing lists, someone was asking trying to retrieve some HTTP Headers that their internal application was submitting to the Report Server within the report.  Someone else responded with a code snippet containing the custom...
  • John Gallardo's Weblog

    Scaling out the Viewer Control and rsExecutionNotFound

    • 0 Comments
    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...
  • John Gallardo's Weblog

    Scaling Up: SSRS 2008 vs. SSRS 2005 (spoiler: 2008 wins)

    • 0 Comments
    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...
  • John Gallardo's Weblog

    All those temporary files (RSTempFiles)

    • 0 Comments
    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...
  • John Gallardo's Weblog

    Joel on Martian Headsets (standards)

    • 0 Comments
    I'm generally not a big fan of the "link dump" style blog. However, the latest post on Joel On Software regarding web standards was too good not to share. Some choice quotes... Regarding "working around" problems in an implementation (bolded by me): And...
  • John Gallardo's Weblog

    More on SSRS 2008 memory management

    • 1 Comments
    This is a continuation of a previous posting that I made which introduced some of the memory management functionality in SSRS 2008. In this post, I wanted to dig a bit more into the details of the system in order to illuminate some of the decisions that...
  • John Gallardo's Weblog

    Where has John been?

    • 0 Comments
    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...
  • John Gallardo's Weblog

    Memory Management in Reporting Services 2008

    • 2 Comments
    One of the big pushes for SSRS 2008 has been to reduce the occurrence of OutOfMemoryExceptions caused during report execution.  A lot of work has gone into making this happen throughout the report rendering stack, including significant changes in...
  • John Gallardo's Weblog

    Ensuring up to date results through URL Access

    • 1 Comments
    A pretty common pattern that I see exporting of reports through URL Access using a simple hyperlink. The hyperlink usually looks something like this: <a href="http://localhost/reportserver/?/SalesData&rs:Command=Render&rs:Format=EXCEL">Sales...
  • John Gallardo's Weblog

    Back from a blogging vacation?

    • 0 Comments
    I guess it was an unintended vacation.  We've been busy here in the Reporting Services team.  CTP5 of SQL Server 2008 was a large milestone for us as it really started to put together all of the work we have been doing to make the processing...
  • John Gallardo's Weblog

    SQL Server 2008 (Katmai) and Reporting Services

    • 0 Comments
    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...
  • John Gallardo's Weblog

    EMF Rendering and Persisted Streams

    • 1 Comments
    EMF rendering in Reporting Services has an interesting history. When SSRS first shipped, we did not support "direct printing" from within the web interface. Customers revolted. They wanted a "Print" button on the toolbar which would provide a full featured...
  • John Gallardo's Weblog

    Diagnosing Reporting Services Issues

    • 0 Comments
    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...
  • John Gallardo's Weblog

    ReportServerTempDB IO Saturation

    • 1 Comments
    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...
  • John Gallardo's Weblog

    Aggregating rsExecutionNotFound Posts

    • 1 Comments
    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...
  • John Gallardo's Weblog

    Careful when using rc:Toolbar=false

    • 1 Comments
    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...
  • John Gallardo's Weblog

    Mono device makes good -- wins award

    • 1 Comments
    From Miguel de Icaza's blog: http://tirania.org/blog/archive/2007/Jan-17.html I had no idea that the Sansa was running Mono. Personally, I think it is really great that there are multiple implementations of the CLR. It is even cooler that a Mono-based...
  • John Gallardo's Weblog

    Load Testing Reporting Services

    • 2 Comments
    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...
  • John Gallardo's Weblog

    Diagnosing rsInternalError

    • 0 Comments
    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...
  • John Gallardo's Weblog

    A Great Place to Ask a Question

    • 0 Comments
    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...
Page 1 of 3 (65 items) 123