How to change table/report style in my JSL scripts? I know how to do it in JMP Preference settings.

[#1]

How to change table/report style in my JSL scripts? I know how to do it in JMP Preference settings: File-Preference-Style. But I need to change the preference settings within my own JSL scripts. Is it possible? For example, I like to change Shade Alternate Table Rows( 0 ) to Shade Alternate Table Rows( 1 ), how to do it in JSL?

[#2]

The answer to this is found in the Scripting Index

     Help==>Scripting Index==>Table Box

Here is the example from the entry for the message, "Set Shade Alternate Rows"

Names Default To Here( 1 );
New Window( "Mountains",
	tb = Table Box(
		String Col Box( "Mountain",
			{"K2", "Delphi", "Kilimanjaro",
			"Grand Teton"}
		),
		Number Col Box( "Elevation (meters)",
			{8611, 681, 5895, 4199}
		),
		Plot Col Box( "", {8611, 681, 5895, 4199} )
	)
);
tb << Set Shade Alternate Rows( 1 );

[#3]

It seems not working for me. Here is my script:

dt=current data table();

rpt=dt<<get as report;

rpt<< Set Shade Alternate Table Rows(1);

...

The rpt output table has nothing changed in its style.

[#4]

The "<< set shade alternate rows( 1 )" message, needs to be pointed at a specific Table Box().  In your script you could specify to change the first table box in the report output with the following:

rpt[Tablebox(1)]<< Set Shade Alternate  Rows(1);

Using this method, you can selectively choose which tables to change.

If you want all tables in the report output to be changed, you can use the Xpath fuction to find all Table Box()s and then apply the change

( rep << xpath(  "//TableBox" ) ) << Set Shade Alternate Rows( 1 );

[#5]

Both ways:

rpt[Tablebox(1)]<< Set Shade Alternate  Rows(1);

( rep << xpath(  "//TableBox" ) ) << Set Shade Alternate Rows( 1 );

don't work neither (the report output is just blank/empty). When in JMP, after the report/layout table is generated, I can just right click anywhere inside the tabl, then select which table style(s) to use. But I just don't know how to do it in JSL.

[#6 · Accepted solution]

Here is an example with the addition of the suggested line of code, that shows what I am talking about.  Does this help you at all?  If not, can you share your script so I can better see what you are doing.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
jmp_report =
New Window( "Big Class",
	Text Box( "Big Class" ),
	H List Box(
		Outline Box( "Big Class",
			rpt = dt << Get As Report
		)
	),

);
rpt[Tablebox(1)]<< Set Shade Alternate  Rows(1);

[#7 · Accepted solution]

It works perfectly! Thanks a lot!