Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Having trouble figuring out structure of my report Post Reply Post New Topic
Author Message
Hammerklavier
Newbie
Newbie


Joined: 24 Oct 2011
Online Status: Offline
Posts: 24
Quote Hammerklavier Replybullet Topic: Having trouble figuring out structure of my report
     Posted: 18 Nov 2011 at 2:57am
Hi,
 
I know what I want my report to look like, but I'm very new to Crystal Reports XI (and Crystal Reports in general) and I'm having trouble getting started on a report.
 
Basically, here's a prototype for how it would need to look:
 
****
 
SALES ORDER
(Fields containing general information related to this sales order)
 
MAIN ITEM
(Fields containing information related to the main item that corresponds to the sales order)
 
ACCESSORIES
(Fields containing information related to items that correspond to the main item of this sales order)
 
CODES
(Fields containing codes corresponding to the main item.  This needs to be in its own area apart from the Main Item)
 
****
 
Depending on the values of the parameters the user enters when running the report, there could be multiple sales orders listed.  Which sales orders are shown are based on those parameters. 
 
The Main Item and Accessories columns would contain the same fields, but the records shown are based on the item type ("main" or "accessory").
 
Any help here would be greatly appreciated.  I guess I'm getting mixed up when it comes to organizing groups, sections, etc...
 
Thank you,
 
Hammerklavier
IP IP Logged
Hammerklavier
Newbie
Newbie


Joined: 24 Oct 2011
Online Status: Offline
Posts: 24
Quote Hammerklavier Replybullet Posted: 18 Nov 2011 at 6:34am
Is this kind of structure not possible in Crystal Reports?
 
Any ideas on how you would approach this?  Sorry, I'm really lost on this.
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 18 Nov 2011 at 10:06am
you could try to create sub-reports for each of those fields
and then put those sub-reports into report footer(might need to create multiple report footers(right click on empty field in design view then click selection expert then select report footer then click insert) ) create parameters that you need in each sub-report and link them to the main report if needed(right click on sub_report then click on change subreport links....)
IP IP Logged
Hammerklavier
Newbie
Newbie


Joined: 24 Oct 2011
Online Status: Offline
Posts: 24
Quote Hammerklavier Replybullet Posted: 21 Nov 2011 at 8:09am

Kostya112,

 
Thank you for the response.  I will try this.
 
Hammerklavier
IP IP Logged
Memoli28
Groupie
Groupie
Avatar

Joined: 10 Apr 2009
Online Status: Offline
Posts: 58
Quote Memoli28 Replybullet Posted: 22 Nov 2011 at 12:53am
Hi kostya,
 
if you are retrieving data from several files, because in some files data is stored on order-level, some on  productlevel..etc.
 
this is what i do most of the time:
create groupings and your report will have a clear structure.
 
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.