Data Grid Settings
|
Object
|
Details
|
Additional Information
|
Row Height
|
Specifies the minimum height of the rows.
|
|
Variable Height
|
Check this box to allow rows to automatically size to the greatest height required to display all of the data in the row.
|
|
Max Rows
|
Specifies that maximum number of rows that should be fetched from the server for this display page. You can then click the buttons beneath the list to page up or down.
|
|
|
The reason for specifying the number of rows is that you may have a very large number of records to report on. Bearing in mind that PerfectApps is a Web application, fetching them all at once across what might be a slow connection could pose performance problems. It would also waste server resources. So data is fetched a page at a time and the Rows value determines how many app Instances are fetched in each page.
|
|
Header Height
|
Specify the height of the text in the data grid header.
|
|
Show Paging Buttons
|
Uncheck the box only if you don't want to allow users to page through the contents of the list.
|
|
Show Paging Numbers
|
Uncheck the box only if you don't want to display the page number currently being viewed or available.
|
|
Show Export Option
|
If you check this, an export icon will show at the bottom of the list or grid. When report users click the export button, they can specify the format of the exported the data.
|
|
Data Source
|
Data Source
|
All reporting objects must point to a data source. If you only have defined one then this will be automatically selected.
|
|
|
Although you can have multiple data sources in a report each reporting object can only point to a single data source.
|
|
Column Data Fields
|
Caption
|
The label that is displayed in the column header.
|
|
Field
|
Displays the field that is reported. Select the appropriate row in the Column Data table and then select the required Field from the Field drop-down under the table.
This cell must be set correctly to get the desired results. You will notice that you can select two main elements within this cell: the function and the field or expression. When you click in the cell, the upper drop-down allows you to select either Group or the function used to aggregate the data. The drop-down beneath it, but in the same cell, allows you to select the field or Expression (using the ellipses  button).
|
Using the Formula and Condition Editor
|
Add Column
|
Click the Add Column button to add a new column to the Data Grid.
|
|
Delete Column
|
Click the Remove Column button to remove a column from the Data Grid
|
|
Move up or down
|
Click the Move Column Up and Move Column Down buttons to reorder the Data Grid columns by moving them up and down in the list.
|
|
Fit Columns Evenly
|
Click the Fit Columns Evenly button to automatically make the widths of all of the columns the same.
|
|
Aggreg.
|
When you click in the drop-down, you may select either Group or a function used to aggregate the data for the field selected below.
|
|
|
Typically if you wanted to report on the number of sales per country then your first column would be Country with the Group option selected and your second column would be Sales with the Sum Function selected.
|
|
Field
|
Click the drop-down to select the field from the data source to report on.
|
|
|
Only fields selected in the data source will be available to report on.
|
|
Sort
|
Click here if you want to sort the list using this column.
Choose from None, Ascending, Descending or you can delegate your sort to another column in the Data Grid.
|
Delegating Sort Order for Data Lists and Data Grids
|
Width
|
Use this to specify the width of the column in pixels.
|
|
|
If the sum of the width of all columns is less than the width of the Data Grid then the right most column will be expanded to take up the extra width.
If the sum of the width of all columns is greater then the width of the Data Grid then a scroll bar will be displayed.
|
|
Align
|
Select alignment of the data in the column.
|
|
Hidden
|
Check this box to hide the column from view.
|
|
Include in dynamic filter
|
Check this box to include data in this column in a dynamic filter.
|
|
|
Ensure that the Can Set Dynamic Filter is also selected.
|
|
Format
|
Optionally format the field in the report.
|
|
Filter
|
Can set dynamic filter
|
This means that a selection within the object causes the filter event to be broadcast to other objects within the report that have the Respect Dynamic Filter set.
|
|
|
Multiple dynamic filters are applied with the AND or the OR operator depending on the selection made in the data source.
|
|
Respect dynamic filter
|
Causes the object to listen to any drill-down filter that is caused by the user clicking on a report object that has the Can Set Dynamic Filter option selected. If you do not want the object to filter its data when the drill-down occurs then turn off this property.
|
|
Override previous filter
|
By default, each object that you click on for a drill-down filter remains in effect when subsequent objects are selected. In other words, the drill-downs you select are cumulative. However, you may want a drill-down selection to clear all other existing drill-down filters before performing its own drill-down. In this case, you would check the Override Previous box.
|
|
Misc
|
Show all possible values
|
If this is checked then it will include values where there is a result of 0. If left unchecked then 0 value results will be omitted from the chart.
|
|
Open links in new window
|
Uncheck this default option to open the linked instance in the existing browser tab. Otherwise, the default action will be to open linked items in a new browser tab.
|
Creating a Reporting Portal
|
Accessibility
|
Description
|
Enter text that will be read aloud or converted to Braille for JAWS users.
|
Accessibility and JAWS Compatibility
|
Position
|
Top
|
Displays the object's location in from the top of the app (in pixels).
|
|
Left
|
Displays the object's location in from the left margin of the app (in pixels).
|
|
Width
|
Shows the width of the object.
|
The width cannot be less than 280px.
|
Height
|
Shows the height of the object.
|
The height cannot be less than 150px.
|
Layer
|
Indicates the layer number this object occupies. You can drag an object so that it fully or partially covers another object. Depending on the layer number it occupies, it may be positioned underneath another other object.
|
|
