Hello people,
'm new to crystal reports.... i have CR 2008 installed ....
my objective s to read CSV file and sum a column (which is amount field btw), but i want to sum only on certain conditions
example: if customer_id > 20 and <2000 then sum(amount)
my report is designed to display a label with text and total amount
ex: North Side Sales (Label) : <Total Amount Value>
Though 'm able to pull the records on the report an ddisplay the values record by record, i could not find any syntax in crystal to read a file and do above operation?
any help s highly appreciated....
thank you in advance