OK. Good news my version was Ok and I was the problem. They sent me the below output and once I selected the Relationship Type as OUTPUT the table information began to pull through onto the XML. I had it setup before as 'Definition only'.
RESOLUTION:
Troubleshooting missing information in Crystal Reports.
The place to start troubleshooting and the first thing to check is the XML. The XML must have the information in it for it to appear in a report.
If you have added a table and/or field to a Report Data Definition (RDD) you need to check the XML before troubleshooting the report itself. If you see the table you added in the XML it will look like the following:
<part> OR <orderhed> OR <shipdtl> The table shouldn't have anything else on the same line.
XML EXAMPLE:
<OrderHed> This is the table
<RptLanguageID>enu</RptLanguageID> These are fields in the table w/data in between
<AddlHdlgFlag>false</AddlHdlgFlag>
<AutoPrintReady>false</AutoPrintReady>
<CardNumber>######-######1111</CardNumber>
<CCAmount>5625</CCAmount>
<CCDocAmount>12500</CCDocAmount>
<CCDocFreight>0</CCDocFreight>
<CCDocTax>2875</CCDocTax>
<CCDocTotal>15375</CCDocTotal>
<CCFreight>0</CCFreight>
If you can't find the table and/or field in the XML then go back to the Report Data Definition (RDD) and retrace your steps. Also, if you don't see your information in the XML it could be because the RDD needs a relationship between the table you added and one that already exists in the RDD. Click on the Relationship tab in the RDD and click on Help > Application Help to get instructions on how to create a relationship here. Generate the XML again and check to see if it contains the data you need.
PLEASE NOTE: If all else fails please try creating your relationship using the COMPANY table as the PARENT, the COMPANY field as the KEY, and YOUR added table as the child. Make sure you select OUTPUT in the Relationship Type: IF NO DATA APPEARS... please contact Technical Support. (Option 3, Option 1 on the phone tree) and report it to us so we can provide that information to Development.
When you see the information you need in the XML then move to the Crystal Report.
If your information appears in the XML and not in the report then it's most likely a linking issue in Crystal. Go back to the linking page and make sure all your tables are linked correctly. The automatic linking you see in a Crystal report are only "suggested linking". It may not be correct.
RESOLUTION:
Troubleshooting missing information in Crystal Reports.
The place to start troubleshooting and the first thing to check is the XML. The XML must have the information in it for it to appear in a report.
If you have added a table and/or field to a Report Data Definition (RDD) you need to check the XML before troubleshooting the report itself. If you see the table you added in the XML it will look like the following:
<part> OR <orderhed> OR <shipdtl> The table shouldn't have anything else on the same line.
XML EXAMPLE:
<OrderHed> This is the table
<RptLanguageID>enu</RptLanguageID> These are fields in the table w/data in between
<AddlHdlgFlag>false</AddlHdlgFlag>
<AutoPrintReady>false</AutoPrintReady>
<CardNumber>######-######1111</CardNumber>
<CCAmount>5625</CCAmount>
<CCDocAmount>12500</CCDocAmount>
<CCDocFreight>0</CCDocFreight>
<CCDocTax>2875</CCDocTax>
<CCDocTotal>15375</CCDocTotal>
<CCFreight>0</CCFreight>
If you can't find the table and/or field in the XML then go back to the Report Data Definition (RDD) and retrace your steps. Also, if you don't see your information in the XML it could be because the RDD needs a relationship between the table you added and one that already exists in the RDD. Click on the Relationship tab in the RDD and click on Help > Application Help to get instructions on how to create a relationship here. Generate the XML again and check to see if it contains the data you need.
PLEASE NOTE: If all else fails please try creating your relationship using the COMPANY table as the PARENT, the COMPANY field as the KEY, and YOUR added table as the child. Make sure you select OUTPUT in the Relationship Type: IF NO DATA APPEARS... please contact Technical Support. (Option 3, Option 1 on the phone tree) and report it to us so we can provide that information to Development.
When you see the information you need in the XML then move to the Crystal Report.
If your information appears in the XML and not in the report then it's most likely a linking issue in Crystal. Go back to the linking page and make sure all your tables are linked correctly. The automatic linking you see in a Crystal report are only "suggested linking". It may not be correct.
--- In vantage@yahoogroups.com, "Barry Gibson" <bgibson@...> wrote:
>
> I'm on Epicor 9.05.601b and experiencing the same issues. No customised link table is pulling through. Just worried I might be doing something wrong as according to these posts it was resolved in this version. I've put a support call in so they can confirm either way. Will let you all know.
>
> Barry Gibson
> ICT Manager
> Cullen Building Products
>
> --- In vantage@yahoogroups.com, Keith Mailloux <keith.mailloux@> wrote:
> >
> > We are using 9.05.5601B and it works fine. There are a few tricks like including the linked fields in your included fields.
> >
> > Keith Mailloux
> > Ferguson Perforating
> > (401)941-8876 Ext 2238
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hellings, Lauren
> > Sent: Wednesday, January 19, 2011 4:58 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Adding a linked table in report data maintenance
> >
> >
> >
> > While testing in 602A I found that I was able to add tables to the RDD, but that the built in linked tables still did not work. Have you tested that functionality? Specifically, I was trying to add the Ship To address to the Quote form.
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Brian Roberts
> > Sent: Wednesday, January 19, 2011 3:49 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Adding a linked table in report data maintenance
> >
> > My thanks for this reply, and for this group in general. Fast, accurate
> > responses - I'm amazed and happy
> >
> > <mode="grumpy">
> >
> > I submitted a support call to Epicor the same day I asked about the
> > issue below. I later added the detail below, and asked "is this my
> > problem too?" The response eventually came back as "bug reproduced in
> > 602A, we'll submit to development, blah, blah, more delays". But in the
> > time that call took to process I had upgraded to 602A, and my problem is
> > fixed.
> >
> > </mode>
> >
> > Thanks again,
> >
> > Brian.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
> > Of Brian Roberts
> > Sent: Friday, January 07, 2011 3:17 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Adding a linked table in report data maintenance
> >
> > Oh! And we're on 9.05.600C. Thanks for the info, I've spent far too
> > long scratching my head wondering what I was doing wrong. Updating (to
> > 9.05.602A I think) is on my todo list, I guess it just jumped up in
> > priority :-(
> >
> > Thanks,
> >
> > Brian.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > Of Hellings, Lauren
> > Sent: Friday, January 07, 2011 3:06 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Adding a linked table in report data maintenance
> >
> > Support has identified a known issue within 9.05 preventing users from
> > adding tables to the data definition. Basically the new table
> > information does not get passed to the XML file. The linked tables
> > feature does not work either. You can only add fields to a data
> > definition if they already exist in a report table, but are hidden. I
> > found this information out at the Advanced Crystal Reports training
> > class. Even the instructor was not aware of this issue. It has been
> > resolved in 601 and of course 602 as well.
> >
> > Thank you,
> >
> > Lauren Hellings
> > CPI Global One - Core Team Member
> > [cid:image001.jpg@<mailto:image001.jpg%4001CBAE74.0F7B0170><mailto:image001.jpg%4001CBAE74.0F7B0170>
> > <mailto:image001.jpg%4001CBAE74.0F7B0170>
> > <mailto:image001.jpg%4001CBAE74.0F7B0170> ]
> >
> > Business Analyst
> > Office: 281-207-0667 x26
> > Cell: 832-472-1736
> > Fax: 281-207-0672
> > email: lauren.hellings@<mailto:lauren.hellings%40c-p-i.com><mailto:lauren.hellings%40c-p-i.com> <mailto:lauren.hellings%40c-p-i.com>
> > <mailto:lauren.hellings%40c-p-i.com>
> > <mailto:lauren.hellings@<mailto:lauren.hellings%40c-p-i.com><mailto:lauren.hellings%40c-p-i.com> <mailto:lauren.hellings%40c-p-i.com>
> > <mailto:lauren.hellings%40c-p-i.com> >
> > www.c-p-i.com<http://www.c-p-i.com/>
> >
> > [cid:image002.jpg@<mailto:image002.jpg%4001CBAE74.0F7B0170><mailto:image002.jpg%4001CBAE74.0F7B0170>
> > <mailto:image002.jpg%4001CBAE74.0F7B0170>
> > <mailto:image002.jpg%4001CBAE74.0F7B0170> ]
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of Brian Roberts
> > Sent: Friday, January 07, 2011 9:42 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Adding a linked table in report data maintenance
> >
> > I am modifying a report data definition in 9.05 with the goal of
> > changing the BOL form to include data from linked packing slips instead
> > of the BOL detail table. But I can't seem get any data from the
> > ShipHead table on the report/XML file, and feel like I'm missing a step
> > somewhere. Hoping for some advice...
> >
> > [snip]
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> > ----------Legal Disclaimer----------
> >
> > The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ---------------------------------
> > This e-mail and any attachments may contain confidential and
> > privileged information. If you are not the intended recipient,
> > please notify the sender immediately by return e-mail, delete this
> > e-mail and destroy any copies. Any dissemination or use of this
> > information by a person other than the intended recipient is
> > unauthorized and may be illegal.
> >
> > [Non-text portions of this message have been removed]
> >
>