Queries of Report editor

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 12: Line 12:
 
<tr>
 
<tr>
 
<td><img src="/images/REWindow.png" alt="" width="765" height="477" /></td>
 
<td><img src="/images/REWindow.png" alt="" width="765" height="477" /></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<h3>1. Tabels and fields</h3>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td><img src="/images/Tables1RE.png" alt="" width="327" height="473" /></td>
 +
<td>
 +
<p>On the left, all the tables and fields are placed which you can use for your query.</p>
 +
<ul>
 +
<li>Patients</li>
 +
<li>Cycles</li>
 +
<li>Examinations / Medical histories</li>
 +
<li>Cryo</li>
 +
<li>Administration</li>
 +
<li>Personell</li>
 +
<li>Referrers</li>
 +
</ul>
 +
<p><span class="short_text" lang="en"><span class="hps">To define conditions on a certain field, double click it's label. </span></span></p>
 +
</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
Line 19: Line 40:
 
<p><span class="short_text" lang="en"><span class="hps">In the right pane the fields will appear for each chosen group:</span></span></p>
 
<p><span class="short_text" lang="en"><span class="hps">In the right pane the fields will appear for each chosen group:</span></span></p>
 
<p><span class="short_text" lang="en"><span class="hps">there you can select which fields should appear in the result.</span></span></p>
 
<p><span class="short_text" lang="en"><span class="hps">there you can select which fields should appear in the result.</span></span></p>
<p><span class="short_text" lang="en"><span class="hps">To define conditions on a certain field, double click it's label. <br /></span></span></p>
+
<p><span class="short_text" lang="en"><span class="hps"><br /></span></span></p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>

Revision as of 16:46, 26 November 2012

<tbody> </tbody>
<img src="/images/REWindowShort.png" alt="" width="765" height="201" />

To open the Report editor, go to Report -> Report editor in the menu bar.

For better understanding, we divide the window into "1. Report editor: selection" and "2. Report editor: queries".

<tbody> </tbody>
<img src="/images/REWindow.png" alt="" width="765" height="477" />

1. Tabels and fields

<tbody> </tbody>
<img src="/images/Tables1RE.png" alt="" width="327" height="473" />

On the left, all the tables and fields are placed which you can use for your query.

  • Patients
  • Cycles
  • Examinations / Medical histories
  • Cryo
  • Administration
  • Personell
  • Referrers

To define conditions on a certain field, double click it's label.

Pull subgroups from the left in the middle pane to build a query.


In the right pane the fields will appear for each chosen group:

there you can select which fields should appear in the result.