toyo rob
22-11-07, 20:00
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
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