topic Re: How to add a data table to web report? in Discussions

How to add a data table to web report?

AT — Tue, 17 Jul 2018 15:56:17 GMT

I used the following example of create a project:

project = New Project();
project << Run Script(
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Run Script( "Bivariate" );
dt << Run Script( "Distribution" );
);

Now when I use publish, I get the web report with Distribution and Bivariate plot. How do I add data table as well? Thanks for your help.

Re: How to add a data table to web report?

Peter_Bartell — Tue, 17 Jul 2018 11:32:19 GMT

Unless I'm confused your script is calling for creating a new JMP project while your narrative text says you want a web report. Web reports and JMP projects are separate and distinct capabilities. If you truly want a JMP project the data table will follow along with the report elements and other project elements you may want to include like Excel files, PowerPoint presentations, etc. In JMP 14 it's super easy...create all your project elements, then from any JMP main menu bar, select Window -> Move to Project. The project will populate and now you can save it as it's own distinct project. Different workflow for a JMP Web Report.

Re: How to add a data table to web report?

AT — Tue, 17 Jul 2018 16:07:38 GMT

Thanks for the comments. My goal is to get a web report from saved projects. I notice that the data table is not listed in web report.

I use publish right after I created the project. Can I add the data table in web report? Thanks

Re: How to add a data table to web report?

Jeff_Perkinson — Tue, 17 Jul 2018 16:19:31 GMT

Try creating a New Window() and journaling the data table to it.

project = New Project();
project << Run Script(
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Run Script( "Bivariate" );
dt << Run Script( "Distribution" );
new window("my report", dt<<journal);
);

Re: How to add a data table to web report?

AT — Tue, 17 Jul 2018 17:07:03 GMT

Thanks Jeff. It works except that the data table is truncated. Is there a way to avoid the truncation when it is published?

Thanks for your help.

Re: How to add a data table to web report?

Jeff_Perkinson — Wed, 18 Jul 2018 14:49:03 GMT

I don't think it's truncated. It just needs to be scrolled to see all of it.

Re: How to add a data table to web report?

AT — Wed, 18 Jul 2018 16:44:46 GMT

Thanks Jeff. The rows can be scrolled but columns are truncated to just few. I have 127 columns. Is there a limit in number of columns?

Re: How to add a data table to web report?

Jeff_Perkinson — Wed, 18 Jul 2018 16:52:07 GMT

It will journal only the selected columns. Make sure you clear the column selection before the Journal command.

Re: How to add a data table to web report?

AT — Wed, 18 Jul 2018 22:22:42 GMT

Thanks Jeff. I cleared the column and when I publish it, I get an HTML and when I try to open the data table, it keeps asking whether I want to wait or continue. I have 127 columns and previously, with 5 columns were Ok. Any suggestions? Thanks

Re: How to add a data table to web report?

Jeff_Perkinson — Fri, 20 Jul 2018 22:19:14 GMT

All of the data are encoded in the HTML file and then have to be rendered with javascript. How many rows do you have? It sounds like it might be a bunch. We're working to make this faster in future releases but with a bunch of data it will take some time to render.

Re: How to add a data table to web report?

AT — Fri, 27 Jul 2018 17:19:31 GMT

Hi Jeff,

Thanks for the note. The number of rows are about 4000. I was able to create a dashboard and no issue with number of rows. Only when you want to create report out of projects you run into trouble. Thanks for all your help.

Re: How to add a data table to web report?

anne_sa — Thu, 02 Apr 2020 09:58:14 GMT

Hello,

I also would like to add a data table in a web report but some of the cells are colored. Unfortunately, when I publish the journal of the table, the colors are lost. Is there a way do keep the table not truncated and with the colors?

Thanks for your help!

Re: How to add a data table to web report?

txnelson — Thu, 02 Apr 2020 10:33:16 GMT

I have been successful in doing this by creating a picture object of the data table, rather than the actual data table

Re: How to add a data table to web report?

anne_sa — Thu, 02 Apr 2020 11:38:17 GMT

It works like a charm! Thank you very much @txnelson