Bob's SQL Reporting Services Blog

Notes, tips, rants, and ruminations on SQL Reporting Services, and Report Builder in particular.

Browse by Tags

Tagged Content List
  • Blog Post: Considerations for a large report model

    Customer report models that vary in size from a few to a few hundred entities. Little Northwind with its 10 or so entities comes in around 200K, but we've seen models a hundred times that size (over 20 MB). One of the key drivers of model size is the constraint that you cannot build a query across multiple...
  • Blog Post: SQL Server 2008 SP1 available now with important Report Builder 2.0 updates

    SQL Server 2008 SP1 is now available, and includes some important updates related to Report Builder 2.0: - RB 2.0 can now be deployed directly from the report server using ClickOnce. You can also configure whether RB 1.0 or RB 2.0 is launched from the Report Manager and SharePoint UI. - An important...
  • Blog Post: Help RB 2.0 users find and use shared data sources

    Report Builder 2.0 makes it easy for business users to browse for and use centrally-defined and managed data sources. It does this by supporting direct connection to a report server as part of the design experience. It also maintains a list of recently-used data sources that show up at the top of the...
  • Blog Post: How to enable Report Builder for non-domain users

    Report Builder uses a client technology called ClickOnce to download and launch the application files. This component runs outside of Internet Explorer, so it cannot leverage any credentials that may have been collected by IE to access the report server. It can only access and download the Report Builder...
  • Blog Post: How to get the SQL for a Report Builder report

    There are two ways to get the generated SQL for a Report Builder report (or for a model-based query in any RS report): 1) use SQL Profiler to capture the incoming SQL commands, or 2) enable query logging in the report server. To enable query logging on the report server (option #2), make the following...
  • Blog Post: Subscriptions to Report Builder reports

    Many people are interested in creating subscriptions to Report Builder reports. In SQL Server 2005 this is only possible if the reports can be run unattended by the server . If the report has any user-dependent behavior, then it can only be run live by a user. Unfortunately, enabling model item security...
  • Blog Post: Article: Implementing Data Security in a Report Model

    I just posted the first article on my blog. Here's the abstract: The report models introduced in SQL Server 2005 feature a number of ways to customize the data visible to different users and groups: perspectives, model item security, security filters, and opaque expressions. This article describes...
  • Blog Post: Implementing Data Security in a Report Model

    The report models introduced in SQL Server 2005 feature a number of ways to customize the data visible to different users and groups: perspectives, model item security, security filters, and opaque expressions. This article describes when and how to use each of these features. Perspectives A perspective...
Page 1 of 1 (8 items)