Nitin Dhawan CRM Discussion

A CRM Monster [MCDP, MCDS, MCTS, MCSD]

Archive for the ‘Reports’ Category

Adding alternating row color to SSRS report

Posted by Nitin Dhawan on June 27, 2009

Steps:

  1. Goto Report Designer in SSRS Solution
  2. Go to the table row’s BackgroundColor property and choose “Expression”
  3. Add expression

             =IIf(RowNumber(Nothing) Mod 2 = 0, "Green", "Transparent")

With this approach we can target any area in report.

Posted in Reports | Tagged: | Leave a Comment »

Configuring SQL Server Reporting Services

Posted by Nitin Dhawan on June 18, 2009

Prerequisites

  • SQL server 2005 with SP2 or 2008 reporting services  Installed in web server.
  • SRS Data Connector  Installed in web server
  • SQL server 2005 or SQL server 2008

Configuration

  • On the Reporting Server Virtual Directory tab create a new “Reporting Server Virtual Directory” with the  following [Name] and [Website] i..e Name: ReportServer, Website: Default Web Site
  • Select “Apply” and wait for the RS wizard to complete the creation of the reporting server virtual  directory. No changes are necessary for the SSL settings unless the customer environment has SSL configured.
  • Verify that all “Reporting Server Virtual Directory” tasks complete successfully.
  • On the Report Manager Virtual Directory, create a new “Report Manager Virtual Directory” with the  following [Name] and [Website] i.e. Name: Reports, Website: Default Web Site
  • Select “Apply” and wait for the RS wizard to complete the creation of the report manager virtual  directory.
  • Verify that all “Report Manager Virtual Directory” tasks complete successfully.
  • On the Windows Service identity tab specify the “Windows Service Identity” for the report server use the  following settings i.e. Built-In Account: Network Service
  • Select “Apply” and wait for the RS wizard to complete the report server account configuration.
  • Verify that all “Windows Service Identity” tasks complete successfully.
  • On the Web Service Identity configure the RS “Web Service Identity” by creating a new “Application Pool”  for both the Report Server and Report Manager.
    • The new identity was configured as follows:
    • Application Pool Name: ReportServer
    • Select the “Built-In Account” radio button
    • Select the “Network Service” account from the drop-down menu.
    • Select “ok”
      • In the “Report Manager” drop-down menu select the new pool “ReportServer” from the drop down menu.
      • Select “Apply” and wait for the RS wizard to complete the report server web service identity  configuration.
      • Verify that all “Windows Service Identity” tasks complete successfully.
      • On the Database Setup tab configure the database connection and create a Reporting Server database as follows:
        • Connect to the Database Engine that will be used for Reporting Services. Note that this is not the Master database, and is solely for the operational requirements of Reporting Services. Typically this will be a SQL Server 2005 Database Engine that resides on the same SQL Server instance as Reporting Services.
        • Select the “New” button and configure the Reporting Server Database as follows:
          • Server Name: LOCAL <or Designated SQL Server 2005 Database Engine> (should be completed if you successfully connected to the existing database)
          • Credentials Type: Current User – Integrated Security
          • Username: NULL
          • Password: NULL
          • Database Name: ReportServer
          • Language: English
    • Select “Ok” then select the “Apply” button to create the new database and complete the database connection configuration.
    • Verify that all “Database creation” tasks complete successfully.
  • Proceed to the “Initialization” tab and verify that the new database is initialized. If not, select the database and select the “initialize” button.
  • Select the “Apply” button and verify that all “Initialization” tasks complete successfully.

Posted in Reports | Tagged: , , , | Leave a Comment »