Joined: 09 May 2012
Online Status: Offline
Posts: 18
Topic: Order Posted: 07 Jan 2015 at 4:04am
My form uses an XML, I have my form set as:
Page Header
Group Header 1
Group header 2
Detail a- Bold Line 1
Detail b- subform with a part number and descriptions on next lines, as many lines as needed.
Detail c- Bold line 2
Detail e- subform with more information about the part number with as many lines as needed
Detail f- Bold line 3
I would like it to look like this:
Detail a PART NUMBER
Detail b 1007002
Description
More Description
Detail c QUANTITY
Detail d Quantity information
Detail e BOLD total
Detail a PART NUMBER
Detail b 1007003
Description
More Description
Detail c QUANTITY
Detail d Quantity information
Detail e BOLD total
Detail a PART NUMBER
Detail b 1007004
Description
More Description
Detail c QUANTITY
Detail d Quantity information
Detail e BOLD total
Report footer a to print at the bottom of last page
Report footer b to print on next page
What I get is:
Detail a PART NUMBER
Detail b 1007002
Description
More Description
1007003
Description
1007004
Description
Detail c QUANTITY
Detail d Quantity info for 1007002
Quantity info for 1007003
Quantity info for 1007004
Detail e DETAIL Total
How do I set it up so that each Part Number is printed followed by each Quantity info.
I don't know much about grouping or formulas, if this is what it needs, so I could use some help.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 09 Jan 2015 at 5:05am
it would seem that the issue is a join...I am guessing the quantity is a subreport and that the link is off, so that it is return information on all items, not just the item it is supposed.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum