<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Adding Tabulate Table into journal in Discussions</title>
    <link>https://community.jmp.com/t5/Discussions/Adding-Tabulate-Table-into-journal/m-p/325577#M57489</link>
    <description>&lt;P&gt;I try to add a tabulate table into my journal for reporting. But i been stuck in JSL with error and the tabulate table is not able to add into journal. Please advise what am i missing?&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;CODE class=" language-jsl"&gt;Names Default To Here( 1 );
Clear Symbols();
Clear Log();
Close All( Data Tables, NoSave );
Close All( Journals, NoSave );

//Journal
nw = New Window( "Reports",
	&amp;lt;&amp;lt;Journal,
	hlb = H List Box(
		lub = Lineup Box( N Col( 1 ) )
	)
);

lub &amp;lt;&amp;lt; Append ( sb = Spacer Box( size (10, 500), color ("White") ) );
lub &amp;lt;&amp;lt; Append( tb = Text Box( "VENUS SMIC CYCLING REPORT " || Short Date( Today() ) ));
tb &amp;lt;&amp;lt; Set Font Size( 20 ) &amp;lt;&amp;lt; Set Font Style( "Bold" ) &amp;lt;&amp;lt; Justify Text( "Center" );
tb &amp;lt;&amp;lt; set width(1500) &amp;lt;&amp;lt; set wrap((1500));
lub &amp;lt;&amp;lt; Append( Page Break Box() );


//*************************************
dt_source = Open( "TEST.jmp" );

dt_source:hardbin &amp;lt;&amp;lt; Data Type( Character );

dt_source &amp;lt;&amp;lt; New Column( "FFT", "Character", "Norminal", 
	Formula(
		If( :hardbin == 1,
			"Pass;1",
			Char( :Name( "failtest_name,0,0" ) || ";" || Char( :Name( "failtest_number,0,0" ) ) )
		)
	)	
);


obj_table = dt_source &amp;lt;&amp;lt; Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Grouping Columns( :Wafer ) ),
		Row Table(
			Grouping Columns( :hardbin, :BinName, :FFT ),
			Statistics( Name( "% of Total" ) )
		)
	)
);

lub &amp;lt;&amp;lt; Append( obj_table );&amp;nbsp;//&amp;nbsp;where&amp;nbsp;i&amp;nbsp;got&amp;nbsp;the&amp;nbsp;error&lt;/CODE&gt;&lt;/PRE&gt;</description>
    <pubDate>Sat, 10 Jun 2023 23:21:09 GMT</pubDate>
    <dc:creator>OneNorthJMP</dc:creator>
    <dc:date>2023-06-10T23:21:09Z</dc:date>
    <item>
      <title>Adding Tabulate Table into journal</title>
      <link>https://community.jmp.com/t5/Discussions/Adding-Tabulate-Table-into-journal/m-p/325577#M57489</link>
      <description>&lt;P&gt;I try to add a tabulate table into my journal for reporting. But i been stuck in JSL with error and the tabulate table is not able to add into journal. Please advise what am i missing?&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;CODE class=" language-jsl"&gt;Names Default To Here( 1 );
Clear Symbols();
Clear Log();
Close All( Data Tables, NoSave );
Close All( Journals, NoSave );

//Journal
nw = New Window( "Reports",
	&amp;lt;&amp;lt;Journal,
	hlb = H List Box(
		lub = Lineup Box( N Col( 1 ) )
	)
);

lub &amp;lt;&amp;lt; Append ( sb = Spacer Box( size (10, 500), color ("White") ) );
lub &amp;lt;&amp;lt; Append( tb = Text Box( "VENUS SMIC CYCLING REPORT " || Short Date( Today() ) ));
tb &amp;lt;&amp;lt; Set Font Size( 20 ) &amp;lt;&amp;lt; Set Font Style( "Bold" ) &amp;lt;&amp;lt; Justify Text( "Center" );
tb &amp;lt;&amp;lt; set width(1500) &amp;lt;&amp;lt; set wrap((1500));
lub &amp;lt;&amp;lt; Append( Page Break Box() );


//*************************************
dt_source = Open( "TEST.jmp" );

dt_source:hardbin &amp;lt;&amp;lt; Data Type( Character );

dt_source &amp;lt;&amp;lt; New Column( "FFT", "Character", "Norminal", 
	Formula(
		If( :hardbin == 1,
			"Pass;1",
			Char( :Name( "failtest_name,0,0" ) || ";" || Char( :Name( "failtest_number,0,0" ) ) )
		)
	)	
);


obj_table = dt_source &amp;lt;&amp;lt; Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Grouping Columns( :Wafer ) ),
		Row Table(
			Grouping Columns( :hardbin, :BinName, :FFT ),
			Statistics( Name( "% of Total" ) )
		)
	)
);

lub &amp;lt;&amp;lt; Append( obj_table );&amp;nbsp;//&amp;nbsp;where&amp;nbsp;i&amp;nbsp;got&amp;nbsp;the&amp;nbsp;error&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Sat, 10 Jun 2023 23:21:09 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Adding-Tabulate-Table-into-journal/m-p/325577#M57489</guid>
      <dc:creator>OneNorthJMP</dc:creator>
      <dc:date>2023-06-10T23:21:09Z</dc:date>
    </item>
    <item>
      <title>Re: Adding Tabulate Table into journal</title>
      <link>https://community.jmp.com/t5/Discussions/Adding-Tabulate-Table-into-journal/m-p/325634#M57492</link>
      <description>&lt;P&gt;You need to reference the report object from the Tabulate&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-jsl"&gt;lub &amp;lt;&amp;lt; Append( Report( obj_table ) );&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Fri, 23 Oct 2020 03:14:57 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Adding-Tabulate-Table-into-journal/m-p/325634#M57492</guid>
      <dc:creator>txnelson</dc:creator>
      <dc:date>2020-10-23T03:14:57Z</dc:date>
    </item>
    <item>
      <title>Re: Adding Tabulate Table into journal</title>
      <link>https://community.jmp.com/t5/Discussions/Adding-Tabulate-Table-into-journal/m-p/325635#M57493</link>
      <description>Thanks Nelson. It work</description>
      <pubDate>Fri, 23 Oct 2020 03:24:26 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Adding-Tabulate-Table-into-journal/m-p/325635#M57493</guid>
      <dc:creator>OneNorthJMP</dc:creator>
      <dc:date>2020-10-23T03:24:26Z</dc:date>
    </item>
  </channel>
</rss>

