topic Re: How to sane a tabulate report to HTML in Discussions

How to save a tabulate report to HTML

DZ_932 — Fri, 09 Jun 2023 23:27:16 GMT

Hi All - thank you in advance for your help

I am trying to save a finished tabulate report as a HTML file but it is not being saved.

I am using the below script:

dt1 = Open( "C:\***path***\Thermal_Test_results_DZ.csv" );

dt2 = dt1 << Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Statistics( N ) ),
		Column Table( Grouping Columns( :BIN ) ),
		Column Table( Grouping Columns( :BIN ), Statistics( Name( "% of Total" ) ) ),
		Row Table( Grouping Columns( :PRODUCT ) )
	)
);

rdt2 = (dt2 << report);
rdt2 << save HTML( "C:\***path****\TJRise_BIN_Summary.html" );

what am I doing wrong ?

Re: How to sane a tabulate report to HTML

txnelson — Sun, 03 May 2020 20:32:23 GMT

You have a syntax error with the :Name() function....you are missing the ":" at the beginning of the function name

Re: How to sane a tabulate report to HTML

DZ_932 — Sun, 03 May 2020 20:52:16 GMT

Hi,

Thank you for the replay, the tabulate actually works the issue is just saving the file as HTML, not sure that there is a name function it is just calling for the desired statistic.

Re: How to sane a tabulate report to HTML

txnelson — Sun, 03 May 2020 21:16:36 GMT

Sorry for the mislead.

I have been able to create an HTML file with the below version of you code. I had to eliminate an errant "(", but then the code worked file. The other issue may be that you do not have permission to write to the folder you are pointing too. Also, I tested under JMP 15.1. What version are you using.

Re: How to sane a tabulate report to HTML

DZ_932 — Mon, 04 May 2020 17:25:49 GMT

I am using JMP12 and still can't save as HTML, regarding the path I am able to save to this location a different chart so it is not a permission issue.