nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Inserting reports

Jess

Hi,

I was wondering if it is possible to insert a Word or Powerpoint document into a JMP file? Appreciate any advice.

Best regards,

Jess

Accepted answers

All comments

txnelson

Some questions.....

"into a JMP file"......a JMP Data Table? The display output from a JMP Platform(i.e. Fit by Y, Distribution, etc.). Into a JMP Journal? Into a JMP Project?

What do you mean by "Insert". You want the PowerPoint slides or Word Document to be showing in the JMP file? Or do you want to have a field that you can link to those documents?

Jess

It would be helpful to link (or imbed) reports to data table. The reports may be in the format of powerpoint, word or pdf.

andersonmj2

You can insert all sorts of files and file types into a JMP Project - I use that all the time, and it keeps things organized and launches files in their respective apps.

However, there isn't a utility to insert an arbitrary file into a cell and have JMP pass to the OS to launch the host program, although the 'event handler' function might get at least somewhat close (i.e. you could insert the file address into the cell).

txnelson

I will push back a little against @andersonmj2's response. I believe that you can construct a script within the Column Property, Event Handler that can open up Word or PPT files. Now, since JMP is column based, as apposed to Excel, which is cell based, there has to be an identifier in the value of the cell that can allow the Event Handler script to decern which Word or PPT to open.

Additionally, there is the ability to add as many scripts as desired into the data table in general, which can open virtually any type of file, or run programs. These are data table based, not column or cell based, so you have the ability to have either table wide, or column/cell based links.

Peter_Bartell

To pile on to @andersonmj2's reply, in JMP 14, JMP Projects has been completely redesigned from prior versions of JMP...so if you are someone NOT running JMP 14...this new JMP Projects deployment should be very exciting. I (truth be told as a JMP systems engineer) demonstrate this capability to many existing as well as prospective JMP users...and they break into big smiles with the JMP 14 version of Projects.

Here's a link to a Mastering JMP On Demand webinar hosted by my colleague Chris Kirchberg:

https://www.jmp.com/en_us/events/ondemand/mastering-jmp/organizing-work-using-projects.html

gzmorgan0

If you have JMP 14, here is an example JMP Table, that uses the new column property

Event Handler({thisTable, thisColumn, thisRow), script )

The attached data table has two columns, both have a an event handler column property. This is an application of what Jim was suggesting.

fileLinks.jmp

andersonmj2

Thanks - that is exactly what I was thinking, appreciate you putting something together to demonstrate! This is actually very useful and I have been planning to start pushing people to use when it makes sense.

Jess

Hi,

This is very nice. I didn't know about Event Handler. Thank you for your reply.

I am still struggling on how to enter the files into the columns. Any suggestions?