Database Merge reports allow you to "Merge" a form letter or report with data entered into Case Report Forms.  Document processing offers the ability to have templates for referring physician letters, thank you letters or ePro instructions that can be merge with patient specific records for reports to quickly and efficiently run and manage your study.


On a Web Browser:  


  1. Click on Reports>DB Merge Reports
  2. Click on Edit to display template of report in white work area below.
  3. Select Correct site from Site drop down (if applicable)
  4. Click on Subject to merge into report.
  5. Click on Merge and Create Report

 



 


The following describes the codes available to be used in your report:

Change Form
[!{'current form' : {'name' : 'ENTER FORM NAME HERE' , 'visit' : '-1'}}!] 

 

Note -1 in string above means unscheduled visit.

To get the visit ID: Go to Create or Edit Scheduled Visit Application under the Study Menu. The db_id column number will give you visit id where form is located.


Text Field
[!{'field': {'name' : 'FIELD NAME'}}!]


Interval

Interval: [!{'constant': {'name' : 'interval_name'}}!] 


Image Field
[! {'image_field': {'field_name':'Field Name', 'width':'500', 'height':'300'}}!]

Table from One to Many Form
[!{'table': {'form_name' : 'Field Name', 'fields' : {'1' : 'al_act', '2' : 'al_datetime', '3' : 'al_dist', '4' : 'al_dir'}}}!] 


Table from One to Many Form with interval included in table as column

[!{'table': {'form_name' : 'Follow Up', 'fields' : {'1' : 'FU_DATE', '2' : 'FU_REASON', '3' : 'PAINLEVEL', '4' : 'COMMENTS', '5' : 'interval_name'}}}!]


Use Constant
[!{'constant': {'name' : 'sub_profile_id'}}!]

Avoid Page Break
<div style="page-break-inside: avoid">
[! {'image_field': {'field_name':'sp_image', 'width':'500', 'height':'300'}}!]
</div>
 

Must have the following string in your document to declare an end.
Declare End of Document
[!{'end':'end'}!] 



On a Mobile Device:

  


  1. Select Study Tab on bottom of screen
  2. Select Database Merge Reports from choices





  1. Select Correct site from Site drop down (if applicable)
  2. Click on Report to merge with subject data to produce output
  3. Click on any icon to navigate through application






  1. Select Subject you want to merge and produce report with.
  2. Click on any icon to navigate through application