Queries of Report editor

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 75: Line 75:
 
<tr>
 
<tr>
 
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Street.png" alt="" width="146" height="53" /></td>
 
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Street.png" alt="" width="146" height="53" /></td>
 +
<td>&nbsp;</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 80: Line 81:
 
<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>
 
<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>
 
</td>
 +
<td>&nbsp;</td>
 +
</tr>
 +
<tr>
 +
<td>
 +
<p>[[Image:DefineConditionsRE.png|none|350px|thumb|left|link=http://wiki.meditex-software.com/images/DefineConditionsRE.png| ]]</p>
 +
</td>
 +
<td>&nbsp;</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>

Revision as of 18:14, 26 November 2012

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

For better understanding, we divide the window into "1. Selection" and "2. Queries".

<tbody> </tbody>
REWindow.png

1. Selection - 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

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

 

 

2. Queries - Create and modify queries

Menu bar

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExecuteRE.png" alt="" width="89" height="38" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/NewRE.png" alt="" width="88" height="36" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/OpenRE.png" alt="" width="92" height="37" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SaveRE.png" alt="" width="89" height="83" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ResultRE.png" alt="" width="208" height="91" />  

 

<tbody> </tbody>
<img src="/images/Person1RE.png" alt="" width="400" />

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

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


 

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Street.png" alt="" width="146" height="53" />  

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

 

DefineConditionsRE.png