Data Sources
Fields
Summary
Chart
Chart2
Chart3
Chart4
Chart5
Gauge
Map
Misc
Style
Filters
Preview
Report List
|
New
Save
Save As...
Print
|
|
Results 
Distinct
Allow nulls


Recent Data Sources


Accounting
 
Catalog
 
HR
 
Sales

   

Help

Data Sources. Select the data sources for your report. You can select more than one data source.

  • Table - Lists the available tables and views.
  • Join Field – Lists the available fields from your selection above. Your selection here must match your selection in Field.
  • Foreign table – Lists the tables and views available to join with your selection in Table.
  • Field – Lists the available fields from your selection above. Your selection here must match your selection in Join Field.

 

Records
Show all fields      Visually Group By Sort by Delete
FieldDescriptionSortVGAFunctionFormat
XIAIBAdvanced Field SettingsMOVE
Add pivot columns forusingfunction
Add Subtotals

    

Help

Fields. Add and delete fields from your selected data sources. Sort the fields and perform sort and perform functions

  • Field: Lists all fields available from the tables and views selected in Data Sources.
  • Description: Describes the field. Defaults to field name, but can be edited.
  • Sort A: Sort by the selected Field.
  • Sort D: Sort by the selected Description.
  • VG: Visually groups the fields in your report.
  • A: Allows you to add, subtract, multiply, or divide by the selection in the row above. Click the box to.
  • Function: Allows you to perform a function on the selected Field.
  • Format: Allows you to format the selected Field.

You can add a summary line to all numeric fields using:

  • Avg – the average of the fields
  • Count – counts how many
  • Count Distinct – counts everything only once
  • Min value – Minimum value of the total
  • Maximum value – Maximum value of the total
  • Sum – Adds the total

Field|Value. Shows field and value for every pair.

 

TitleRecords
FieldDescriptionSortFunctionFormat
XIAIBAdvanced Field SettingsMOVE
Add Subtotals
Add Deltas

 

Help

Summary. View a summary of the Fields tab information.

Field|Value. Shows field and value for every pair.

 

Chart Type   
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)


 

Help

Chart. Create a chart for your report.

Pie: Select the Label and its corresponding function and the Value and its corresponding function. Click Sort A to indicate which one to sort by. Show as a 3D graphic, explode the largest slice, and select between a pie or a doughnut.

Trend: Select the Date and its corresponding function and the Value and its corresponding function. Click Sort A to indicate which one to sort by.

Plot: Select the X and Y values and click Sort A to indicate which one to sort by.

Bar chart: Select the Label and its corresponding function and the Value and its corresponding function. Click Sort A to indicate which one to sort by

 

Chart Type   
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)


 

Help

 

Chart Type   
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)


 

Help

 

Chart Type   
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)


 

Help

 

Chart Type   
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)
Value
Function
Value Ranges 
Sort
Sort (z-a)


 

Help

 

Title
Results
Name
Function
Value
Function
Sort
Function
Sort (z-a)
MinimumMaximum
Color
Gauge Style Radial Radial 2 Animated Half Circle Linear
Show values in currency format
 
Target report Effect
 

Help

Gauge. Guages can be used to build dashboards and help users visualize critical performance data. Place the field that describes what you are measuring and a value that contains the value.

 

Map Type
 

Help

 

Report Header Image Justification:  

Title
Description
Report Header
Page Header
Footer

Limit Outputs to CSV

Share WithRights
Owner    Drill-Down Key   Ignore first key

Schedule Repeat type Send Email as
 :   
Recipients

 

Help

Misc.  Add a title, report description header and footer.

 

Border color Header color Header foreground color
Item color Item foreground color Alternating item color


Sample grid
Number Letter
1 A
2 B

CSS:

Fill Zero Data Between Dates
Landscape printing
Show page number
Show date and time
Use pagination
Add bookmark for each visual group
Page Break After Visual Groups (PDF or DOC)
Minimize Grid Width

Columns Width


Visual Group Style


Items Per Page (In Viewer)


Report order
ChartMUMD
Chart2MUMD
Chart3MUMD
Chart4MUMD
GaugesMUMD
SummaryMUMD
DetailMUMD
MapMUMD
Chart5MUMD

Field|Value column pairs
Show main report in Field | Value style
Show summary report in Field | Value style

 

Help

Style. Set colors for the border, header, item and alternating item. Click Set Default to restore system defaults.

 

Filter FieldOperatorValue(s)BlankParam
 And 
XIAIBMOVE
RequireParameters in Viewer
Filter Logic



Help

Filters. Filter available fields.

  • Filter Field: - Lists the available fields.
  • Operator: – Lists the operations available for the above field.
  • Value(s): - Allows you to input conditions for the operation.
  • Blank: - Check the box to return results with the value or a blank (null).
  • Param: – Check the box to allow users to modify the parameter from the report viewer.

 

Help

Preview. View your report. Click on the column headings to sort in ascending or descending order.