Post reply

Matrix Report issue

  • February 15, 2007 at 11:48 am

    #172128

    Hello,

    I developed a report using the new matrix control. In the report I have 2

    rowsgroups(monthname of the orderdate as parent,the orderdate as the 2nd one)

    and 1 columngroup(year of the orderdate). In the details field i have 4

    column fields Ordercount,Order valuee in $'s, Shipped value in $'s,Total

    Shipped value in $'s.

    In my dataset i have restricted it for 2 years 2006 and 2007. the report

    runs as desired breaking the month datewise and showing the values of each

    date for the 2 years side by side.

    The problem however is that i need to add a new column at the end,i.e.,

    after the value for 2006 has been rendered.

    In this column i need to find out the difference between the ordercount in

    2007 as compared to 2006 for each date monthwise.

    Can any one please tell me how can i access the ordercount values for a

    particular date for the 2 year values and put the difference in the new

    column at the end. Please look at the image below.....i am looking to get the difference of the 2 order counts in the 2nd last colum in the report

    thanks

  • February 19, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • May 3, 2007 at 9:31 pm

    #704274

    Hi  abhi,

    I have exactly the same issue though with different data and so far have not found a solution. I am using SRS 2000 and the matrix provides the layout needed, so I am loath to try and achieve the same with a table. I would be delighted to hear from anyone that has a solution, part of a solution OR knows that it cannot be done.

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

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