How to save data for history?

[#1]

Hi

I developed a report that gives me a stock on hand figure for my company. The problem with this report is that it is a running total.

Everytime I reload the file I get the new figures but I cannot view history. How would you suggest I write my report in order to see

a trendline & history of stock levels.

Has it something to do with the write of QVD files?

Regards

Christo

[#2]

Hi,

Why dont you store the SOH in an qvd file in a certain intervall and reloads these, then you got SOH over time.

br

/D

[#3]

I thought that this might be the solution.

But how do I write an objects data to a qvd file?

[tabletuner]

why dont you use the store command? e.g.

LET vTimestamp = now();

SOH:

LOAD

Date,

ARTICLE,

Amount

FROM Source;

STORE * FROM SOH INTO $(vTimestamp)_SOH.qvd;

[#5 · Accepted solution]

first create an variable vToday that tou can use in the file name Then use below code in the script(if SOH is your tablename):

store SOH into SOH_$(vToday),qvd;

/D