Prevent Objects From Displaying When Running Scripts

Question

I'm trying to automate my JMP chart creation. I'm creating an application.As the script runs it displays the output of the query and the report. It then saves the report as an HTML document. The full script has 4 different queries and reports. Is there a way to run the script where it doesn't display anything? I plan on having the application show a pop-up saying the report is running, but don't want the actual artifacts displaying. Attached is a sample script. planetQ = New SQL Query( Connection( "CONNECTION INFO HERE" ), QueryName( "ON_TIME_SPC_PLANET" ), Select( Column( "ReleaseMonth", "t1", Numeric Format( "m/d/y", "-1", "NO", "" ) ), Column( "PLANET", "t1" ), Column( "On-Time", "t1", Alias( "Sum-On-Time" ), SavedJMPName( "On-Time" ), Aggregation( "Sum" ), JMP Name( "Sum-On-Time", 0 ) ), Column( "Total", "t1", Alias( "Sum-Total" ), SavedJMPName( "Total" ), Aggregation( "Sum" ), JMP Name( "Sum-Total", 0 ) ), Column( "Phase", "t1", Analysis Type( "Nominal" ) ) ), From( Table( "ON_TIME_SPC", Schema( "dbo" ), Alias( "t1" ) ) ), Group By( Column( "ReleaseMonth", "t1", Numeric Format( "m/d/y", "-1", "NO", "" ) ), Column( "PLANET", "t1" ), Column( "Phase", "t1" ) ), Order By( Column( "ReleaseMonth", "t1", Numeric Format( "m/d/y", "-1", "NO", "" ), Order( "Ascending" ) ) ) ) << Run Foreground(); planetQ << New Column( "OnTimePct", Formula( :Name( "Sum-On-Time" ) / :Name( "Sum-Total" )) ); wait(1.0); current data table(planetQ); planetP = Control Chart( Sample Label( :ReleaseMonth ), Phase( :Phase ), Sample Size( :Name( "Sum-Total" ) ), KSigma( 3 ), Chart Col( :OnTimePct, P( Phase Level( "1" ), Phase Level( "2" ) ) ), By( :PLANET ) );

txnelson · Accepted Answer

You should be able to specify to run your query in "Background".  Look in the Scripting Index under SQL Query for "Run Background".  And as for the Control Chart, you can always specify the "Invisible" option.

txnelson · Accepted Answer

ppnP = Control Chart(invisible,
Sample Label( :ReleaseMonth ),
Phase( :Phase ),
Sample Size( :Name( "Sum-Total" ) ),
KSigma( 3 ),
Chart Col( :OnTimePct, P( Phase Level( "1" ), Phase Level( "2" ) ) ),
By( :name )
);

Jeff_Perkinson · Accepted Answer

The Scripting Guide has a section on how to Make Platforms Invisible.