Drill down in SSRS with Dataset populated using MDX Query - Need help urgently!

Hi

For drill down in SSRS , i retrieve the ClassId and its ParentClassId in a query similar to the one below

NONEMPTY([Classification].[Classification Id].CHILDREN) *NONEMPTY([Classification].[Parent Class Id].CHILDREN)

I then group the Table Row wrt the ClassId and the Parent ClassId respectively, still the data is getting grouped properly. What could be the problem?

Thanking you in advance

Sai

[686 byte] By [Saishyam] at [2007-12-24]

SQL Server

Site Classified