Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  MAtrix Report with drill-through

Author  Topic  joshker Starting Member 6 Posts Posted - 2007-03-13 : 08:36:14 Hi, I have a table which has a country, division, category, product, Valuetype, value data looks like this: Country division, category, product, Valuetype, value --------------------------------------------------------------------- UK Division1 Food Pizza Volume 10000 UK Division1 Food Pizza Revenue 2000 UK Division1 Food Pizza ROI 4.5 UK Division2 Food Pizza Volume 14000 UK Division2 Food Pizza Revenue 2400 UK Division2 Food Pizza ROI 4.1 UK Division2 Drinks Cola Volume 14000 UK Division2 Drinks Cola Revenue 2400 UK Division2 Drinks Cola ROI 4.1 I want to build a drill-through report to be grouped on country, division, category and product. Can someone help me with some suggestions? Cheers Josh