← Back to all blogs

Posts tagged with 'grouping'

Hide Duplicate Values

With ActiveReports, you can hide duplicate values of a record. How you do this depends on the type of report you are using.

Adding Group Page Breaks

To display each data group on a separate page, you need to sort the data and add page breaks for each group. Where you do this depends on the type of report you're using. Let's take a look at grouping in each report type.

Three Ways to Use Summaries in Section Reports

In Section reports, the TextBox control has several Summary properties that, combined, let you render running summaries and grand totals in header or footer sections of your reports.

Wijmo Webcast: Visualizing Large Data Sets with Wijmo Enterprise

Here's a recent webcast on how to utilize some of the new features in Wijmo Enterprise for visualizing large datasets in a manner that is consistent with Wijmo Enterprise’s vision. Our vision is to build highly performant, touch-first, lightweight, true JavaScript controls without making comprises for older technologies.

Creating Column Groups in FlexGrid

Most tables and grids include a single header row that shows the name of the field that the column refers to.

Hide Column From C1FlexGridGroupPanel While Dragging

Grouping in ComponentOne FlexGrid for WPF is implemented with the help of C1FlexGridGroupPanel. When grouping is applied on C1FlexGrid then a new grouping area is exposed in the header with a watermark informing you to drag and drop a column there to group by that column. It is possible to group by multiple columns simply by dragging a second ColumnHeader onto the grouping area.

Grouping and UnGrouping Spread at Runtime

When we talk about Grids in general there are few common features that come to mind, like Filtering , Sorting, Grouping, etc.

C1DataGrid Custom Grouping and Totals

In this blog post I demonstrate a few key features of the C1DataGrid control for WPF and Silverlight that help you build a grid like you see in Microsoft Outlook. First I will show you how to enable simple grouping aggregation, that is, I will show you how to display calculated totals on grouped rows. Then I will go a bit further and show how we can use traditional value converters to customize the appearance of grouped rows, aggregate values and even visualizing data as images.

Chart Grouping and Aggregation

The C1Chart control supports built-in grouping and aggregation. This allows you to display summarized data in a chart without the extra work of grouping the data yourself. In this blog post I’ll show you two ways you can take advantage of the built-in grouping and aggregation features found in ComponentOne Chart for WPF, Silverlight, Windows Phone and WinRT XAML.

ActiveReports : Reorder Groups Programmatically

Groups are created in any report to organize and summarize the data in a particular order. Grouping allows you to visually separate groups of records and hence enhance the readability of the report.

HowTo: Customize GroupHeaderRow in Spread for ASP.NET

Spread for ASP.Net provides built-in functionality to perform Grouping in Spread that allows users to group the data rows by a specific column. Use the AllowGroup property of the sheet to turn on grouping. The group header row by default displays the column index and the unique value in the column on the basis of which the specific group is created.

Group Legend Elements in C1Chart WPF

Grouping is one of the features which definitely makes data more readable/presentable to end users and also helps in quick analysis in some scenarios.

Control Group Row Selection in C1TrueDBGrid

Grouping is a common feature found in most of the grids. To apply grouping in C1TrueDBGrid all we need to do is set the DataView property of C1TrueDBGrid to GroupBy. Please refer to the following link to know more about it.

How To : Sort Column and Toggle Group through Code in WijGrid

WijGrid allows to interactively sort any column or expand/collapse any group. However, some customers have a requirement wherein they need to apply sorting on a specific column or toggle any particular group through code, based on some user action or manipulation.

How To: Grouping Report on Date Field

The extensive ActiveReports 7 API allows developers to completely control the report processing engine to fit their needs. Along with the simplicity of the design that allows the data to pass through quickly from processing to rendering, it provides the ability to present the report data in grouped format. Whether you need a simple listing or need a grouped view, ActiveReports is the solution. Basically, grouping refers to the segregation of data on the basis of a particular field of your data source.

Retain Selection on Sorting, Grouping and Filtering in C1DataGrid

We're often in a situation where we've selected a row and then as soon as we apply sorting or filtering on the grid, a row with different data gets selected. This is because selection works on the basis of row index in most of the Grid controls and it applies for C1DataGrid for Silverlight as well. So if we select the first row and apply sorting, grouping or filtering, we will observe that the first row remains selected. Now, suppose if we fetch the data of the selected row, we would get different data. This behavior will occur every time we apply any data operation on the grid. What do we do then!!

Avoid Orphaned ReportFooter with GroupFooter's NewPage property as "After"

Grouping is one of the most commonly used feature when it comes to designing a report. Its implementation can vary from one report to another based on the  requirements of the user. A very common scenario is starting each group from a new page. This helps in encapsulating the groups in one page or a range of pages, thus making it easier for a user to identify each group individually. The good thing here is that the GroupFooter section in ActiveReports provides a NewPage property which if set to "After", automatically starts the report from the next page, once the current group is completely rendered.

ActiveReports 7: Display a "continued..." Message When a Group Spans Across Pages

The Grouping feature of ActiveReports allows to group the data (keep them together) in a report. All you need is to set the Group Header section's DataField property to the field on which you want to group the report. When you run the report, it renders the group header, followed by all the related instances of detail section, and then the group footer (considering non-multiple grouping scenario). You can set one or more than one nested groups in a report, known as multiple grouping. You can find more information about this in Grouping Data topic in our documentation site.

Wijmo Gridview : Restoring Group States at Client Side

In my previous blog, I discussed how you can save the open group states when you have enabled server-side editing, as group states are lost when postback occurs. But, sometimes, you may have a situation where you need to refresh or redraw the grid at client side. At that time, you would face the same issue i.e. state of the opened groups are not retained.