Post reply

Reporting Services: Costs Report Showing Costs by Month

  • July 28, 2009 at 11:58 pm

    #136818

    Hello Everyone,

    I would like to create a report in reporting services that shows Costs broken down on a month to month basis as shown below. I don't really know how to start this report. I don't even know if I should use a Matrix or a table or something else. I am looking for some general advice and guidance. If someone has an example procedure to creating a report like this or some advice, I would really appreaciate that help. Thanks!!

    CostsJanFebMarAprMayJun ....... Dec

    Labor

    Materials

    Equipment

    Inventory

    Other

  • July 29, 2009 at 12:49 am

    #1031481

    I think you are using SQL Server 2005 Reporting Services.

    Use simple query to return resultset and an extra column that return month portion of the date column.

    select *,datepart(mm,yourcolumn) as MOnthGroup from table

    Use simple report to display the result and add a group that have the MOnthGroup column add sum in its footer to get your required result.

  • July 29, 2009 at 5:21 pm

    #1032079

    Thanks very much fpr the advice. I will try some more and see how it goes.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply