Shulou(Shulou.com)06/01 Report--

This article shows you how to use ActiveReports ribbon list components, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something.

ActiveReports v14.0

Grape City report control ActiveReports V14.0 has been officially released, fully supporting the .NET Core platform. At the same time, in this update, ActiveReports's desktop report designer UI has been fully enhanced, the way of report preview has been comprehensively optimized, and the ability of report design has been greatly improved.

For online report designer, ActiveReports V14.0 adds connectivity to data sources and datasets, ribbon list controls, and localization support. In this article, we will introduce the features and main functions of the ribbon list control in detail.

Summary

The ribbon list control is a new feature in ActiveReports V14.0 online report designer. It is a very powerful data control, which is divided into three data areas: the header, the detailed data row (for loading data fields), and the footer. Each zone can be used as a container control, that is, multiple controls can be embedded in each area at the same time to create reports in complex formats, such as master-slave reports, dynamic unfixed lists, and so on. Where the controls embedded in the detailed rows are rendered repeatedly according to the number of rows, while the header and footer are rendered only once to display the title and totals, respectively.

Select the entire control or click an area to set the properties of the entire control or a single zone, respectively.

The following is a list of properties for the entire control:

Using the ribbon list control, you can add a grouping header and trailer, or you can nest a grouping. Among them, the grouping basis can be an expression and the grouping data can be sorted. Note: sorting is not supported in the detail area of the ribbon list, and the sorting of the detail data must be completed at the time of query.

The following is a list of attributes for a single area (Band):

Properties dialog box for ribbon list

Select the ribbon list and click [Properties dialog box] below the properties pane. ] to open the properties dialog box options.

The properties dialog box contains several option pages: general, visibility, navigation, grouping, filtering, and data output.

Routine

Name: represents the name of the control, and the uniqueness of the same report should be guaranteed.

Tooltip: enter a paragraph of text that will be displayed when the user views the report and the mouse enters the control area.

Dataset name: select a dataset bound to this control.

Page number in the area: whether this control is numbered separately.

Delete white space in a container control: whether to automatically reduce white space within the scope of the control.

Page change: you can choose to insert a page change before or after the Banded List, or to display all the content on the same page as much as possible to avoid paging.

Column header and footer: you can choose to repeat the contents of the header or trailing area on each page, disable the display of the header or trailing area on a separate page, and print the trailing area at the bottom of the page (the default is followed by the details area content).

Visibility

By default, the control is visible when viewing the report, but it can be set to decide whether to hide the control based on the result of the expression, or you can set the control to hide based on the visibility of another control within the report.

Navigation

Document map label: enter text or expression to use as the project name of this control in the document map (that is, the catalog).

Bookmark ID: enter text or expression to use as a bookmark positioning ID to jump to this control. By setting [Bookmark to Bookmark] to this ID at other controls, you can click on other controls to jump to this control while viewing the report.

Grouping

Grouping can be used to organize and count data according to specific categories. For example, in a product inventory report, the list is displayed by default by product ID, but by setting grouping, you can display product information in the same category together by product category. Click the plus icon to add a new grouping, and the grouping properties can be set in multiple tabs.

Grouping-General

Name: enter a grouping name.

Grouping: select a field or edit an expression as the basis for grouping. Typically fields of a category nature, such as product category ID, year, month, business region, and so on.

Document map label: enter a text expression as the name of the catalog item.

Superior grouping: specify a parent grouping to achieve multi-level grouping.

Grouping-filtering

Filter conditions can be set to display partially grouped data.

A filter condition consists of three parts: expression, operator, and value.

Expression: the check object of a filter condition, usually a field.

Operator: that is, the comparison operator, including:

Equal: equality, that is, filter out data where the result of the evaluation of the expression on the left (or the value of a field) is equal to a specified value (the value to the right of the operator).

Like: contains, that is, the filter condition is that the expression on the left contains the value on the right. The value on the right usually contains an asterisk wildcard (*), which can be found in the Microsoft documentation: https://msdn.microsoft.com/en-us/library/swf8kaxw(v=vs.100).aspx

NotEqual: not equal to.

GreaterThan: greater than.

GreaterThanOrEqual: not less than, that is, greater than or equal to.

LessThan: less than.

LessThanOrEqual: not greater than, that is, less than or equal to.

TopN: only the first few pieces of data in the dataset are displayed, and the specific items are determined by the [value] specified below.

BottomN: only the last few pieces of data in the dataset are displayed, which are determined by the [value] specified below.

TopPercent: only the first few percent of the dataset is displayed, and how many percent is displayed, as determined by the [value] specified below.

BottomPercent: only the last few percent of the data set is displayed, and the specific percentage is displayed, which is determined by the value specified below.

In: only displays data where the result of the expression is equal to several specific values, which are determined by the [value] specified below.

Between: displays only the data where the result of the expression falls between two specific values, which are determined by the [value] specified below.

Value: depending on the operator, the value to the right of the operator in the filter condition may be a single constant value or multiple constant values (for example, in Between, In, and so on).

In addition, the value may contain wildcards, for example, when the operator is Like, the value may represent "Shaanxi Province * City".

For the TopPercent and BottomPercent operators, the value should be a numeric part without a percent sign, assuming that if you want to filter half of the data, the value should be 50, not 50 or 0.5.

Grouping-sorting

Multiple sorting conditions can be set to control the order in which the data is output. In sorting, the ascending and descending order of each condition can be different, for example, by annual descending order, and then by provincial ascending order.

Expression: it can be a single field or a combination of several fields.

Direction: used to control ascending or descending order.

Grouping-visibility

Used to set whether the current grouping is hidden.

Visible: always show, that is, not hidden.

Hidden: that is, it is always not displayed.

Expression: determines whether to hide or not according to the evaluation result of the expression. The expression should return a True/False Boolean type. Note: True means hidden, False means to show.

Visibility can be switched through other report elements: select another element within the current report, usually a text box, such as TextBox1. When the user views the report, a collapse and expansion icon represented by a plus sign and a minus sign appears on the left side of the text box. When the user clicks the icon, the current element will switch back and forth between showing and hiding.

A typical application scenario is that the content in the text box is set to "Show or hide the detail list", and then click on the plus or minus sign to the left of the text box to control whether a table or list is displayed.

Grouping-data output

Here set the element Tag when the report data is exported to XML.

Element name: enter a XML element name, which will be used as the Tag when the report data is exported to a XML file. For example, "ProductType".

Collection: enter a XML collection name, which will be used as the parent Tag of the element name Tag of the XML data output. For example, "ProductTypes".

Output: select [Yes] or [No] to indicate whether this data is included in the XML output.

Grouping-layout

Start page change: insert a hard page before this section.

Page change at the end: insert a hard page after this section.

Includes the packet header: displays the head area. Uncheck to hide the head area.

Including the tail of the group: displays the tail area. Uncheck to hide the tail area.

Repeat packet header: whether to repeat the header area when changing pages.

Repeat tail: whether to repeat the tail area when changing pages.

Area page number: whether to arrange the page number separately, the default is to arrange the page number uniformly according to the whole report.

Print the contents of the table in groups on the same page: when there is more content in this area and needs to be displayed in one page, it can be controlled to be displayed on a separate page (this may lead to a blank at the bottom of the previous page).

Do not display the head separately: do not display the head at the bottom of a page, that is, there is no detail in the following line.

Do not display the tail separately: do not display the tail at the top of a page, that is, there is no detail on the top line.

Print the tail area at the bottom of the page: the default tail area follows the data, which can be forced to be displayed at the bottom of the page when checked.

Filter

If you need to display only part of the data in the dataset, you can set the filter criteria here.

Click the plus icon in the upper right corner of the dialog box to create a new filter condition.

Data output

Here set the element Tag when the report data is exported to XML.

Element name: enter a XML element name, which will be used as the Tag when the report data is output to a XML file, such as "Product".

Output: automatically = let the system decide whether to export (the system will decide whether to export or not according to certain conditions, for example, do not export when the string in the text box is constant, or only export the field value content from the dataset); yes = always export; No = not export); content only = only data content is exported.

ActiveReports report Control | download trial

ActiveReports is a report control focused on .NET platform, which fully meets the needs of report design and development on platforms such as HTML5 / WinForm / ASP.NET / ASP.NET MVC / WPF. As a professional report tool, it provides comprehensive report development services for more than 300000 developers around the world.

The above is how to use the ActiveReports ribbon list components. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.