Creating reports and dashboards | Stimulsoft community forum

Is it possible to have a row count in a group header? If so, how would one put it out?

For example, if the DataSource consist of something like this:

ProductId = 1, ReceiptId = 1
ProductId = 1, ReceiptId = 1
ProductId = 1, ReceiptId = 1
ProductId = 1, ReceiptId = 3
ProductId = 1, ReceiptId = 3
ProductId = 1, ReceiptId = 5

And there's a grouping by ReceiptId the detail would result in only three rows

ProductId = 1, ReceiptId = 1, Count 3
ProductId = 1, ReceiptId = 3, Count 2
ProductId = 1, ReceiptId = 5, Count 1

What I'd like to do is to add another grouping on top of this one with condition ProductId, and put out a count there which indicates that Product 1 has 3 receipts (grouped rows) in the grouping below. Is this possible?

Thanks in advance!

Hello,

You can use the grouping and Count(GroupBand, Column) function, or use the DataTransformation source for grouping and count calculation.

Thank you.