Crystal Reports and Epicor 9

Yahoo Archive
1
The Part table is under Linked Tables for the ShipDtl table.



Under Report Tables> Linked tables > Description fields - from the dropdown
pick the Part table and the ECCN is listed.



I will checked linked tables anytime info is needed from another table. It
seems when you started adding tables it makes the Crystal report slow.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jckinneman
Sent: Thursday, January 24, 2013 9:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports and Epicor 9





You probably don't need to do a table link. The part table fields are
probably available on the Linked Tables Tab in RDD, from there you can add
the fields from the part table.

If that is not available how did you link the part table (what fields form
the link) in the RDD?

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "De Anna
McNeal" wrote:
>
> I have an issue with Crystal Reports that I am hoping someone knows the
> answer to.
>
> I have modified the Packing Slip Report to include the Part Table with the
> ECCN and HTS field. I need these to print on the packing slip. I have the
> Part table linked to the ShipDtl table. It is an inner join.
>
> Everything works fine except when I have a packing slip which has multiple
> releases of the same part number. For example, if I had 3 packing slip
> lines all for the same PN, it triples the information for the ECCN
> information. So instead of having 3 line items, I have a total of 9. Line
1
> shows 3 times, Line 2 shows 3 times, and Line 3 shows 3 times.
>
> I currently have this information in the detail section.
>
> If I move it to the Group Header section then it only shows once but the
> shipped quantity is 3x the actual shipped qty.
>
> Does anyone have any ideas? Thank you.
>
> De Anna Mirzadegan
> McNeal Enterprises, Inc.
> Custom Plastic Design, Machining, Fabricating, Thermoforming, & Assembly
> www.mcneal.com
> 408-922-7290
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
I have an issue with Crystal Reports that I am hoping someone knows the
answer to.

I have modified the Packing Slip Report to include the Part Table with the
ECCN and HTS field. I need these to print on the packing slip. I have the
Part table linked to the ShipDtl table. It is an inner join.

Everything works fine except when I have a packing slip which has multiple
releases of the same part number. For example, if I had 3 packing slip
lines all for the same PN, it triples the information for the ECCN
information. So instead of having 3 line items, I have a total of 9. Line 1
shows 3 times, Line 2 shows 3 times, and Line 3 shows 3 times.

I currently have this information in the detail section.

If I move it to the Group Header section then it only shows once but the
shipped quantity is 3x the actual shipped qty.

Does anyone have any ideas? Thank you.

De Anna Mirzadegan
McNeal Enterprises, Inc.
Custom Plastic Design, Machining, Fabricating, Thermoforming, & Assembly
www.mcneal.com
408-922-7290



[Non-text portions of this message have been removed]
3
Check your database links. This happens to me when I have added a table
but not defined the links correctly in Database -> Database Expert -> Links.



*Tanya Denison* | IT Manager | NRS, Inc.

*2009 S. Main Street, Moscow, ID 83843*



*tdenison@... *|* www.nrsweb.com*

*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*



*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
Of *De Anna McNeal
*Sent:* Thursday, January 24, 2013 4:20 PM
*To:* vantage@yahoogroups.com
*Subject:* [Vantage] Crystal Reports and Epicor 9





I have an issue with Crystal Reports that I am hoping someone knows the
answer to.

I have modified the Packing Slip Report to include the Part Table with the
ECCN and HTS field. I need these to print on the packing slip. I have the
Part table linked to the ShipDtl table. It is an inner join.

Everything works fine except when I have a packing slip which has multiple
releases of the same part number. For example, if I had 3 packing slip
lines all for the same PN, it triples the information for the ECCN
information. So instead of having 3 line items, I have a total of 9. Line 1
shows 3 times, Line 2 shows 3 times, and Line 3 shows 3 times.

I currently have this information in the detail section.

If I move it to the Group Header section then it only shows once but the
shipped quantity is 3x the actual shipped qty.

Does anyone have any ideas? Thank you.

De Anna Mirzadegan
McNeal Enterprises, Inc.
Custom Plastic Design, Machining, Fabricating, Thermoforming, & Assembly
www.mcneal.com
408-922-7290


[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
4
You probably don't need to do a table link. The part table fields are probably available on the Linked Tables Tab in RDD, from there you can add the fields from the part table.

If that is not available how did you link the part table (what fields form the link) in the RDD?

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "De Anna McNeal" wrote:
>
> I have an issue with Crystal Reports that I am hoping someone knows the
> answer to.
>
> I have modified the Packing Slip Report to include the Part Table with the
> ECCN and HTS field. I need these to print on the packing slip. I have the
> Part table linked to the ShipDtl table. It is an inner join.
>
> Everything works fine except when I have a packing slip which has multiple
> releases of the same part number. For example, if I had 3 packing slip
> lines all for the same PN, it triples the information for the ECCN
> information. So instead of having 3 line items, I have a total of 9. Line 1
> shows 3 times, Line 2 shows 3 times, and Line 3 shows 3 times.
>
> I currently have this information in the detail section.
>
> If I move it to the Group Header section then it only shows once but the
> shipped quantity is 3x the actual shipped qty.
>
> Does anyone have any ideas? Thank you.
>
> De Anna Mirzadegan
> McNeal Enterprises, Inc.
> Custom Plastic Design, Machining, Fabricating, Thermoforming, & Assembly
> www.mcneal.com
> 408-922-7290
>
>
>
> [Non-text portions of this message have been removed]
>
5
Hello tanya,
Check on the Report grouping make sure that you place the fields on the logical group so as to appear correctly as desired. Also review you link btwn the ShipTable and part table.





________________________________
From: Tanya Denison <tdenison@...>
To: vantage@yahoogroups.com
Sent: Friday, January 25, 2013 3:28 AM
Subject: RE: [Vantage] Crystal Reports and Epicor 9

Check your database links. This happens to me when I have added a table
but not defined the links correctly in Database -> Database Expert -> Links.



*Tanya Denison* | IT Manager | NRS, Inc.

*2009 S. Main Street, Moscow, IDÂ 83843*



*tdenison@... *|* www.nrsweb.com*

*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*



*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
Of *De Anna McNeal
*Sent:* Thursday, January 24, 2013 4:20 PM
*To:* vantage@yahoogroups.com
*Subject:* [Vantage] Crystal Reports and Epicor 9





I have an issue with Crystal Reports that I am hoping someone knows the
answer to.

I have modified the Packing Slip Report to include the Part Table with the
ECCN and HTS field. I need these to print on the packing slip. I have the
Part table linked to the ShipDtl table. It is an inner join.

Everything works fine except when I have a packing slip which has multiple
releases of the same part number. For example, if I had 3 packing slip
lines all for the same PN, it triples the information for the ECCN
information. So instead of having 3 line items, I have a total of 9. Line 1
shows 3 times, Line 2 shows 3 times, and Line 3 shows 3 times.

I currently have this information in the detail section.

If I move it to the Group Header section then it only shows once but the
shipped quantity is 3x the actual shipped qty.

Does anyone have any ideas? Thank you.

De Anna Mirzadegan
McNeal Enterprises, Inc.
Custom Plastic Design, Machining, Fabricating, Thermoforming, & Assembly
www.mcneal.com
408-922-7290


[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]