Storing a value

[bv0719]

Hello,

CR XI - ODBC Informix Database

Here's what I'm trying to achieve.

Item ID, Previous Day Inv - Current Inv = Diff (calc) - Usage = Variance (calc)

The current inventory is queried from the Item Ledger table. The previous days inventory is not stored in the database. I want to store the "current inventory" value so that when the report is run the following day this value would be subtracted from the "new" current inventory.

The Diff amount would be the difference in th inventory from day to day and the Usage would be any orders entered for the Item not yet invoiced. The difference between these two would be a variance amount.

How do I store the current inventory value and use the value again the next time the report is run? I think it may be a matter of using a shared variable but not certain on the correct formula.

Please let me know if further information is needed.

Thanks,
Bill V

 

[IdoMillet]

Where do you want to store it? If it's a single value, you could create or purchase a UFL (User Function Library) to store the value in a text or ini file. You can see a list of such utilities at:

http://www.kenhamady.com/bookmarks.html

If these are multiple records that you need to store in a database, you can export to ODBC. Again, unless you are willing to do this manually, you may want to consider a 3rd-party tool from the list provided above.

My CUT Light UFL addresses the 1st scenario and my Visual CUT software addresses the 2nd scenario. For a 1 page pdf explanation, see:

http://www.milletsoftware.com/Download/Visual CUT ODBC Export Functionality.pdf

hth,
- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com