View source for Queries of Report editor

<p>__TOC__<br /> To open the <strong>Report editor</strong>, go to <strong>Reports -&gt; Report editor </strong>in the menu bar.</p>
<table style="margin-left: auto; margin-right: auto;" border="0" width="10" height="24">
<tbody>
<tr>
<td><img src="/images/ReportEd.png" alt="" width="447" height="263" /><br /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>With <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>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>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><a href="/index.php?title=Lists"><img src="/images/hint48.png" alt="" /></a></td>
<td><a href="/index.php?title=Lists">All lists</a> that are generated in the report editor can of course be <strong>exported </strong>and <strong>used in other programs</strong> such as Excel.</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>Every query or analysis <strong>can be saved</strong> and easily accessed in the system in one click.</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><a href="/index.php?title=MedITEX_IVF_Settings#Report_editor"><img src="/images/plus48.png" alt="" width="48" height="48" /></a></td>
<td>Configure your report editor in the <a href="/index.php?title=MedITEX_IVF_Settings#Report_editor">system settings</a>.</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h2>Overview</h2>
<p>Report editor main window is essentially divided in <strong>three parts</strong>:</p>
<ol>
<li><strong>Group list</strong></li>
<li><strong>Area for queries</strong></li>
<li><strong>Area for query fields</strong></li>
</ol> 
<table border="0">
<tbody>
<tr>
<td>[[Image:REWindowRed.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/REWindowRed.png| ]]<br /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h3>Group list</h3>
<p>From this area you can select <strong>sub-groups</strong> containing the fields necessary to build a query.</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">
<tbody>
<tr>
<td><img src="/images/REGroups.png" alt="" width="334" height="466" /><br /></td>
<td>
<p><strong>On the left, all the tables and fields are placed which you can use for your query:</strong></p>
<ul>
<li>Patients</li>
<li>Cycles</li>
<li>Examinations / Medical histories</li>
<li>Cryo</li>
<li>Administration</li>
<li>Personnel</li>
<li>Referrers</li>
</ul>
<p><span class="short_text" lang="en"><span class="hps">Pull subgroups from the left in the middle pane to build a query.</span></span></p>
<p><span class="short_text" lang="en"><span class="hps">&nbsp;</span></span></p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>The symbols before the field name is defined by the corresponding type of data.</p>
<p><strong>Different symbols are:</strong></p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><img src="/images/F1.png" alt="" /></td>
<td>Number fields.</td>
<td><img src="/images/F6.png" alt="" /></td>
<td>Date fields.</td>
</tr>
<tr>
<td><img src="/images/F2.png" alt="" /></td>
<td>Text fields.</td>
<td><img src="/images/F7.png" alt="" /></td>
<td>Telephone fields.</td>
</tr>
<tr>
<td><img src="/images/F3.png" alt="" /></td>
<td>
<p>Note fields (text fields of different sizes).</p>
</td>
<td><img src="/images/F8.png" alt="" /></td>
<td>QM staff fields.</td>
</tr>
<tr>
<td><img src="/images/F4.png" alt="" /></td>
<td>Yes / No fields.</td>
<td><img src="/images/F9.png" alt="" /></td>
<td>QM material fields.</td>
</tr>
<tr>
<td><img src="/images/F5.png" alt="" /></td>
<td>Key fields.</td>
<td><img src="/images/F10.png" alt="" /></td>
<td>QM free fields.</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h3><span class="short_text" lang="en"><span class="hps">Area for queries</span></span></h3>
<table border="0">
<tbody>
<tr>
<td><img src="/images/Person11RE.png" alt="" width="439" height="156" /></td>
<td>In this area, the <strong>sub-groups</strong> can be <strong>drag and dropped</strong> from group list or be deleted in order to build the query tree. The sub-groups are hierarchically ordered as a <strong>Logical cascade</strong>.</td>
</tr>
</tbody>
</table>
<p><span class="short_text" lang="en"><span class="hps"><br /></span></span></p>
<p>Buttons with a blue dotted frame have special functionalities. Click on it to have more information.</p>
<table border="0">
<tbody>
<tr>
<td><a href="/index.php?title=Result_management"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/ExecuteRE.png" alt="" width="89" height="38" /></a></td>
<td>
<p><strong>Execute:</strong></p>
<p>As soon as you have selected all needed fields, you can launch the query by clicking on this button. The <a href="/index.php?title=Result_management"><strong>result window</strong></a> will be opened.</p>
</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/NewRE.png" alt="" width="88" height="36" /></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>
<td><a href="/index.php?title=How_to_load_a_query%3F"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/OpenRE.png" alt="" width="92" height="37" /></a></td>
<td>
<p><strong>Loading a query:</strong></p>
<p>A saved query can be loaded by clicking on the <strong>Open</strong> button. A new window, <strong>Saved queries</strong>, will pop up. Read more about it <a href="/index.php?title=How_to_load_a_query%3F">here</a>.</p>
</td>
</tr>
<tr>
<td><a href="/index.php?title=How_to_save_a_query%3F"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/SaveRE.png" alt="" width="89" height="83" /></a></td>
<td>
<p><strong>Saving a query:</strong></p>
<p>A query can be saved for future use by clicking on the <strong>Save</strong> button. 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>. This way, the user can assign a different name to the new query a.</p>
</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ResultRE.png" alt="" width="208" height="91" /></td>
<td>
<p><strong>Result data records:</strong></p>
<p>Here you can select the number of displayed results.</p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h3>Area for query fields</h3>
<table border="0">
<tbody>
<tr>
<td><img src="/images/Query_fields.png" alt="" width="373" height="516" /></td>
<td>This area groups all<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>
</tbody>
</table>
<p>&nbsp;</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td>[[Image:FieldsSelection.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/FieldsSelection.png| ]]</td>
</tr>
<tr>
<td style="text-align: center;">
<p style="text-align: center;"><span id="result_box" lang="en">Select the desired fields. </span></p>
<p style="text-align: center;"><span id="result_box" lang="en">With a right-click on this area, the fields can be sorted by "<strong>selection</strong>".</span></p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h2>Report editor: results</h2>
<p>When the query is <strong>executed</strong> the window showing the list of<strong> results</strong> will open. All the selected data fields are all represented in individual columns.</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td>[[Image:Result1.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/Result1.png| ]]</td>
</tr>
<tr>
<td>
<p>You can generally do many things with the query result:</p>
<ul>
<li>Filter, group or sort the list of results;</li>
<li>Statistically analyze, print      or export; </li>
<li>Generate      letters, work lists or reports.</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h3>Filter, group or sort the list of results</h3>
<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>
<p>The results can be easily <strong>analyzed </strong>and <strong>used to build charts</strong>. Moreover, the results can be <strong>printed </strong>or <strong>exported </strong>as Excel, CSV, HTML, TXT, PDF and XML file.</p>
<h3>Generate letters, work lists or reports</h3>
<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 users in other sections of the software such as <strong>Administration</strong>, <strong>Medical History</strong>, etc.</p>
<p>&nbsp;</p>
<h2>Further information</h2>
<p>Find more information about the report editor at <strong>Important functionalities</strong> on the main page:</p>
<table border="0">
<tbody>
<tr>
<td rowspan="3"><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
<td>
<p><a href="/index.php?title=Query_management_tools"><strong>Query management tools</strong></a></p>
<p><a href="/index.php?title=Query_management_tools">Here</a> you can read more about changing text, deleting descriptions, writing protections and the importing/exporting of queries.</p>
</td>
</tr>
<tr>
<td>
<p><a href="/index.php?title=Result_management"><strong>Result management</strong></a></p>
Click <a href="/index.php?title=Result_management">here</a> if you want to get more information about the query results, <strong>WOMODs</strong>,<strong> Rich text modules</strong> or <strong>Administration of letters</strong>.</td>
</tr>
<tr>
<td>
<p><strong><a href="/index.php?title=Queries_examples">Queries examples</a></strong></p>
<p><a href="/index.php?title=Queries_examples">Here</a> you can find some <strong>examples </strong>and <strong>tutorials </strong>that will help you to deal with the Report editor.</p>
</td>
</tr>
<tr>
<td><a href="/index.php?title=MedITEX_IVF_how_to#Report_editor"><img src="/images/howto48.png" alt="" width="48" height="48" /></a></td>
<td>
<p><a href="/index.php?title=MedITEX_IVF_how_to#Report_editor"><strong>Step by step</strong></a></p>
If you want to know how to create a query, open a saved one, etc., <a href="/index.php?title=MedITEX_IVF_how_to#Report_editor">click here</a>.</td>
</tr>
</tbody>
</table>
<table style="float: right;" border="0">
<tbody>
<tr>
<td style="text-align: right;"><a href="/index.php?title=MedITEX_IVF_manual">Back to the MedITEX IVF menu </a></td>
<td style="text-align: right;"><a href="#top">Back to top</a></td>
</tr>
</tbody>
</table>