Grouped Records

Stimulsoft Reports.NET discussion
Post Reply
dpeel2757
Posts: 19
Joined: Fri Feb 29, 2008 6:09 pm

Grouped Records

Post by dpeel2757 »

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.
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Grouped Records

Post by Edward »

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.
dpeel2757
Posts: 19
Joined: Fri Feb 29, 2008 6:09 pm

Grouped Records

Post by dpeel2757 »

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.
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Grouped Records

Post by Edward »

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.
Post Reply