Crystal Reports Help Needed

[toyo rob]

Does anyoe on here know/use Crystal Reports.

 

if so please help;

 

i have a field that contains price data for different dates, ie date 01/11/07 = 3.00, 20/11/07 = 3.50, all linked to the same product code. i need to grab the correct price for the date i run the report which may be historical. now the formula i have is;

if Next ({price.p-code}) {price.p-code}

then {price.nett-invoice}

which i wasn't sure about but seems to work. BUT what i get is 3 or 4 lines, depending on the number of records(price changes) per code 90% of which are 0.00 but one contains the correct price.

now i have tried to use the Suppress function to get rid of the 0.00 values, which works and looks fine UNTIL i try to summarize the field and end up with a massive total.

 

hope someone can help cause this is killing me,

i only learnt how to use this last week after a 1 day course

 

Rob