Print Page | Close Window

Order

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21260
Printed Date: 03 Apr 2025 at 5:26pm


Topic: Order
Posted By: makemyday
Subject: Order
Date 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.






              



Replies:
Posted By: lockwelle
Date 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.



Print Page | Close Window