Warm tip: This article is reproduced from stackoverflow.com, please click
grouping crystal-reports report

Create a group from two columns

发布于 2020-03-29 20:59:37

I have this:

Column1  Column2  Column3
Water    1        2€
Water    2        3€
Water    2        5€
Milk     1        8€
Milk     1        4€
Milk     2        10€
Milk     3        1€

I am trying to group a column and sum the column to the side referring to the price.

And I want this:

Column1  Column2  Column3
Water    1        2€
Water    2        8€
Milk     1        12€
Milk     2        10€
Milk     3        1€

How can I do this?

Questioner
Raul Reis
Viewed
55
分享
MatSnow 2020-01-31 18:17

Assuming that the datatype of Column2 is numeric, create a formula-field with the following content and then create a group from this field:

{Table.Column1} + "###" + CStr({Table.Column2})

Now just create the sum for Column3.

If necessary, change the string ### to something else, that will not appear in Column1 and Column2.

Related issues

1
Blank space at the top of the thermal printer on bills
2
Using item value as part of the select code
3
How to hide reports from print menu in odoo 14?
4
How to prevent blob + guid in browser title
5
Power BI Report with Bridge Table
6
How to encrypt & decrypt amazon seller api report document using nodejs
7
Is there a way to have the Staff Code and Name on a Single Row in an SSRS table
8
Jacoco Maven multi module project coverage
9
Number format a decimal in Birt reports
10
NetSuite List of Items by Bin