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  Can any body please help to do this report in ssrs

Author  Topic  gspravin Starting Member 1 Post Posted - 2007-10-25 : 03:35:04 I have a Report in this format apr 2006 2007 2008 2009 Total Actual Workload JOB Contract Contract A jobnumber1 20(in man-hrs) 50 100 200 370 jobnumber2 20(in man-hrs) 50 100 200 370 Contract B jobnumber1 20(in man-hrs) 50 100 200 370 jobnumber2 20(in man-hrs) 50 100 200 370 ------------------------------------------------------------ Contract Total 80 200 400 400 1340 ------------------------------------------------------------ Proposal Contract D jobnumber1 20(in man-hrs) 50 100 200 370 jobnumber2 20(in man-hrs) 50 100 200 370 Contract E jobnumber1 20(in man-hrs) 50 100 200 370 jobnumber2 20(in man-hrs) 50 100 200 370 ------------------------------------------------------------ Proposal Total 80 200 400 400 1340 ------------------------------------------------------------ Can any body please help how to achieve this kind of format using Sql reporting services.