| Article Index |
|---|
| Module - Data Access |
| Access the Module |
| Create reporting database |
| Open Report Builder |
| Create new data source |
| Create new dataset |
| Database schema list |
| All Pages |
Create your own custom reports
The goal of this module is to remove the complexity of the relationships between data items in our database structure. This makes it easier for users to create SQL reports without the need to know those relationships.
Through the module interface, a copy of your database is made that provides read only access to preselected data categories. The database copy is read only to give users peace of mind when creating reports. You can safely use this data without the fear of altering information in either your original database, or the read only database copy.
A reporting system that can connect to SQL Server must be installed to use this module. RxWorks server loads will come with this installed. If you are using a non-RxWorks server load we recommend your IT Technician installs Microsoft SQL Server Report Builder.
We do not intend that this module is used by anyone who is unfamiliar with SQL reporting. This manual will provide the guidelines for users with SQL experience and is not intended for those who do not have it.
Our support team is available for general questions on this module; however we do not provide support on writing SQL queries.
RxWorks strongly suggest a person familiar with SQL is available to assist you in building custom reports.
Download the RxWorks database schema list to help write your reports.
