hey guys

sorry if this has already been answered but i couldn't see after going through

im a self taught nub using crystal reports 2009.

i want to sum up a field when a separate field is only one value and then restrict it by customer group.

i understand restricting a sum to an input in a field by doing the format of below..

SUM ({@Activity}, {VW_CUST_ORDER.NAME})

but i want to basically add another restriction

where {VW_CUST_ORDER.DESCRIPTION} = "GA67 GALLIUM CITRATE"

end result is i get an output that is the sum of {@Activity} but only for product "GA67 GALLIUM CITRATE" and its all grouped per customer.

any ideas?

thanks in advance

thanks for the reply DBlank

@Activity represents how much Activity a customer orders. this is related to nuclear medicine but the software we use outputs in a non standard unit as its old. so @Activity just converts a number.

i shall google Running totals and evalutaion formulas and see what i get.


FYI i did get it to work with the section expert record by only including values of {VW_CUST_ORDER.DESCRIPTION} field equal to "GA67 GALLIUM CITRATE". this is in a group header as the report is set up as a summary and im not using the details section at all. because its in a GH it seems to funk up the rest of the report i guess? i did not look too deeply into but it drops in pages from 110 to 60 odd when i do this.

thanks for that piece of info DBlank.

in the end i caved on doing it the way i wanted. i just made it a running total with a selection criteria of {VW_CUST_ORDER.DESCRIPTION} = "GA67 GALLIUM CITRATE" and moved the output to the footer.

apparently you can set global variables to make the output appear in a header but that got me fairly lost.