Changes

Jump to: navigation, search

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__
Evinek
NoPublic, bureaucrat, administrator
1,068
edits
Retrieved from "http://mwiki.gichd.org:8090/IM/Special:MobileDiff/14698"

Navigation menu