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

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

DunnRankBudgie8 — Tue, 23 Sep 2025 02:28:49 GMT

When 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)

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

hogi — Tue, 23 Sep 2025 03:53:42 GMT

can you use Tabulate in your report?

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

jthi — Mon, 29 Sep 2025 08:50:03 GMT

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.