Help me for Weight Conversion in Crystal Reports (8)…

Hello All friends

I have a problem in Crystal Reports.

I have a table of with fields Item, Kg, Grams and data like:

Item | Kg | Grams
--------------------------
A | 5 | 250
A | 1 | 500
A | 1 | 350
A | 2 | 400

Now when I make the report in Crystal Report 8, it sums up the data as Total KG (5+1+1+2)= 9 and Total Grams (250+500+350+400)= 1500 at the end of the report.

Problem is that if Grams are >=1000 then it must add 1 to the Total Kg and Grams = Grams-1000.

But I don’t know that how can I do this in Crystal Report. I tried to add a formula field but don’t know the correct syntax of writing formulas in Crystal Report 8.

So please help me that how can I place the correct totals at the end of the report after calculating the weights.

I will be very thankful to you all. I need it very urgent please.

for sum u can write directly from VB into text box of crystal report which is responsible of sum

Hassan Khan,

Thanks for your quick reply.

I dont know how to write in the textbox of crystal report from VB. Can you please guide me a little? (i will convert it but dont know how to pass to Crystal report).

I believe you are in wrong forum. Try Reporting forum if you are exclusively using Crystal reports and not using VB 6. By the way u can place summary field in the report then right click it ->format field->display string then click on x-2 button next to it and enter the formula.
another way would be to create a qurey in the db and load it to the report. dont worry you will get all help in the reporting forum.

Moved

cant u come at msn ?

Bro where is Reporting Forum? tell me the website plz

not much of problem just scroll down this page you will find Forum jump your forum is already selected just click GO voila you are there. Dont worry by now u are already moved by our friendly Hack.

Is there any spl reason to keep kgs & grams in seperate fields? Your problem could easily be solved if you make a double datatype field in the db and setting its decimal property to 2/3 places. I presume you are using access db. Also right click on the summary field ->format field->Number->Customize->Decimal places here set the decimal places to 1.000.