JMP Cinical- Create New Report for Custom Domains

[#1]

Hello everybody,

When using JMP Clinical, we use most of the time the reports already included in JMP Clinical. There are plenty of choice and you can do most of your analysis with those reports.

But, in some cases, you need to develop new reports for differents reasons: 

- Custom domains: some domains are not planned in JMP Clinical. Then, you need to include a new report in JMP Clinical in order to do the requested analysis

- Specific analysis: developping specific analysis/report because this is not included in the current reports.

My question is the following: Do you know if it is possible to develop specific report (with JSL I guess)? If yes, is it possible to include them directly in the list of the JMP Clinical reports so they can be used by different users?

Thank you for your help.

[#2]

Hi @Maud_He,

Thanks for posting in the JMP Clinical European Users Group. 

1. JMP Clinical can read custom domains and display a report based on the type of domain it is. For example, CDSIC standards (specifically SDTM) allow for custom domains and can be defined as findings, interventions, or events.  If the structure of one of theses classes is followed, JMP Clinical will read it and any of the Event, Finding, or Intervention based report can be used.
2. For creating custom or modififying exisiting reports, it is possible. There needs to be a .XML file that translates into an Options dialog like the other reports which passess along the selections to the code that the associated .sas file will use. There is another .jsl file that needs to be modified so that the custom report wil show up in the report list and be able to be saved to the review.

We do not have example documentaiton of how to do this, but maybe this is a good place to start to get this process going.

I will try to follow up with this post soon with some more details as to the files that are needed and what needs to be modified.

Best,

[#3]

Hi Chris,

thank you for you quick answer.

Indeed, it will be interesting to have more details about the files to modify :)

Best regards,

Maud

[#4]

Hi @Maud_He ,

Lets take the Adverse Event Distribution report as an example. Here are the folders that contain the files for the reports in JMP Clinical 7 (JMP Clinical 6 will be similar):

Within C:\Program Files\SASHome\JMPClinical\14\Clinical\ProcessLibrary\, there are two files called :

AEDistribution.sas
AEDistribution.xml

The .sas file contains the code that is run and the .xml file contians the options and layout of the options with the Options section of the Adverse Event Distribution report. The selections within the Options panel are passed along to the code in the .sas file (variables must be declaired within the .sas code that are coming from the .xml file). The .sas file also contains the mechansim to create JSL code for the filtering, plots and tables for the report.

To get the report to show up in the list of reports in the Report Selection window, you will need to modify this file: ReportDefinitions.jsl. It is located within C:\Program Files\SASHome\JMPClinical\14\LifeSciences\JSLFiles\com\jmp\review\.

Look for AEDistribution within the .jsl file. It wil given an example of the kind of code/information that needs to be entered for the new report. Example for  Adverse Event Distribution is:

ReportDefinitions:allReportsListMap["AEDistribution"] = [1 => "Events",
2 => "Distribution",
"label" => "Adverse Events Distribution",
"name" => "AEDistribution",
"file" => "/user/clinical/processlibrary/AEDistribution.jsl",
"icon" => "/install/lifesciences/documentation/icons/clinical/RelatedAE.gif"];

and further down in another section

ReportDefinitions:reportListMap["AEDistribution"] = ReportDefinitions:allReportsListMap["AEDistribution"];

with another line in a third section below that looks like

ReportDefinitions:drilldownListMap["AEDistribution"] = ReportDefinitions:allReportsListMap["AEDistribution"];

There is another file that defines the help URL if you would like to change that as well but that would require the documentation to be downloaded to a local location (and moved to a shared location, in JMP Clinical 7, one can configure what the default URL or file path is for the help files) so one can insert their own .html file for the description/help for that particular report. Here is the path and file that would need to be modified

C:\Program Files\SASHome\JMPClinical\14\LifeSciences\APMetaData.jmp

For AEDistribution, the row looks like this:

AEDistribution 3 Clinical PR_C_EV_0003 OP_C_EV_0003 AE Distribution

The headers tell th informatation need. The cell containig OP_  is a references to the name of the HTML file that will be used for the report discription/help and needs to be in the downloaded help file location.

Please use the exisiting reports as examples of types of reports that can be made, then copy one and modify it to suit your needs. Much of the data manipulation is done in the begining of the .sas files.

Best,