Search results for query: *

Because I have LOTS of part numbers, my example shows this working only for one part number for simplicity. I am trying to avoid manually creating a running total and matching inventory formula for each part and looking for a more efficient way of doing this. I like your approach above and...

1) Break the string into two parts using the right and left functions. Forumula1 StringVar a = Right({yourField}, 4); Formula2 StringVar a = Left({yourField}, 4); //assuming your number is 8 chars long. 2) In design mode, put a text field into your report. Type this text...

Right (str, length) Basic and Crystal syntax. Arguments str is a text string. length is a whole number indicating the number of characters to be extracted from str. Returns String value Action Extracts the given number of text characters from the right side of the specified string. Typical...

I am writing a report that reconciles sales orders to inventory - essentially, group sales orders by the scheduled production date, list out all the parts that are needed and forecast the impact on inventory, highlighting any areas where inventory is foretasted to go negative. In my company...