Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Order Post Reply Post New Topic
Author Message
makemyday
Newbie
Newbie
Avatar

Joined: 09 May 2012
Online Status: Offline
Posts: 18
Quote makemyday Replybullet 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.

Thanks so much.






              
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.