archiving

[raadwiptec]

Hi all,

I would want to have a chart archived to a QVD based on a specific dates automated?

[asgardd2]

Please explain more detail what you want. You can export table in qvd only then reload script  is performing.

[tresesco]

Tabular charts can be stored into a qvd. And that would only store the data and not the chart layout.

....based on a specific dates automated?

Could you explain your requirement, may be with an example?

[raadwiptec]

its a straight table.. Chart layout is not required. Using the archiving macro iam able to do it..

Dates means for example in the chart - we have column called end date.. so while archiving it to the Qvd ..I need to consider the end date should be the last date of the month. it should be a monthly archive basically

[tresesco]

So you want help in macro. Could you share the one you are working with?

[raadwiptec]

no is their any other I can achieve this other  than macro?

[tresesco]

I guess automation - would be a chanllenge (if not impossible wihout macro or something such external).

[raadwiptec]

using the macro how to automate?

[jonathandienst]

Can you do this during the reload? The script can calculate the dates required and output the qvd as part of the reload process.

[Anonymous]

In the load script could you create resident table using a suitable where clause and columns and then store this to a qvd ?