Robert Bruckner's Reporting Services & Power View Blog

Power View, Tips and Tricks for SQL Server Reporting Services, RDL Report Design, Business Intelligence

Browse by Tags

Tagged Content List
  • Blog Post: Debugging Custom Extensions with Visual Studio 2010

    If you are developing custom extensions for Reporting Services (such as a data processing extension, delivery extension, security extension, rendering extension, report definition customization extension) with Visual Studio 2010, you have to make sure you compile the extension for the .NET 2.0/3.5 CLR...
  • Blog Post: Reporting Services 2005 Resources

    MSDN information aggregator site for Reporting Services 2005. Important downloads for Reporting Services 2005: SP4: SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266) SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259) SQL Server 2005 SP4 Cumulative Update #1 (build 9...
  • Blog Post: Reporting Services Recipes Book Downloads

    The Reporting Services Recipes book contains detailed step-by-step instructions and explanations for each report design recipe. We also know that readers want to learn at their own pace, and sometimes don’t have the time to go step-by-step, but instead want to play with the final report first and then...
  • Blog Post: Reporting Services Recipes Book Released

    This book should be on the shelves any day now and is truly special! It draws from the experience of many Reporting Services industry experts and brings together best practices and report design patterns. I co-authored this book with Paul Turley, and it also includes great contributions from Grant Paisley...
  • Blog Post: Reporting Services Books

    A short list of my personal recommendations for the latest Reporting Services books. Disclaimer: I read all these books, and in most cases performed partial or complete technical reviews of the contents, and provided material contributions to some. Reporting Services 2012 books: Professional...
  • Blog Post: SharePoint Integrated Mode

    Chris Alton’s whitepaper on Reporting Services SharePoint Integration Troubleshooting is now available on MSDN. It provides a great set of configuration tips, diagnosis, and troubleshooting instructions. The following two older Reporting Services 2005 SharePoint Integrated Mode related whitepapers...
  • Blog Post: Tablix – Multiple Subtotals Are Easy (aka Goodbye InScope)!

    Reporting Services 2005 with Matrix In a matrix in Reporting Services 2005, accomplishing multiple or different subtotal calculations at the same grouping level was difficult, but possible. If you wanted to accomplish custom subtotal calculations in RS 2005, you may have heard about using the InScope...
  • Blog Post: Subreport Usage

    In a previous post I showed how to quickly find reports that use custom report items (CRIs). The same idea can be applied to subreports as well. As an administrator of a report server, you may access the catalog database directly. Keep in mind that any queries you execute directly against the report...
  • Blog Post: RS Tracer

    Have you ever wondered what API calls Report Manager or Management Studio are performing to accomplish certain operations?  Teo Lachev’s RsTracer helps answer these questions.  The tool is available as a CodePlex project and shows the APIs that a Reporting Services client invokes and what arguments...
  • Blog Post: The Ultimate Guide to Color Scales / Conditional Formatting

    I recently provided a tip to my Australian colleague David Lean to successfully solve a small report design challenge with tables and charts that use conditional formatting. The specific goal was to dynamically calculate and assign a color shade so that the minimum value present in the data is shown...
  • Blog Post: BIDS Helper, RS Scripter

    I wanted to point out two Reporting Services utilities built by our MVPs and user community that you may find very useful. BIDS Helper is a CodePlex project: http://www.codeplex.com/bidshelper In past releases, the focus has been on significantly enhancing Analysis Services and Integration Services...
  • Blog Post: Report Server Optimizations

    The fourth and final technical note " Reporting Services Performance Optimizations " in our series on Building and Deploying Large Scale SQL Server Reporting Services Environments is now available on SQLCAT.com. The focus of this final technical note is on how to optimize your Reporting Services architecture...
  • Blog Post: Optimizing Reports - Show the Right Set of Data

    You are probably now thinking, of course my report shows the right data! Ok, but is it fast (enough)? My esteemed colleague Dean Kalanquin started blogging recently. He has been working in databases for a long time, and has gained great experience and knowledge by working on several different...
  • Blog Post: Report Performance Optimization Tips (Subreports, Drilldown)

    In a previous posting, I explained the new ExecutionLog2 view in Reporting Services 2008: how to utilize it to measure report execution performance, identify report candidates for optimizations, and verify the impact of the latter. I also included two tips at the bottom of that posting, that I want to...
  • Blog Post: What Kind of Reports are Published / Which Use Custom Report Items?

    As an administrator of a report server, you may occasionally ask yourself the question of what kind of reports are published in terms of their particular feature usage. For example: · Usage of Custom Report Items (CRIs) You plan to upgrade from RS 2005 to RS 2008 and there are CRI controls installed...
  • Blog Post: Using Teradata's .NET Data Provider

    Reporting Services 2008 RS 2008 includes full support for Teradata-based report models. You can create and use semantic models based off Teradata similar to how Reporting Services already supports this for SQL Server, Analysis Services, and Oracle. Furthermore, RS 2008 includes a Teradata data extension...
  • Blog Post: Technical Note Series on Reporting Services Performance and Scalability

    Over the past few months, I contributed to a series of technical notes by my esteemed colleagues Denny and Lukasz on http://sqlcat.com/ . The technical notes provide guidance on how to build, deploy, and optimize large scale SQL Server Reporting Services (SSRS) environments. We derived some of the best...
  • Blog Post: Do You ▖ Unicode in PDF?

    One of the changes we included in Cumulative Update #1 for SQL Server 2008 ( CU1 download link ) is automatic full font embedding and subsetting for Unicode characters in Reporting Services 2008 PDF rendering . While a similar code change is now available for Reporting Services 2005 PDF rendering...
  • Blog Post: What DataSet Query Text Is Executed?

    In a previous posting, I discussed dataset execution order in Reporting Services. In this posting, I will provide a few tips for situations where you or your report users are wondering what is the actual query executed by Reporting Services. While you can accurately answer this question using a profiler...
  • Blog Post: Using Analysis Services Parent-Child Hierarchies in Reports

    One of the questions that I answer somewhat frequently, is about recursive groupings in Reporting Services and how to utilize parent-child hierarchies from an Analysis Services cube. The attachment of this posting contains a small report example I put together based on the Analysis Services 2005 Adventure...
  • Blog Post: Expression-Based Dynamic Drillthrough Actions

    The Reporting Services demo during the " BI Power Hour " session at the Microsoft Business Intelligence Conference was a lot of fun and well received. My colleague Carolyn Chau did great on stage presenting the demo we had put together. In my chalk talk the next morning, I then spent a few minutes explaining...
  • Blog Post: Dataset Execution Order

    A Reporting Services report can contain multiple dataset definitions. By default, datasets are executed in parallel . Now, in some situations you may not want this parallel query execution behavior - for example: Your data source system cannot handle too many parallel connections. You are executing...
  • Blog Post: Using Group Variables in Reporting Services 2008 for Custom Aggregation

    Introduction SQL Server 2008 Reporting Services (SSRS 2008) features an on-demand report processing engine . This on-demand architecture has a number of key advantages over the processing engine design that existed in previous major releases. The most significant benefits are vast improvements to report...
Page 1 of 1 (23 items)