311476_en-US

liliconcom

How can I change the Page Column in a Tabulate via script

Tobj=Tabulate(
Remove Column Label( Grouping Columns( :ReportDate# ) ),
Page Column( :pagegroup( 1 ) ),
Add Table(
Column Table(
Grouping Columns( :ReportDate# ),
Analysis Columns( :Precision ),
Statistics( Mean )
),
Row Table( Grouping Columns( :Element ) )
));

 

What message can I send to Tobj to change the :Pagegroup to 2 - Page Column( :pagegroup( 2 ) )

ScriptingRe: How can I change the Page Column in a Tabulate via script

Hi,

 

Perfect, glad to hear it.

Re: How can I change the Page Column in a Tabulate via script

Hi Hadley,

Yes it works – thanks very much – In the beginning I didn’t recognize that we were talking about an index and 1 is ‘non selected’

Re: How can I change the Page Column in a Tabulate via script

Hi,

 

Probably there is an easier way to do this, but here's what I was able to come up with:

 

When you open the Control Panel for Tabulate, there is a ComboBox that allows you to select the page from the page column.  This is ComboBox(1).  One way to do what you're asking is to change the index of the ComboBox to correspond to :pagegroup(2): Report(Tobj)[ComboBox(1)]<

 

Tobj<<SHOW control="" panel=""></SHOW>

Please try this and see if it can work for you.