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.
Re: Help me for Weight Conversion in Crystal Reports (8)…
I would create 2 formulas; 1 for the grams and 1 for the kgs. Do your normal ttals, but make them invisible (suppressed). You rformauls for the grams would be
if {your subtotal of grams} >= 1000 then
{subtotal of grams} - 1000
your formula for the Kgs would be
if {your subtotal of grams} >= 1000 then
{subtotal of kgs} + 1
Use the formulas as your totals.
I think this should give you the direction, if the syntax is not entirely correct.
Re: Help me for Weight Conversion in Crystal Reports (8)…
You take grand total of two fields in for example group footer section. In group fotter u make two forumlas and dont display that total field and then give ur logic of greater then thouse so subtract one or so.
You can ge the result easily.