Adding a UD field to a Crystal Report

Yahoo Archive
1
1. Custom RDD needs to include UD field

2. Report style needs to reference Custom RDD

3. Preview report using new report style

4. Open Crystal report and use ADO connection to xml from preview in 3

5. Verify Database (under the Database menu in Crystal) or set datasource location (same menu) and update between current connection last listed in bottom half of screen and top half of screen.

6. Make sure you see your fields in the field explorer in Crystal

7. Make sure you see your fields in xml file...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of altyrocks
Sent: Wednesday, July 25, 2012 1:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding a UD field to a Crystal Report



We have a custom Packing Slip designed in Crystal. I need to add a UD
field to this report. I see that a report style was created in the
report maintenance screen and a custom Crystal Report was created but
how do the 2 interact? I'm assuming Epicor creates an xml that the
report reads and then displays on the screen but I'm not sure what the
missing pieces are. Thanks in advance.

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



[Non-text portions of this message have been removed]
2
We have a custom Packing Slip designed in Crystal. I need to add a UD
field to this report. I see that a report style was created in the
report maintenance screen and a custom Crystal Report was created but
how do the 2 interact? I'm assuming Epicor creates an xml that the
report reads and then displays on the screen but I'm not sure what the
missing pieces are. Thanks in advance.


[Non-text portions of this message have been removed]
3
You're looking for the report data definition (RDD), add your UD field
there. Browse through report tables in that screen, excluded fields
tab, and move it from the excluded to included side. The report style
screen links the RDD (which generates the XML) to the crystal report.
You'll need to preview the report once with the new RDD before you can
add that field to the crystal report. For more details, look in the ICE
Tools book.



Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of altyrocks
Sent: Wednesday, July 25, 2012 2:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding a UD field to a Crystal Report





We have a custom Packing Slip designed in Crystal. I need to add a UD
field to this report. I see that a report style was created in the
report maintenance screen and a custom Crystal Report was created but
how do the 2 interact? I'm assuming Epicor creates an xml that the
report reads and then displays on the screen but I'm not sure what the
missing pieces are. Thanks in advance.

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





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