{"id":1555,"date":"2021-11-01T09:10:23","date_gmt":"2021-11-01T00:10:23","guid":{"rendered":"https:\/\/kintools.com\/?post_type=docs&#038;p=1555"},"modified":"2021-11-01T09:23:14","modified_gmt":"2021-11-01T00:23:14","password":"","slug":"groupingconditions","status":"publish","type":"docs","link":"https:\/\/kintools.com\/en\/docs\/groupingconditions\/","title":{"rendered":"Grouping conditions"},"content":{"rendered":"<p class=\"wp-block-paragraph\">To create a grouped report, you need to define the criteria by which records can be grouped. This condition is used to divide the data rows into appropriate groups and is set using the Condition property of the group header band.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/i.png\" width=\"11\" height=\"11\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 11px; --smush-placeholder-aspect-ratio: 11\/11;\">&nbsp;<strong>important:<\/strong>A condition must be defined for every group. Otherwise grouping will not occur in the rendered report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, if you create a report that generates a list of companies, you can group the results alphabetically by the first letter of the company name. As in the example below, companies with names starting with A are included in the first group, and companies with names starting with B are included in the second group.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"470\" height=\"348\" src=\"https:\/\/kintools.com\/wp-content\/uploads\/2021\/11\/img_group_condition1.png\" alt=\"\" class=\"wp-image-1559\" srcset=\"https:\/\/kintools.com\/wp-content\/uploads\/2021\/11\/img_group_condition1.png 470w, https:\/\/kintools.com\/wp-content\/uploads\/2021\/11\/img_group_condition1-300x222.png 300w, https:\/\/kintools.com\/wp-content\/uploads\/2021\/11\/img_group_condition1-16x12.png 16w, https:\/\/kintools.com\/wp-content\/uploads\/2021\/11\/img_group_condition1-81x60.png 81w, https:\/\/kintools.com\/wp-content\/uploads\/2021\/11\/img_group_condition1-122x90.png 122w\" sizes=\"(max-width: 470px) 100vw, 470px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The grouping criteria used can have any valid value. For example, if you want to group companies according to their location, you can set a condition to group by the database column that contains the required location data.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u30b0\u30eb\u30fc\u30d7\u5316\u3055\u308c\u305f\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001\u30ec\u30b3\u30fc\u30c9\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3067\u304d\u308b\u6761\u4ef6\u3092\u5b9a\u7fa9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u6761\u4ef6\u306f\u3001\u30c7 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"doc_category":[64],"doc_tag":[],"class_list":["post-1555","docs","type-docs","status-publish","hentry","doc_category-groups","entry"],"year_month":"2026-05","word_count":4,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"admin","author_nicename":"admin","author_url":"https:\/\/kintools.com\/en\/author\/admin\/"},"doc_category_info":[{"term_name":"\u30b0\u30eb\u30fc\u30d7","term_url":"https:\/\/kintools.com\/en\/docs-category\/groups\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/comments?post=1555"}],"version-history":[{"count":2,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1555\/revisions"}],"predecessor-version":[{"id":1560,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1555\/revisions\/1560"}],"wp:attachment":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/media?parent=1555"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_category?post=1555"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_tag?post=1555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}