Clickthrough | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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
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.