Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Crosstab calculation queston

rbuserrbuser
edited February 2004 in End User
Hi!

Is there any way to implement any kind of aditional calculation in crosstab.
Like:

Name Type Product1 Product2
Product3
Subsidary1 Sold 100 150
200
Returned 10 5
15
PerctBad 10,00 3,00
7,50
Subsidary2 Sold 100 150
200
Returned 20 10
5
PerctBad 20,00 6,00
2,50
....

Where Sold and returned are values from database and PercBad is that
aditional calculated value as : (Returned/Sold*100)

Regards,

Benjamin

Comments

  • rbuserrbuser
    edited February 2004
    Sorry for reformatting ... but
    Name Type Product1 Product2 Product3
    make one row which is here somehow messed...
    ;-)

  • nardmoseleynardmoseley
    edited February 2004

    Sorry, but there is no way to do this inside the Crosstab component. Perhaps
    create a summary query that can perform the calculation there.


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.