Skip to Content
avatar image
Former Member

total of a grid

hello for example a want to calculate the total of 3 rows, for example:

profit loses

October 100 50

November 150 20

December 100 50

Total 350 120

how can i put the total value in a grid...i know that i can put the total label in a grid in Row Heading but then i create a XML Document but the total appears always,in this example, next loses...

Could anyone give a tip??

regards

Mário

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2009 at 03:55 PM

    Mario,

    If you are already configured this trnsaction then do like this:

    create local properties of profit and loss. Use repeater action block and configure with your data xpath:SQL.output{/Rowsets/Rowset/Row}.Use Assignment action and map the local proertes as: Local.profit+repeater{/Row/profit}

    Put a Row action below repeater and configure it with your document action block.In row map your total to these profit and loss.

    -Suresh

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2009 at 03:33 PM

    If your data is coming in an SQL query then do it there, use the UNION to merge the initial select statement results with the SUM(profit) AS Profit...

    If your data is already being constructed in a transaction then use the Row action to add your totals to the output xml document.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2009 at 10:35 PM

    thanks to all

    Add comment
    10|10000 characters needed characters exceeded