Page History

...

You should be familiar with how data is stored in your system in order to map a form field to a database field, and have some familiarity with database concepts, including schema structure and SQL queries. For details on the DrCloudEHR database schema design see DrCloudEHR Database Design.

When you create a report, you create a SQL query that retrieves the data you want to include from the database. You can click the Preview Query button to see the query run to build your report.

You can also create your own SQL query directly, instead of using the report generator. For more information, see Create Your Own SQL Query.

This topic contains the following sections:

...