Search results for query: *

I am having difficulties with more information being pulled inot a report then I want. Prior to adding a particular field the report works great but as soon as I add a different field pointing to a different table then it pulls in more then I want it too. When I look at then links all looks fine...

Where do I go in the database to see if it a stroed procedure??? If I can't figure this part out, is there any way to get the description to come across in the report?

I am trying to convert the key name to the full name from a list. Here is the code: IF (IsNull({SHIPPING_ITEM.SHIPPING_TYPE})) THEN ListDescription ("SHIP_TYPE",{SHIPPING_ITEM.SHIPPING_TYPE}) ELSE "" The "SHIP_TYPE" is a list item and points to the full description of the key. ie key is...

Thanks for your help! I tried the code: int(sum({A_B.quantity},{table.groupfield})) & " " & {UNITS.DISPLAY_STRING} I am now able to get the correct sum with the units attached but there are still decimal places. ie. 13.00, I would like it to be 13.

Unfortunately I tried the first formula and it is behaving in the same way as before. That is, it performs a sum of the first entries in the group and then carries the same value as the sum for all the other entries. Without applying a formula to attasch the units and keep the number as a whole...

If I perform a sum on A_B.Quantity, it works great except when I try to attach a unit to it. Without the sum I can attach the units and all is well. The first formula was to remove the decimal places. Any thoughts?

Formula 1 = @CurrentEnrtyQtyDecimals Local NumberVar NumPlaces := 10; Local BooleanVar CheckPlaces := true; While CheckPlaces Do ( IF (NumPlaces > 0) AND (Val(ToText({A_B.QUANTITY}, NumPlaces, "")) - Val(ToText({A_B.QUANTITY}, NumPlaces - 1, "")) = 0) THEN (NumPlaces :=...

HI, I am having difficulty when trying perform a summation on a field in the group footer that has formulas attached. Here is the specifics, There are 2 formulas. 1. Changes the decimal places of the current quantity 2. Attaches a unit value to the curretn quantity ( the 2nd formula points to...