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.
Thanks for posting in the JMP Clinical European Users Group.
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.
thank you for you quick answer.
Indeed, it will be interesting to have more details about the files to modify :)
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 :
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
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.
There are no labels assigned to this post.