I am new to reporting services and need to create a report, that I think needs a matrix object. To keep it simple - If I have three fields: asofdate, salaryamount, bonusamount and want the asofdate field to go across the report (column header) and the salaryamount and bonusamount to go down the report (row). The detail should be the total amount for each asofdate. My query looks like "select asofdate, salaryamount, bonusamount from table1 order by asofdate desc" I think I have to use the matrix object but it isn't working out. I am putting the asofdate field in the column group and I see my asofdates go across the report However when I put the salaryamount in the row I only see data in the detail for the first asofdate (most recent month end asofdate, the other asofdate are empty. am I missing something? Thanks

OK here what you need to do, Drop asofdate in column group Than right click on Data Field and Insert Column ,Select Right Now you have 2 data fileds under your AsofDate drop your salaryamount,bonusamount in each of them and i guess you are good to goooGaurav Gupta http://sqlservermsbiblog.blogspot.com/