SQL Server Performance Forum – Threads Archive

Clickthrough

Hi, 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

---

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
http://www.SQL-Server-Performance.Com
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.

---

]]>