Creating reports and dashboards | Stimulsoft community forum

Is there a way that I can find which records were grouped together in a group header?
I am trying to create a report that first groups like parts together based on part name and part size. These parts could come from different products, so after they are grouped I would like to display which products these parts came from.

For example:

Report output would be something like this:

QTY PART NAME PART SIZE PRODUCT #
4 Base Side 12x24 1.00, 2.00, 3.00, 4.00

The report found 4 Base Side parts that were the same size then displayed the which product those parts came from.

Anyway help would be great. Thanks in advanced.

Hi

You can use a GroupFooter instead of GroupHeader for this. Set the height of the GroupHeader and DataBand to 0 and in the BeforePrintEvent of the band you can calculate all values you need and display them in the GroupHeader.

If you need DataBand to be displayed then you can use two pass of the report engine. During the first pass you can calculate all values you need and in the second pass you can display calculated values.

To find out the current pass you can as follows:

this.IsFirstPass

Thank you.

I'm still a little confused on this. I am not sure how i would go about calculating the product numbers and displaying them. Since each product number is coming from a different record how do I go about getting each product number for each record and then putting them all together in one string.

Hi

In that case please feel free to send your report and data for it to support[at]stimulsoft.com for analysis. We will do our best to find a solution for you.

Thank you.