Post reply

Using Matrix in SQL Reports

  • June 7, 2007 at 2:46 am

    #176982

    Hi there,

     

    I'm trying to use a matrix to create a cross tab report with the following format.

    Location           Carrier                           Period Total   Total YTD    

                          C1           C2        C3           

    Bangkok           1             2          3              6                 5

    CLT                 1            1           1              3                 5

                                                   Total         9                  10

    I'm having trouble adding the total ytd to the matrix and the totals below

    Could anyone help please? thanks,

    Elias

  • June 7, 2007 at 9:52 am

    #711452

    It's probably not the answer you were hoping for, but we ended up having to handle the aggregate columns in the stored proc behind the dataset when we wanted multiple aggregates in a matrix. That will require a familiarity with dynamic SQL.

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

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