Post reply

Matrix Control

  • May 6, 2010 at 6:21 am

    #224211

    Using SSRS 2005. Have a table that has one record per date and 33 columns. Requirement is to print info as follows:

    Date Date Date Date, etc.

    field1

    field2

    field3

    field4

    field5

    etc..

    field33

    There can be x number of record. User wants the date info to spread across the page. Thinking of using the matrix control but can't seem to get it working. Any suggestions?

    Thanks.

    Michael

  • May 6, 2010 at 9:24 am

    #1163346

    I think that would be tough to do in a matrix. Also, to print you will end up with a fixed height report, but a completely variable width, making the print output difficult to control.

    If you use a table and arrange it

    Field1, 2, 3, 4, 5, etc. as your columns

    Date1

    date2

    date3

    date4

    as your rows you would end up with a report that will be easier to format for printing.

  • May 6, 2010 at 9:59 am

    #1163396

    Thanks for the info. I did think about changing the fields to be the columns and date as the rows. Need to review with the users. Just wanted to see if there was a way to do it based on their requirements.

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

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