Ginesys POS Report Designer FAQs
How to bind XML data to a report?
Report Name: Report1.repx
Method: Report properties : Data > XML Data Path > Select the XML file.
What is a Report Band?
A report layout consists of bands that contain report controls and define their location on document pages.
A blank report contains the following bands:
- The Detail band is printed for every record in a data source unless you filtered the data.
Every report should have the Detail band, and you cannot delete it.
- The Top Margin and Bottom Margin These bands are repeated once on every document page.
- Report Header and Report Footer
The Report Header is the report's first band (margins are "out-of-page" zones). Use this band to display the report's name, company logo, date of creation, username, etc.
The Report Footer is placed before the Page Footer and Bottom Margin on the report's last page. You can use the Report Footer band for report summaries or conclusions.
- Page Header and Page Footer
These bands are at the top and bottom of every page in a report. They display information that should be printed on every page.
- Group Header and Group Footer
These bands are above and below each group. The Group and Sort Panel (see GroupAndSortDockPanel) create these bands automatically.
How do I create Master - Detail Reports?
How do I display the current date and time in a report?
- Drop the XRPageInfo control from the Report Controls Toolbox tab onto the ReportHeader band.
- Set the control's XRPageInfo.PageInfo property to DateTime (e.g. using its smart tag).
- To apply a format string to the control's contents, type Created at {0:h:mm tt dd MMMM yyyy} into its XRPageInfo.Format property.
How do I add Page Numbers to the report?
- Create a PageFooterBand in your report. To do this, right-click anywhere in the report designer, and in the context menu point to Insert Band, and then click PageFooter.
- Drop the XRPageInfo control from the Report Controls Toolbox tab to the PageFooter band.
To change the control's display format, click its smart tag, and in the invoked actions list, specify the XRPageInfo.TextFormatString property (e.g., Page {0} of {1}, to display the current page number out of the total number of pages).
How do I add Page Numbers for Groups to the report?
Group the report by the field that you need to group.
To display the GroupFooter band, right-click anywhere on the report's surface, and in the invoked menu, point to Insert Band and click GroupFooter.
- You can force the group header and/or the group footer to be repeated on each page, using the GroupBand.RepeatEveryPage property.
- Next, force each new group to start on a separate page. Otherwise, group page numbers will be calculated incorrectly.
- To do this, select the Group Footer, and set its Band.PageBreak to AfterBand
- From the Report Controls toolbox tab, drop the XRPageInfo control onto the GroupFooter (or GroupHeader) band.
- Select the created control, and set its RunningBand property to GroupHeader1.
- To do this, select the Group Footer, and set its Band.PageBreak to AfterBand
How do I provide Interactivity to a report?
- Enable document content editing in Print Preview.
- Provide the drill-down functionality that allows end users to collapse and expand specific document sections.
- Enable report data sorting in Print Preview.
How do I Group And Sort Report Data?
Switch to the Group and Sort Panel.
- If this window is closed, you can open it using the XtraReports Menu:
- On this panel, click Add a Group and select a data field to use as grouping criteria.
- Specify the sort order (Descending or Ascending). Select None if no sorting is required (for instance, when the data is already sorted at the data source level).
- Enable both the Show Header and Show Footer options to create a corresponding pair of grouping bands.
- Switch to the Field List and drop the data field that was previously defined as grouping criteria onto the created Group Header.
- Switch to the Preview tab and view the result. The detail report data is grouped based on the grouping criteria value.
How do I calculate Summary (Using Expression Bindings)?
- Drop the label control from the Toolbox onto the Group Footer band.
- Click the label's smart tag and set the Summary Running property to Group to calculate summaries across report groups. Click the Expression property's ellipsis button, and in the invoked Expression Editor, specify the following expression to calculate the number of records in each group:
- Right-click the table located on the Detail band and add a new column to it.
- Click the created cell's smart tag and click the Expression property's ellipsis button. In the Expression Editor, switch to the Fields section and specify the expression that calculates the product of two numeric data fields (UnitsInStock and UnitPrice).
- Format to the created cell as currency and add a corresponding caption (for instance, "Inventory") to the table header.
- Switch to the Preview tab and view the result. You can see the total count of products under each group and the product of UnitsInStock and UnitPrice values in the
Inventory.
How do I calculate totals?
- Switch to the Field List and drop the a field onto the Group Footer to use the created control for displaying group totals.
- Click the control's smart tag and specify the following options:
- Summary Running(Running)
- Specifies the range across which to calculate the total (a Page, Group or Report).
- When the None option is selected, no summary is calculated, and the control displays its bound data field's current value.
- Summary Func(Func)
- This option is enabled only if the Summary Running property is set to a value other than None.
- Format String(TextFormatString)
- Applies a format string to the summary result.
- Applies a format string to the summary result.
- You can also use the XRSummary.IgnoreNullValues option (for instance, in the Property Grid) to specify whether to include null (empty) database records when calculating the total.
- Switch to the Preview tab and view the result. The total number of products is displayed under each group.
How to display page numbers in a report group or page?
A label can display row numbers after binding your report to data and specifying a bound data field in the XRLabel's Expression property.
- Click the label's smart tag and invoke its SummaryRunning drop-down list. Select Report to increment the row numbers throughout the entire report, or
select Group or Page to reset the row numbers for every group or page.
- Click the ellipsis button for the Expression property:
- This invokes the Summary Expression Editor where you can select the required function in the Functions | Summary section:
- You can use the FormatString property to format the resulting value:
You can switch to the Print Preview to see the record numbers displayed for the specified range:
How to concatenate two strings in a report?
Ref: https://www.devexpress.com/Support/Center/Question/Details/T606547/concatenate-2-string-in-report
Try creating a calculated field that combines both strings. You can do this in the Expression Editor at design-time. Then, bind this field to the XRLabel control.