SQL Server Performance


Discussion in 'SQL Server 2005 Reporting Services' started by akus, Feb 6, 2007.

  1. akus New Member


    I've got reporting requirement with need for clickthrough. I see from version features, that "infinite clickthourgh" is only availabe with the enterprise license.

    Can I therefore achieve following simple tabular report with SQL Server 2005 standard edition.

    - +department
    -- +subdepartment
    --- value

    i.e. I want to start with total across all departtments, then expand to see individual depts, then again expand to subdepartments to see individual values at each level.

    This feeds into our evaluation process. Thanks in advance
  2. satya Moderator

    You can get such drill-through using SSIS with SSAS and can embedd into the reporting services to have such information.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page