Queries of Report editor
From MedITEX - Wiki
| Line 4: | Line 4: | ||
<ul> | <ul> | ||
</ul> | </ul> | ||
| − | <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>With the <strong>"Report editor"</strong> you can generate <strong>specific queries for various input areas</strong> of the software. It is possible to <strong>select almost any field in the database</strong>, which can then be displayed in a list.</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>This data can then be integrated in <strong>individual</strong> or <strong>serial letters</strong>, <strong>work lists</strong> and <strong>other reports</strong>, which can be generated individually with the report editor.</p> |
| − | <p>Every query or analysis can be saved and easily accessed in the system with a simple mouse click.</p> | + | <p>All lists that are generated in the report editor can of course be <strong>exported </strong>and <strong>used in other programs</strong> such as Excel.</p> |
| + | <p>Every query or analysis <strong>can be saved</strong> and easily accessed in the system with a simple mouse click.</p> | ||
<h2>Overview</h2> | <h2>Overview</h2> | ||
<p>Report editor main window is essentially divided in <strong>three parts</strong>:</p> | <p>Report editor main window is essentially divided in <strong>three parts</strong>:</p> | ||
<ol> | <ol> | ||
| − | <li>Group list</li> | + | <li><strong>Group list</strong></li> |
| − | <li>Area for queries</li> | + | <li><strong>Area for queries</strong></li> |
| − | <li>Area for query fields.</li> | + | <li><strong>Area for query fields</strong>.</li> |
</ol> | </ol> | ||
<table border="0"> | <table border="0"> | ||
| Line 24: | Line 25: | ||
<h3>Group list</h3> | <h3>Group list</h3> | ||
<p>From this area can be selected the <strong>sub-groups</strong> containing the fields necessary to build a query.</p> | <p>From this area can be selected the <strong>sub-groups</strong> containing the fields necessary to build a query.</p> | ||
| − | <p>If you double-click on a group you will see all available sub-groups . Double-click on a sub-group and you will see all fields that are available in this sub-group.</p> | + | <p>If you <strong>double-click on a group</strong> you will see all <strong>available sub-groups</strong> .</p> |
| + | <p><strong>Double-click on a sub-group </strong>and you will see <strong>all fields that are available</strong> in this sub-group.</p> | ||
<table border="0"> | <table border="0"> | ||
<tbody> | <tbody> | ||
| Line 47: | Line 49: | ||
</table> | </table> | ||
<p>The symbols before the field name are defined by the corresponding type of data.</p> | <p>The symbols before the field name are defined by the corresponding type of data.</p> | ||
| − | <p>Different symbols are:</p> | + | <p><strong>Different symbols are:</strong></p> |
<table border="0"> | <table border="0"> | ||
<tbody> | <tbody> | ||
| Line 121: | Line 123: | ||
<td> | <td> | ||
<p><strong>Saving a query:</strong></p> | <p><strong>Saving a query:</strong></p> | ||
| − | <p>A query can be saved for future use by clicking on <strong>"Save"-button</strong>. If the query was created from an existing query it can be saved choosing<strong> <a href="/index.php?title=How_to_save_a_query%3F">“Save as”</a></strong>. In this way the user can assign to the new query a name different from the parent query.</p> | + | <p>A query can be saved for future use by clicking on <strong>"Save"-button</strong>. If the query was created from an existing query it can be saved choosing <strong><a href="/index.php?title=How_to_save_a_query%3F">“Save as”</a></strong>. In this way the user can assign to the new query a name different from the parent query.</p> |
</td> | </td> | ||
</tr> | </tr> | ||
| Line 140: | Line 142: | ||
<tr> | <tr> | ||
<td><img src="/images/Query_fields.png" alt="" width="373" height="516" /></td> | <td><img src="/images/Query_fields.png" alt="" width="373" height="516" /></td> | ||
| − | <td>In this area are grouped all the fields belonging to each sub-group that constitutes the query tree. From this area each field can be chosen in order to build the desired query.</td> | + | <td>In this area are grouped all the<strong> fields </strong>belonging to each sub-group that constitutes the <strong>query tree</strong>. From this area <strong>each field can be chosen</strong> in order to build the desired query.</td> |
</tr> | </tr> | ||
</tbody> | </tbody> | ||
| Line 165: | Line 167: | ||
</table> | </table> | ||
<h3>Filter, group or sort the list of results</h3> | <h3>Filter, group or sort the list of results</h3> | ||
| − | <p>The list of results may be filtered, grouped and sorted by clicking the column headers as explained <a href="/index.php?title=Welcome_to_MedITEX_IVF#Managing_Lists">here</a><strong>.</strong> The filtering corresponds to a logical restriction of the data sets displayed in the list of results (e. g. only the pregnant patients of all, etc.).</p> | + | <p>The list of results may be <strong>filtered</strong>, <strong>grouped </strong>and <strong>sorted </strong>by clicking the column headers as explained <a href="/index.php?title=Welcome_to_MedITEX_IVF#Managing_Lists">here</a><strong>.</strong> The filtering corresponds to a logical restriction of the data sets displayed in the list of results (e. g. only the pregnant patients of all, etc.).</p> |
<h3>Statistically analyze, print or export</h3> | <h3>Statistically analyze, print or export</h3> | ||
| − | <p>The results can be easily analyzed and used to build charts. Moreover the results can be print or exported as Excel, CSV, HTML, TXT, PDF and XML file.</p> | + | <p>The results can be easily <strong>analyzed </strong>and <strong>used to build charts</strong>. Moreover the results can be <strong>print </strong>or <strong>exported </strong>as Excel, CSV, HTML, TXT, PDF and XML file.</p> |
<h3>Generate letters, work lists or reports</h3> | <h3>Generate letters, work lists or reports</h3> | ||
| − | <p>The results can be used to build standard templates of letters, reports or working lists. Such reports may be made available for user in other sections of the software such as Administration, Medical History etc.</p> | + | <p>The results can be used to <strong>build standard templates of letters</strong>, <strong>reports </strong>or <strong>working lists</strong>. Such reports may be made available for user in other sections of the software such as Administration, Medical History etc.</p> |
<h2>"Using" step by step.</h2> | <h2>"Using" step by step.</h2> | ||
<ul> | <ul> | ||
Revision as of 10:26, 18 December 2012
Contents |
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.
Overview
Report editor main window is essentially divided in three parts:
- Group list
- Area for queries
- Area for query fields.
  |
Group list
From this area can be selected the sub-groups containing the fields necessary to build a query.
If you double-click on a group you will see all available sub-groups .
Double-click on a sub-group and you will see all fields that are available in this sub-group.
| <img src="/images/REGroups.png" alt="" width="334" height="466" /> |
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.
|
The symbols before the field name are defined by the corresponding type of data.
Different symbols are:
| <img src="/images/F1.png" alt="" width="51" height="33" /> | Number fields. | <img src="/images/F6.png" alt="" width="43" height="36" /> | Date fields. |
| <img src="/images/F2.png" alt="" width="48" height="41" /> | Text fields. | <img src="/images/F7.png" alt="" width="44" height="35" /> | Telephone fields. |
| <img src="/images/F3.png" alt="" width="46" height="40" /> |
Note fields (text fields of different sizes). |
<img src="/images/F8.png" alt="" width="42" height="34" /> | QM staff fields. |
| <img src="/images/F4.png" alt="" width="52" height="40" /> | Yes / No fields. | <img src="/images/F9.png" alt="" width="44" height="34" /> | QM material fields. |
| <img src="/images/F5.png" alt="" /> | Key fields. | <img src="/images/F10.png" alt="" /> | QM free fields. |
Area for queries
| <img src="/images/Person11RE.png" alt="" width="439" height="156" /> | In this area the sub-groups can be drag&dropped from group list or be deleted in order to build the query tree. The sub-groups are hierarchically ordered as a “Logical cascade”. |
| <a href="/index.php?title=Result_management"><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExecuteRE.png" alt="" width="89" height="38" /></a> |
Execute: Executing a query. As soon as you have selected all needed fields you can launch the query by clicking this button. The <a href="/index.php?title=Result_management">Report editor: result window</a> will be open. |
| <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. |
| <a href="/index.php?title=How_to_load_a_query%3F"><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/OpenRE.png" alt="" width="92" height="37" /></a> |
Loading a query: A saved query can be simply by clicking on the "Open"-button. A new window, "Saved queries", will pop up. Read more about it <a href="/index.php?title=How_to_load_a_query%3F">here</a>. |
| <a href="/index.php?title=How_to_save_a_query%3F"><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SaveRE.png" alt="" width="89" height="83" /></a> |
Saving a query: A query can be saved for future use by clicking on "Save"-button. If the query was created from an existing query it can be saved choosing <a href="/index.php?title=How_to_save_a_query%3F">“Save as”</a>. In this way the user can assign to the new query a name different from the parent query. |
| <img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ResultRE.png" alt="" width="208" height="91" /> |
Result data records: A selection of shown Results can be chosen here.
|
Area for query fields
| <img src="/images/Query_fields.png" alt="" width="373" height="516" /> | In this area are grouped all the fields belonging to each sub-group that constitutes the query tree. From this area each field can be chosen in order to build the desired query. |
Report editor: results
When the query is executed the window showing the list of query’s results will open. All the selected data fields are all represented in individual columns.
  |
|
You can generally do four things with the query result:
|
Filter, group or sort the list of results
The list of results may be filtered, grouped and sorted by clicking the column headers as explained <a href="/index.php?title=Welcome_to_MedITEX_IVF#Managing_Lists">here</a>. The filtering corresponds to a logical restriction of the data sets displayed in the list of results (e. g. only the pregnant patients of all, etc.).
Statistically analyze, print or export
The results can be easily analyzed and used to build charts. Moreover the results can be print or exported as Excel, CSV, HTML, TXT, PDF and XML file.
Generate letters, work lists or reports
The results can be used to build standard templates of letters, reports or working lists. Such reports may be made available for user in other sections of the software such as Administration, Medical History etc.
"Using" step by step.
- If you want to know how to create or use it, <a href="/index.php?title=MedITEX_IVF_how_to#Report_editor">click here</a>.
Query management tools
- <a href="/index.php?title=Query_management_tools#Query_import_and_export">Changes, Import, Export,...</a>
Result management
- <a href="/index.php?title=Result_management">Query results, WOMOD, Rich text modules, Administrate letters</a>
| <a href="/index.php?title=MedITEX_IVF_manual">Back to the MedITEX IVF menu </a> | <a href="#top">Back to top</a> |