Changes

Modify an iReport Template

103 bytes removed, 15:50, 7 April 2014

no edit summary

===The SQL Field===__NOEDITSECTION__

Most All iReport data sources have access to a special field called the SQL field to access hard to reach data. This field allows report designers to insert and execute an a SQL query to access data from within an iReport template. It's usage requires a knowledge of SQL and the IMSMA database structure and is only recommended for IMSMA administrators with a strong information management background. In most cases the all data sources, this special field has the name in the form of: is called '''SQLField'[object]''SQLFieldFor example HazardSQLField AccidentSQLField MRESQLField.

These fields can be added during the [[Create a Basic i-Report Template|iReport Wizard]] process or manually added later.

To use the SQL field to select data from the IMSMA database:

# In the '''Report Inspector''', choose click on the desired SQLField (e.g. HazardSQLField) to view it's its properties in the '''Properties''' pane.# Edit the name of the SQL field by adding a unique value to the end of the SQL field in parentheses. For example, ''HazardSQLFieldSQLField(testSQL)'' or ''AccidentSQLFieldSQLField(VictimCount)''.

# Choose the '''Properties''' setter to open the '''Properties List'''.

#: [[Image:IReport SQLField1.png|center|300px|''SQL Field Properties'']]<div align="center">''SQL Field Properties''</div>

# Set the '''Property Value''' to the desired SQL statement.

#: [[Image:IReport SQLField3.png|center|300px|''Set the SQL Values'']]<div align="center">''Set the SQL Values''</div>

# Return to the report and use the new SQL Field just like any other '''string ''' field.

====SQL Field Examples====__NOEDITSECTION__

• ← Older edit
• Newer edit →

Evinek

NoPublic, bureaucrat, administrator

1,068

edits