topic saving multiple reports into one powerpoint in Discussions

saving multiple reports into one powerpoint

Tina442 — Wed, 26 Mar 2025 13:06:27 GMT

Hi,

I am aware we can export graphs into powerpoint but having to do this one at a time is a bit cumbersome. I have been attempting to use JSL to recognize all my open reports and export it into one single powerpoint with a for loop and the save presentation() function, but it's not working.

I think I'm having trouble figuring out the function that would recognize all my open windows/reports. Can someone please help?

Re: saving multiple reports into one powerpoint

matth1 — Wed, 26 Mar 2025 14:40:12 GMT

Something like Get Window List( Type( "Reports" ) ); might help? E.g.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dist = dt << Distribution(
	Continuous Distribution( Column( :height ), Process Capability( 0 ) ),
	Continuous Distribution( Column( :weight ), Process Capability( 0 ) )
);
fitxy = dt << Bivariate( Y( :weight ), X( :height ) );
boxp = dt << Graph Builder(
	Size( 528, 448 ),
	Show Control Panel( 0 ),
	Variables( X( :sex ), Y( :height ) ),
	Elements( Box Plot( X, Y, Legend( 4 ) ), Points( X, Y, Legend( 5 ) ) )
);

winlist = Get Window List( Type( "Reports" ) );
Wait( 0 );

For( i = 1, i <= N Items( winlist ), i++,
	pw = New Window( "output", <<Window View( "Invisible" ), winlist[i] << get picture );
	If( i == 1,
		pw << Save Presentation( "$TEMP/all_reports.pptx" ),
		pw << Save Presentation( "$TEMP/all_reports.pptx", Append )
	);
	pw << close window();
);
Open( "$TEMP/all_reports.pptx" );

This saves the exact image of the report. To get the typical output with JMP tables, replace pw with winlist[i] in the << Save Presentation lines and delete the lines with pw.

EDIT: the original code left lots of hidden windows called "Output", "Output 2"... sorry.

Re: saving multiple reports into one powerpoint

Tina442 — Wed, 26 Mar 2025 18:35:28 GMT

That's exactly it! Thanks for the solution, this works perfectly :)