Crystal Report - Production Detail Report (PDR)

Yahoo Archive
1
Thanks for everybody's response.  The field was actually the supplier PO number from the InvcHead.PONum

So, I added the table in the RDD and created a link between the InvcDtl and InvcHead table, and walla!  works great.

Thanks.
2

I'm trying to insert the PODetail/POHeader table fields into this report.  Need a little assistance on the steps.  I'm working with the "Report Table Definitions," to try and accomplish.  I've inserted the table in the definition and it populates on the XML report in Crystal, but there's no data.  Not sure if a relationship is required in the definition that I'm missing.  


Thanks.

3

Do you have a relationship defined for each new table?  If so, then select each table and go to the tab shown as Excluded Fields (in 8.03.409c) and move some fields that you want to include to the left side where it shows a list of Included Report Fields.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 02, 2014 3:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report - Production Detail Report (PDR)

 

 

I'm trying to insert the PODetail/POHeader table fields into this report.  Need a little assistance on the steps.  I'm working with the "Report Table Definitions," to try and accomplish.  I've inserted the table in the definition and it populates on the XML report in Crystal, but there's no data.  Not sure if a relationship is required in the definition that I'm missing.  

 

Thanks.

4
You are saying that the table/fields appear in crystal but there is no data being displayed? 

In crystal in the field explorer right click the fields you added and click 'Browse Data' this will show you the data for this field, I am assuming there is data to be displayed inside the report. If it shows data in the browse data window but is not displaying in the report then you probably have an issue with the linking in your crystal report (in crystal: Database > Database Expert > Links). If you right click and browse the data and it is blank then you may have an issue with the linking in the RDD. 

Hope this helps.
5

It also sounds like if you have groups in your report and the field you are trying to display in not in that group data, the whole document will go blank.

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 03, 2014 7:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report - Production Detail Report (PDR)

 

 

You are saying that the table/fields appear in crystal but there is no data being displayed? 

 

In crystal in the field explorer right click the fields you added and click 'Browse Data' this will show you the data for this field, I am assuming there is data to be displayed inside the report. If it shows data in the browse data window but is not displaying in the report then you probably have an issue with the linking in your crystal report (in crystal: Database > Database Expert > Links). If you right click and browse the data and it is blank then you may have an issue with the linking in the RDD. 

 

Hope this helps.

6
In the report data definition you need to create relationships with the newly added tables. What table are you wanting to link the POHeader/Detail table to? After you do this, you also need to add the table(s) to the reportdataset in crystal reports.

From: "sanfranc415@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, July 2, 2014 4:33 PM
Subject: [Vantage] Crystal Report - Production Detail Report (PDR)



I'm trying to insert the PODetail/POHeader table fields into this report.  Need a little assistance on the steps.  I'm working with the "Report Table Definitions," to try and accomplish.  I've inserted the table in the definition and it populates on the XML report in Crystal, but there's no data.  Not sure if a relationship is required in the definition that I'm missing.  

Thanks.




7
Thanks for all the feedback.  I've already added the table and relationships, but not sure what relationships are required to have the PONum show up on the PDR?  

While in Crystal the table and all the fields show up, but there is no data.  I'm pretty sure this starts with the definition.  I've created a link between the PODetail -> JobProd Ordernum for both. 

Is there another way to display the PONum if an expedite charge is issued for a job and has a PO associated with it? 
8
JobProd.OrderNum is not a PO number, it is a sales order number.

From: "sanfranc415@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Thursday, July 3, 2014 1:58 PM
Subject: [Vantage] Re: Crystal Report - Production Detail Report (PDR)

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 #ygrps-yiv-516466254yiv6662658345 --

#ygrps-yiv-516466254yiv6662658345 .ygrps-yiv-516466254yiv6662658345ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345photo-title
a,
#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345photo-title a:active,
#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345photo-title a:hover,
#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345attach-table div.ygrps-yiv-516466254yiv6662658345attach-row {
clear:both;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345attach-table div.ygrps-yiv-516466254yiv6662658345attach-row div {
float:left;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345ygrp-file {
width:30px;}
#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345attach-table div.ygrps-yiv-516466254yiv6662658345attach-row div div a {
text-decoration:none;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345attach-table div.ygrps-yiv-516466254yiv6662658345attach-row div div span {
font-weight:normal;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 div.ygrps-yiv-516466254yiv6662658345ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-516466254
#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 #ygrps-yiv-516466254yiv6662658345 –
#ygrps-yiv-516466254yiv6662658345ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 #ygrps-yiv-516466254yiv6662658345ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 #ygrps-yiv-516466254yiv6662658345ygrp-mkp #ygrps-yiv-516466254yiv6662658345hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 #ygrps-yiv-516466254yiv6662658345ygrp-mkp #ygrps-yiv-516466254yiv6662658345ads {
margin-bottom:10px;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 #ygrps-yiv-516466254yiv6662658345ygrp-mkp .ygrps-yiv-516466254yiv6662658345ad {
padding:0 0;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 #ygrps-yiv-516466254yiv6662658345ygrp-mkp .ygrps-yiv-516466254yiv6662658345ad p {
margin:0;}

#ygrps-yiv-516466254 #ygrps-yiv-516466254yiv6662658345 #ygrps-yiv-516466254yiv6662658345ygrp-mkp .ygrps-yiv-516466254yiv6662658345ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-516466254



Thanks for all the feedback.  I’ve already added the table and relationships, but not sure what relationships are required to have the PONum show up on the PDR?  


While in Crystal the table and all the fields show up, but there is no data.  I’m pretty sure this starts with the definition.  I’ve created a link between the PODetail -> JobProd Ordernum for both. 

Is there another way to display the PONum if an expedite charge is issued for a job and has a PO associated with it?