Tags: database, drill-down, drill-up, microsoft, mysql, oracle, pivot, reporting, server, services, slice, sql, table, tables

Reporting Services and Pivot Tables

On Database » Microsoft SQL Server

1,394 words with 1 Comments; publish: Sun, 01 Jun 2008 23:13:00 GMT; (250125.00, « »)

Hi everyone,

I would like to know if it's possible to have a pivot table (with all the

features of pivot tables: drill-down, drill-up. slice, pivot dimensions,...)

in a report created using Reporting Services.

I'm not sure if office web components could be a solution.

Thank you!

All Comments

Leave a comment...

  • 1 Comments
    • Javier,

      All of those are possible when you export to HTML OWC format with a caveat

      that you are always restricted to the data scope of your report query

      because the exported report will not be connected to the data source. If you

      need to change dimensions and measures at will (outside of the query scope)

      you need to switch to OWC connected to Analysis Services directly.

      --

      Hope this helps.

      ---

      Teo Lachev, MCSD, MCT

      Author: "Microsoft Reporting Services in Action"

      http://www.prologika.com

      "Javier Catala" <Javier Catala.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      news:52395C5D-40DF-4545-8D6B-6437C29C551B.sqlserver.todaysummary.com.microsoft.com...

      > Hi everyone,

      > I would like to know if it's possible to have a pivot table (with all the

      > features of pivot tables: drill-down, drill-up. slice, pivot

      dimensions,...)

      > in a report created using Reporting Services.

      > I'm not sure if office web components could be a solution.

      > Thank you!

      #1; Sun, 01 Jun 2008 23:15:00 GMT