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

[yasirimran79]

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.

[Xium]

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

[yasirimran79]

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).

[VBFnewcomer]

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.

[Hack]

Moved

[Xium]

cant u come at msn ?

[yasirimran79]

Bro where is Reporting Forum? tell me the website plz

[VBFnewcomer]

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.

[VBFnewcomer]

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.