topic Re: Save new graph instead of overwriting the already saved ones in Discussions

Save new graph instead of overwriting the already saved ones

PG — Thu, 29 Mar 2018 08:32:53 GMT

Hello,

I am working with a huge database like below.

Manufacturer: Product: Model: Quantity

A: X:G1: 1000

B: S:F2: 5000

C: Y:N5: 2500

A: R:G5: 6000

and so on..

Now, at the beginning of my query I am filtering the Manufacturer. With the remaining columns, I am doing some calculations and plot some graphs and then save them as an image file. For ex.

pc = graph builder(...);

report(pc) << save picture("D:\Graph.jpg");

I have 2 questions related to modification of this script

1. Every time I run the script, the previous saved graph Graph.jpg is being overwritten. Is it possible to save a new graph keeping the old ones intact?

2. Since I am filtering the Manufacturer at the beginning, is it possible to save the graph automatically with a title depending on the chosen manufacturer and today's date, for ex. A_29032018.jpg?

Thanks in advance.

Re: Save new graph instead of overwriting the already saved ones

txnelson — Thu, 29 Mar 2018 10:23:05 GMT

The following change should allow you to save the graphs as you said:

report(pc) << save picture("D:\A_" || format(today(),"mmddyyyy",8) || ".jpg");

Re: Save new graph instead of overwriting the already saved ones

PG — Thu, 29 Mar 2018 11:10:43 GMT

Hello Jim,

Thanks for your reply.

report(pc) << save picture("D:\A_" || format(today(),"mmddyyyy",8) || ".jpg");

If I re-run the query and filter Manufacturer C this time, I have to manually change the script to

report(pc) << save picture("D:\C_" || format(today(),"mmddyyyy",8) || ".jpg");

Is it possible somehow that I can tell the program to find which Manufacturer I have filtered at the beginning and change the name of the file automatically?

Re: Save new graph instead of overwriting the already saved ones

txnelson — Thu, 29 Mar 2018 12:50:16 GMT

assumming that your data table variable that contains the manufacturer is called Manufacture, and that every row in the data table contains the "A" or "B" etc. then you can use the following

report(pc) << save picture("D:\" || :Manufacturer[1] || _" || format(today(),"mmddyyyy",8) || ".jpg");

I strongly encourage you to read the Scripting Guide to provide you with the structures and syntax of JSL. It is available at:

Help==Books==>Scripting Guide