Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Combining Data in a Single Report Post Reply Post New Topic
Author Message
jgarner
Senior Member
Senior Member


Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Quote jgarner Replybullet Topic: Combining Data in a Single Report
    Posted: 24 Nov 2009 at 8:59am
Is it possible to create a report that combines data regarding the following:
 
Labor (Date, Emp. Name, Classification, Hourly wage, # of hours, Total, Description of work, etc)
 
Material (Date, Description, Qty, Cost, Total, Use of material, etc)
 
These would have to be grouped separately with two separate description headers. Also, there is a relationship between the two groups with a work order number. However, it is not a one to one relationship, since there will be more labor than material in most cases.
 
I have tried to use a subreport, but haven't been successful with it. Should I keep working with the subreports, try something different, or place them in separate reports? 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 25 Nov 2009 at 6:17am
as long as they are related, a report can be built, the question is one of layout.  when you mean grouped entirely separately by the 2 'reports' are on the same page, but the data doesn't intertwine...or labor (then all the materials used)  or something like that.  If they don't intertwine, a subreport in the report footer would give that appearance, if they intertwine, perhaps a subreport, perhaps not...I try and avoid subreports as they are expensive in overhead, but sometimes that is the only to get the report.
 
HTH
IP IP Logged
jgarner
Senior Member
Senior Member


Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Quote jgarner Replybullet Posted: 25 Nov 2009 at 6:27am
I have tried using a subreport in the footer of the report, but it usually interferes with the data in the 'Details Section'. It must be a relationship issue I need to work with because once I add in the subreport to the footer, it doubles the data in the 'Details Section'.
Thanks for your help.
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.