SSRS 2008 Archive

  • A use case has been presented where users wish to receive email notification of certain records matching various criteria. Additionally, the notification subscription should only notify the user if records...

    SSRS 2008 Data Driven Subscriptions and Alerts

    A use case has been presented where users wish to receive email notification of certain records matching various criteria. Additionally, the notification subscription should only notify the user if records...

    Continue Reading...

  • Wow. Big disappointment for me today. I’ve been hitting my head against a brick wall for the last 1.5 hrs trying to find the Tooltip property in a Dundas Chart...

    How do I set tooltips for datapoints, series or other items within Dundas Chart for Reporting Services?

    Wow. Big disappointment for me today. I’ve been hitting my head against a brick wall for the last 1.5 hrs trying to find the Tooltip property in a Dundas Chart...

    Continue Reading...

  • Yes, okay, call me a dolt for having to take five minutes to find this but I've seen this question asked so many places I figured I'd throw it up here. <br /><br />In Visual Studio 2008 when working on a SQL Server Reporting Services report, you may find that you want to change the order in which the parameters are listed to the end user. Or perhaps you are using unnamed parameters, such as with ODBC, and need to change the order for token replacement in your query. Well in 2008 this is not where you expected it to be if coming from 2005.<br />

    SSRS 2008 Report Parameters Ordering

    Yes, okay, call me a dolt for having to take five minutes to find this but I've seen this question asked so many places I figured I'd throw it up here.

    In Visual Studio 2008 when working on a SQL Server Reporting Services report, you may find that you want to change the order in which the parameters are listed to the end user. Or perhaps you are using unnamed parameters, such as with ODBC, and need to change the order for token replacement in your query. Well in 2008 this is not where you expected it to be if coming from 2005.

    Continue Reading...

  • The MSDN Webcast from September 8, 2008 is the third in a series entitled “SQL Server 2008 Tips & Tricks” focuses on Reporting Services 2008.

Presentation and slide content by IT Mentors

1. SSRS 2008 Architecture/Runtime
2. Configuration
3. New Controls
  a. Tablix
  b. Gauges and Indicators
4. Deployment

### Benefits of Eliminating IIS from the SSRS Architecture
* Easier configuration
  * IIS settings for other applications impact SSRS
* Better resource management

    SQL Server 2008 Tips and Tricks – Reporting Services MSDN Webcast Notes

    The MSDN Webcast from September 8, 2008 is the third in a series entitled “SQL Server 2008 Tips & Tricks” focuses on Reporting Services 2008. Presentation and slide content by IT Mentors 1. SSRS 2008 Architecture/Runtime 2. Configuration 3. New Controls a. Tablix b. Gauges and Indicators 4. Deployment ### Benefits of Eliminating IIS from the SSRS Architecture * Easier configuration * IIS settings for other applications impact SSRS * Better resource management

    Continue Reading...

  • We just ordered our licenses for SQL Server 2008 (various editions). :) Now it is time to get ready for the migration. While doing some research on the actual report .rdl upgrade process I figured I'd put my findings here.

The Performance Point Blog has <a href=this FAQ that has a few good tidbits. The one that stuck out to me was the last one:
    "Q: I know that every once in a while, a 2005 report won’t auto-upgrade to " title="Upgrading SQL Server Reporting Services Reports From 2005 to 2008" />

    Upgrading SQL Server Reporting Services Reports From 2005 to 2008

    We just ordered our licenses for SQL Server 2008 (various editions). :) Now it is time to get ready for the migration. While doing some research on the actual report .rdl upgrade process I figured I'd put my findings here. The Performance Point Blog has this FAQ that has a few good tidbits. The one that stuck out to me was the last one:
    "Q: I know that every once in a while, a 2005 report won’t auto-upgrade to

    Continue Reading...

Bad Behavior has blocked 232 access attempts in the last 7 days.