Adding a table to a duplicated data definition and bringing it through to crystal report

Epicor ERP 9
1

Hi, we are using epicor 9.05.700

I have a duplicated data definition for a pack slip crystal report…i am trying to add the table CUSTCNT…the relationships are COMPANY, CUSTNUM, SHIPTONUM and then CONNUM goes with SHPCONNUM…(Note, this generates data perfectly in a BAQ).

I create a new XML file and then when i bring the table through into crystal report writer, it returns blanks for that entire table…(i have checked this packslip and it should create data). I also make the joins an outer join in crystal (which they should be).

Does a BAQ drive the definition that i need to update maybe?

Any advice would be much appreciated.

Thanks.
Mark

2

Sorry, the 2 tables i’m joining are:PARENT TABLE: SHIPDTLCHILD: CUSTCNT

3

When everything turns blank in crystal that means that your tables are joining to a null value on a INNER JOIN. Consider checking your joins. Do you see the new data in the XML?

4

Hi, i was only able to turn the joins for that connection in crystal to LEFT JOINS…the OUTER JOINS was not highlighted.
The new data is not seen in the XML text.
Thanks.

5

Ok if the new data is not in the XML that means your joins in the RDD aren’t functioning properly. Did you set the relationship as output?

6

Pasted image790×642 29.1 KB

7

Definition only won’t do it, you need to change the relationship type to Output… otherwise there will be now data in your XML.

2 Likes
8

ok, thank you, - i’ll give it a go

9

Hi, the data now appears in the XML…!! Thank you.
So i guess - just now load the new XML into crystal?
Is there anything else?
Many thanks so much for your help.

10

Make sure you also update the table links in Database Expert in Crystal. Since you added a new table you will need to bring the new table into the Report Data Set so you can add needed fields to your report.

Kristine Fierce
Business Systems Analyst
Ag Leader Technology

11

Right load the new XML on Crytal, Refresh the Data Definition, Drag in the new table establish joins and that’s all she said

12

hi guys, thank you for your help

Here is where i am…now in crystal, i can right click on the field in the new table and “browse data”…it sees the data.
But when i drag the field onto the report it just shows blank.
Haven’t seen this before.

Thanks.

Mark

13

Again this is your join, the join between your new table and the existing Crystal Stuff is not right. What does that join look like?

14

Pasted image1533×791 20.9 KB

15

so, joins are “left outer” from Shipdtl to custcnt…i can’t select full outer as its greyed out.

16

What fields are mapped?

17

18

Don’t use the Report Langauge Field that one causes issues… Just Company, Custnum and ConNum

19

yep! that did it!!!
thank you so much for your help!

Merry christmas…i’m happy now…and built a bit of knowledge base!

thanks again
Mark

1 Like