Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help Detail section fixed rows!!

Status
Not open for further replies.

crustas

IS-IT--Management
Feb 10, 2002
6
GR
Hello

I have a problem in seting the max number of rows in the detail section. I have N (N can take any value bigger than zero) components for each product_id , but i want to split in to groups of 8 (for labeling purposes). I've have tried several aproaches to this problems and nothing it keeps the same, show allways all the rows not only 8 as i pretended. I would like that someone could bring me some light to the problem.

For example for a product_id with 15 rows of subcomponents:

What i have
LABEL NUMBER 1
product id (product header)
xxxxxxxxx
components (detail section)
1 xxxxxx
2 xxxxxx
...
15 xxxxxx

what i want
LABEL NUMBER 1
product id (product header)
xxxxxxxxx
components (detail section)
1 xxxxxx
2 xxxxxx
...
8 xxxxxx

LABEL NUMBER 2
product id (product header)
xxxxxxxxx
components (detail section)
9 xxxxxx
10 xxxxxx
...
15 xxxxxx


Thanks in advance
Crustas
 
Open the report and select the sorting/grouping button.
1. Enter the field you want to group(e.g. Label Number)
2. Under the group on select "interval"
3. Under the group interval select "8"
4. Under the Keep together select "with first detail"

Hope this works...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top