Data table reports windows

shampton82 — Fri, 09 Jun 2023 16:56:43 GMT

Hey everyone,

Could anyone show me the way with JSL to get all the reports that are open against a data table? What I'm trying to do is be able to click a script button and minimize all the reports that are open for a selected data table.

Thanks for any ideas!

Steve

Re: Data table reports windows

txnelson — Wed, 13 Apr 2022 00:57:00 GMT

I am not aware of a direct way to do this, but the below script seems to work

Names Default To Here( 1 );
dt = Current Data Table();

windowNumbersToMinList = {};
theName = Current Data Table() << get name;

// Loop across all windows and find report windos attached to data table name
// Definition of a report window, is one that starts with the data table name and
// is followed by a "-"
i = 1;
While( Window( i ) << get window title != {},
	theWName = Window( i ) << get window title;
	If( Contains( theWName, theName ) == 1 & Substr( theWName, Length( theName ) + 2, 1 ) == "-",
		Insert Into( windowNumbersToMinList, i )
	);
	i++;
);

// Loop across found windows and minimize them
If( N Items( windowNumbersToMinList ) > 0,
	For( i = N Items( windowNumbersToMinList ), i >= 1, i--,
		Window( windowNumbersToMinList[i] ) << minimize window
	)
);

Re: Data table reports windows

shampton82 — Wed, 13 Apr 2022 03:01:41 GMT

Works perfect, thanks!

topic Data table reports windows in Discussions

Data table reports windows

Re: Data table reports windows

Re: Data table reports windows