Post reply

report builder report

  • December 3, 2014 at 9:19 am

    #292588

    I have a table with columns like

    start of week work hours

    1/5/2014 4

    1/12/2014 5

    1/19/2014 3

    ....

    12/21/2014 1

    there are 52 rows for 52 weeks.

    In report builder, I want to group these rows monthly and have the data appear like below

    Jan 2014 Feb 2014 March.... Dec

    week work hours week work hours

    1/5/2014 4 2/2/2014 3

    1/12/2014 5 2/9/2014 2

    1/19/2014 3 2/16/2014 4

    1/26/2014 1 2/23/2014 6

    How to accomplish this result? Thanks in advance.

  • December 3, 2014 at 4:30 pm

    #1762535

    The really short answer is to use a tablix with two columns (StartOfWeek, WorkHours) inside of a matrix with a ColumnGroup on MonthNumber.

    Which means you need to add a calculated column to your matrix (Mine is called "MonthNo" and the value is =MONTH(Fields!StartOfWeek.Value).

    Since I basically described this whole thing backwards, here's a simple report showing this thing working. (Well, I only have a few months of data, but it should give you the idea.)

    Oh, one thing I neglected to mention... I don't know how to do this in Report Builder, because I never use it. I always use Visual Studio/whatever BIDS turned into.

  • December 4, 2014 at 3:27 pm

    #1762837

    Thanks so much for the detailed reply and the file! This is going to be of great help!! I shall play around with my data and let you know.

    Thanks for your time..

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

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