cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

How could I acheive a column scroll lock in a table box created by dt << get as report?

Mittman
Level III

I use "<< get as report" to insert tabular content into my custom reports. Sometimes, this content is scrollable in the report. I'm curious how I might achieve a "scroll lock" behavior in the report. It isn't preserved when I do "<< lock(1)" to a column in the original table.

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User


Re: How could I acheive a column scroll lock in a table box created by dt << get as report?

Something like this might get you going:

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

new = new window("",
	rep = dt << get as report;
);
tb = rep[TableBox(1)];

tb << Set Scrollable(30, 4);
show(tb << Get Locked Columns);
tb << Set Locked Columns(2);
show(tb << Get Locked Columns);

<< get as report creates table box of datatable, get reference to that and then do modifications you want.

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User


Re: How could I acheive a column scroll lock in a table box created by dt << get as report?

Something like this might get you going:

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

new = new window("",
	rep = dt << get as report;
);
tb = rep[TableBox(1)];

tb << Set Scrollable(30, 4);
show(tb << Get Locked Columns);
tb << Set Locked Columns(2);
show(tb << Get Locked Columns);

<< get as report creates table box of datatable, get reference to that and then do modifications you want.

-Jarmo
Mittman
Level III


Re: How could I acheive a column scroll lock in a table box created by dt << get as report?

This is perfect. Thanks!