This topic is under construction for the 20.11 (November 2020) release of LabKey Server. For current documentation of this feature, click here.

In a file-based module, the reports directory holds different kinds of reports and associated configuration files which determine how the reports are surfaced in the user interface.

Below we'll make an R report script that is associated with the "Master Dashboard" query (created in the previous step).

  • In the reports/ directory, create the following subdirectories: schemas/study/Master Dashboard, and a file named "HgbHistogram.r", as shown below:
fileBasedDemo │ module.properties └───resources    ├───queries    │ └───study    │ │ BMI.sql    │ │ BMI.query.xml    │ │ Master Dashboard.sql    │ │    │ └───LabResults    │ DRV Regimen Results.qview.xml    │    ├───reports    │ └───schemas    │ └───study    │ └───Master Dashboard    │ HgbHistogram.r    │    └───views
  • Open the HgbHistogram.r file, enter the following script, and save the file.
png(
filename="${imgout:labkeyl_png}",
width=800,
height=300)

hist(
labkey.data$hemoglobin,
breaks=100,
xlab="Hemoglobin",
ylab="Count",
main=NULL,
col = "light blue",
border = "dark blue")

dev.off()

View Your R Report

  • In your study folder, open the query browser via (Admin) > Go to Module > Query.
  • Click study, then Master Dashboard.
  • Click View Data to run the query and view the results.
  • View the new R report by selecting (Charts/Reports) > HgbHistogram.

Add Another Report

You can also add R reports on the "built-in" queries, which include provisioned datasets. To do so, name the directory for the table instead of the query. For example:

fileBasedDemo │ module.properties └───resources    ├───queries    │ └───study    │ │ BMI.sql    │ │ BMI.query.xml    │ │ Master Dashboard.sql    │ │    │ └───LabResults    │ DRV Regimen Results.qview.xml    │    ├───reports    │ └───schemas    │ └───study    │ └───LabResults    │ │ LymphCD4.r    │ └───Master Dashboard    │ HgbHistogram.r    │    └───views

Download this R script file and place it in the LabResults directory you just created:

Click the Clinical and Assay Data tab and find this new R report in the Assay section along with the LabResults dataset.

Related Topics

Tutorial Steps

Previous Step | Next Step (5 of 5)

Discussion

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand all collapse all