Queries of Report editor
From MedITEX - Wiki
| Line 1: | Line 1: | ||
<p>To open the Report editor, go to <strong>Report -> Report editor in the menu bar</strong>.</p> | <p>To open the Report editor, go to <strong>Report -> Report editor in the menu bar</strong>.</p> | ||
| + | <p>With the <strong>"Report editor"</strong> you can generate <strong>specific queries for various input areas</strong> of the software. It is possible to select almost any field in the database, which can then be displayed in a list. This data can then be integrated in individual or serial letters, work lists and other reports, which can be generated individually with the report editor.</p> | ||
| + | <p>All lists that are generated in the report editor can of course be exported and used in other programs such as Excel.</p> | ||
| + | <p>Every query or analysis can be saved and easily accessed in the system with a simple mouse click.</p> | ||
<p>For better understanding, we divide the window into <strong>"1. Selection"</strong> and <strong>"2. Queries"</strong>.</p> | <p>For better understanding, we divide the window into <strong>"1. Selection"</strong> and <strong>"2. Queries"</strong>.</p> | ||
<table border="0"> | <table border="0"> | ||
| Line 37: | Line 40: | ||
<tr> | <tr> | ||
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExecuteRE.png" alt="" width="89" height="38" /></td> | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExecuteRE.png" alt="" width="89" height="38" /></td> | ||
| − | <td> | + | <td> |
| + | <p><strong>Execute:</strong></p> | ||
| + | <p>Start the query.</p> | ||
| + | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/NewRE.png" alt="" width="88" height="36" /></td> | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/NewRE.png" alt="" width="88" height="36" /></td> | ||
| − | <td> | + | <td> |
| + | <p><strong>New:</strong></p> | ||
| + | <p>Clears the contents of the selection window. A new selection can be made.</p> | ||
| + | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
Revision as of 11:38, 7 December 2012
To open the Report editor, go to Report -> Report editor in the menu bar.
With the "Report editor" you can generate specific queries for various input areas of the software. It is possible to select almost any field in the database, which can then be displayed in a list. This data can then be integrated in individual or serial letters, work lists and other reports, which can be generated individually with the report editor.
All lists that are generated in the report editor can of course be exported and used in other programs such as Excel.
Every query or analysis can be saved and easily accessed in the system with a simple mouse click.
For better understanding, we divide the window into "1. Selection" and "2. Queries".
  |
1. Selection - Tabels and fields
| <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:
Pull subgroups from the left in the middle pane to build a query.
|
2. Queries - Create and modify queries
Menu bar
| <img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExecuteRE.png" alt="" width="89" height="38" /> |
Execute: Start the query. |
| <img style="display: block; margin-left: auto; margin-right: auto;" src="/images/NewRE.png" alt="" width="88" height="36" /> |
New: Clears the contents of the selection window. A new selection can be made. |
| <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" /> |
| <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. |
| <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. |
|
  |