topic Saving report created with several tables in Discussions

Saving report created with several tables

anne_sa — Thu, 26 Jan 2017 10:28:33 GMT

Hello everybody,

I have created a report which contains different graphs and elements built from several data tables.

I would like to find a convenient way to save it.

Here is a little example:

new window ("My report",
	hlist box(
		data table("Candy Bars")<< Distribution( Continuous Distribution( Column( :Calories ) ) );
		data table("Big Class")<<Bivariate( Y( :height ), X( :weight ) );
	)	
);

When I save it as a JMP report and then reopen it, only the dependency with the table Candy Bars remains and I only have one graph in my report.

So far the only solution I have found, is to save it using html interactive format. This enables me to keep a trace of all the information of my report.

Nevertheless I would like to know if it is possible to save it as a JMP report in order to have the possibility to keep on working with it in JMP.

Thanks in advance for your help!

Re: Saving report created with several tables

txnelson — Thu, 26 Jan 2017 12:44:37 GMT

You could opt to save your output to a JMP Journal. It will save the results just as you see them. So rather than just creating a New Window you would make the the New Window a journal

new window ("My report",
	hlist box(
		data table("Candy Bars")<< Distribution( Continuous Distribution( Column( :Calories ) ) );
		data table("Big Class")<<Bivariate( Y( :height ), X( :weight ) );
	)	
);

Addionally, since a JMP Report is actually just a .jsl file with the extension, you can create your own .jrp file within JMP and save it, with the required data tables and additional JSL required to create the report you want

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt2 = Open( "$SAMPLE_DATA/Candy Bars.jmp" );

// Create the jsl to save as a JMP Report
bcscript = Char( dt << get script ) || ";";
bcscript = bcscript || Char( dt2 << get script ) || ";";
bcscript = bcscript ||
"\[new window ("My report",
	hlist box(
		data table("Candy Bars")<< Distribution( Continuous Distribution( Column( :Calories ) ) );
		data table("Big Class")<<Bivariate( Y( :height ), X( :weight ) );
	)	
);]\";
Close( dt, nosave );
Close( dt2, nosave );
Save Text File( "$TEMP/DeleteMe.jrp", bcscript );
Wait( 0 );
Open( "$TEMP/DeleteMe.jrp" );

Re: Saving report created with several tables

anne_sa — Thu, 26 Jan 2017 14:19:53 GMT

Thank you very much Jim, the second option is exactly what I was looking for!

Your help is really appreciated!