InetSoft Tools & Technology: Summary of Report Design Options
This chapter summarizes how data models and queries can be used to populate various report elements such as tables, charts, maps, and text fields. Procedures are shown for binding queries, selecting columns, creating formula columns, adding conditions, and specifying grouping and summarization.
Data Binding Summary
Data binding is the process of associating a set of data, usually a data model or the result set of a query, with a report element. Data binding is most commonly used with table, chart, and section elements, but can also be used with text-based elements. Elements can be bound to a data model, a query, or an asset. The data models and queries are created using the Data Modeler, and assets are created using the Data Worksheet.
Once a data model or a query is created using the Data Modeler, the data model or the query can be bound to a report element. If an element is bound, the element contents are retrieved from the database or any other data source at runtime. The following element types can have data bindings: Table, Section, Chart, Map, Text, and Textbox. It is important to note that unlike table or chart elements, a text element bound to data does not display any meta-data information in the Designer. The query result is only populated when the report is executed.
The ‘Data Binding’ tool is used to bind queries to elements in the Designer. Once the desired source of data has been selected, it is possible to refine the way it is bound to the element. For example, some columns may be hidden, conditions may be specified, and grouping and summarization may be added. There are five possible types of data sources to bind to elements: Query, Data Model, Report Data, Worksheet, and Parameter.