...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
How to bind XML data to a report?
...
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.
...
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.
...
- 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:
...
- 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
...
- 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
...
How to Group and Sort data in a report?
| Info |
|---|
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...