902803_en-US

liliconcom

JSL implementation of merged cell display format similar to the tabulation function. JMP17When generating reports using JSL, I want to place a table in a new window that resembles the style displayed by the 【Tabulate】 function (where cells with the same column values can be merged). The data for the report comes from a JMP table.

【My Challenges】
JMP17
1. When I use a new window and add a table box, each row displays data, but cells with the same category are not merged. Is there a method in JSL to achieve a display similar to merging cells in Excel?
2. Additionally, is it possible to customize the dividing lines of the table? (Where the dividing lines appear and their format)Automation and ScriptingRe: JSL implementation of merged cell display format similar to the tabulation function. JMP17

can you use Tabulate in your report?

Re: JSL implementation of merged cell display format similar to the tabulation function. JMP17

You cannot (easily) do cell merging in table box. Like hogi did already ask, could you just use the tabulate in your new window/report? 

Most of the things you can do with table box, can be found from Scripting Index

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Car Poll.jmp");

nw = New Window("",
	H List Box(
		Distribution(Continuous Distribution(Column(:age))),
		tab = dt << Tabulate(
			Show Control Panel(0),
			Add Table(
				Column Table(Grouping Columns(:sex, :marital status)),
				Row Table(Grouping Columns(:country, :size))
			)
		)		
	)
);

Scripting Guide > Display Trees > Construct Custom Windows > Examples of Creating a Dashboard from Two Reports 

 

There are also some options outside of table box (such as using lineup box) but those generally do require more scripting.