Crystal Reports Label Printing

[pgreen50]

I am printing some small labels that show the product code, short description and the price. My problem is that the price is NET. I want it to show the price including VAT. Is this possible and if so how do i go about doing it. Is it just a case that i am using the wrong price field in the report or do i need to create a formula to add the vat to the net price.

Thanks

Phil

[Kiran]

Hi Phil

Please upload a copy of the report file and give me the link, so I can take a look at it.

[pgreen50]

I should have mentioned that i am using crystal reports and using the ODBC link to import the data.

I have found a way around it now by using Excel, but would have liked to have used crystal reports to do this, but i was in a bit of a hurry to get this done. Obviously you have to use some kind of formula within crystal to:

A: give the gross figure and B: show the result with the decimal point in place.

Many thanks for your time.

Phil

[Jan]

Is it just a case that i am using the wrong price field in the report or do i need to create a formula to add the vat to the net price

Prices are stored in pennies excluding VAT, so you will have to calculate the price including VAT

({Product.Price} / 100) * 117.5

and then either cheat, and divide it by 100 again to get the pounds and pence, put it onto the report, right click and use the format option to set the display format OR you could do it properly and copy one of the price formulas from an Actinic report and change the field to the one you need.

I hope that isn't too confusing.

Regards,

Jan