Save new graph instead of overwriting the already saved ones

[#1]

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.

[#2]

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

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

[#3]

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?

[#4 · Accepted solution]

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