No data Blank Title 67256

[system]

Karl, I didn't have to. Dale's response lays out a better solution without adding the table to the definition.


Ken

________________________________




----- Original Message ----
From: Karl Dash <dashkarl@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 24, 2008 2:33:56 PM
Subject: Re: [Vantage] no data


Ken,
Did you establish the relationship of the Part table to OrderDtl in the report definition?

--- On Thu, 7/24/08, Ken Taylor <ktaylorv@yahoo. com> wrote:

From: Ken Taylor <ktaylorv@yahoo. com>
Subject: [Vantage] no data
To: vantage@yahoogroups .com
Date: Thursday, July 24, 2008, 9:41 AM

To all Crystal gurus:

I'm attempting to modify the Order Acknowledgement with data from the Parts table UDF. I've added the table to the Report definition, created the new report style. In Crystal I can see the Parts table and add the fields to the report, however there is no data shown. The link is with PartNum from OrderDtl and Parts table as left outer join. All other data shows except the fields from Parts. Can anyone make suggestions? Thanks for your input.

Ken

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

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






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

[system]

To all Crystal gurus:

I'm attempting to modify the Order Acknowledgement with data from the Parts table UDF. I've added the table to the Report definition, created the new report style. In Crystal I can see the Parts table and add the fields to the report, however there is no data shown. The link is with PartNum from OrderDtl and Parts table as left outer join. All other data shows except the fields from Parts. Can anyone make suggestions? Thanks for your input.


Ken





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

[system]

First step is to determine where the problem is.



Is the data in the XML? If it is then it is a Crystal issue. If not
you have a Report Definition issue.



Did you define the outer join in both Report Definition and Crystal?



Dale



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] no data



To all Crystal gurus:

I'm attempting to modify the Order Acknowledgement with data from the
Parts table UDF. I've added the table to the Report definition, created
the new report style. In Crystal I can see the Parts table and add the
fields to the report, however there is no data shown. The link is with
PartNum from OrderDtl and Parts table as left outer join. All other data
shows except the fields from Parts. Can anyone make suggestions? Thanks
for your input.

Ken

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





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

[system]

Dale, I defined it in Crystal. Where exactly do you do it in the Report Definition? When I go there, there is absolutely no relationship established for any tables. Perhaps there is the missing link. There is other things I don't understand like Sequence control and OutputreportlanguageID.
Do I have to create a relationship? Thanks.

Ken
________________________________




----- Original Message ----
From: Dale Schuerman <dale.schuerman@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 24, 2008 9:57:12 AM
Subject: RE: [Vantage] no data


First step is to determine where the problem is.

Is the data in the XML? If it is then it is a Crystal issue. If not
you have a Report Definition issue.

Did you define the outer join in both Report Definition and Crystal?

Dale

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 11:41 AM
To: vantage@yahoogroups .com
Subject: [Vantage] no data

To all Crystal gurus:

I'm attempting to modify the Order Acknowledgement with data from the
Parts table UDF. I've added the table to the Report definition, created
the new report style. In Crystal I can see the Parts table and add the
fields to the report, however there is no data shown. The link is with
PartNum from OrderDtl and Parts table as left outer join. All other data
shows except the fields from Parts. Can anyone make suggestions? Thanks
for your input.

Ken

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

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






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

[system]

Ken,



I am looking at a 8.03.4xx system so some thing may be different for
you..



I am looking at the Order Acknowledgment in the in the Report Data
Maint. In this case, you do not need to add the Part table.

If you go to the Linked Tables tab --> Description Fields tab. In the
drop down box choose PartNum. This will list the Fields

available and the Fields picked. Move over the UDF you want into
picked. After doing a print generate/Preview you should see your new
fields

in the XML.



In CR Developer, open the report, set the datasource location to your
new XML. I think the new fields will be called something like
Part_Character01.

Add the fields to you report and test.



If all is well I think you can delete the Part table out of the report
Data Definition and the Crystal Report.



If you do need to add a table, then you do need to define the
relationship in Report Data Maint. There is a tab to do this.



Dale



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 12:10 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] no data



Dale, I defined it in Crystal. Where exactly do you do it in the Report
Definition? When I go there, there is absolutely no relationship
established for any tables. Perhaps there is the missing link. There is
other things I don't understand like Sequence control and
OutputreportlanguageID.
Do I have to create a relationship? Thanks.

Ken
________________________________

----- Original Message ----
From: Dale Schuerman <dale.schuerman@...
<mailto:dale.schuerman%40ramsys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 24, 2008 9:57:12 AM
Subject: RE: [Vantage] no data

First step is to determine where the problem is.

Is the data in the XML? If it is then it is a Crystal issue. If not
you have a Report Definition issue.

Did you define the outer join in both Report Definition and Crystal?

Dale

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 11:41 AM
To: vantage@yahoogroups .com
Subject: [Vantage] no data

To all Crystal gurus:

I'm attempting to modify the Order Acknowledgement with data from the
Parts table UDF. I've added the table to the Report definition, created
the new report style. In Crystal I can see the Parts table and add the
fields to the report, however there is no data shown. The link is with
PartNum from OrderDtl and Parts table as left outer join. All other data
shows except the fields from Parts. Can anyone make suggestions? Thanks
for your input.

Ken

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

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

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





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

[system]

Dale, you are a lifesaver. That did the trick. You don't happen to know where I can get documentation on programming and customizing screens or BPMs outside of training.

Again. Thanks for all the help.

Ken

________________________________




----- Original Message ----
From: Dale Schuerman <dale.schuerman@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 24, 2008 10:53:27 AM
Subject: RE: [Vantage] no data


Ken,

I am looking at a 8.03.4xx system so some thing may be different for
you..

I am looking at the Order Acknowledgment in the in the Report Data
Maint. In this case, you do not need to add the Part table.

If you go to the Linked Tables tab --> Description Fields tab. In the
drop down box choose PartNum. This will list the Fields

available and the Fields picked. Move over the UDF you want into
picked. After doing a print generate/Preview you should see your new
fields

in the XML.

In CR Developer, open the report, set the datasource location to your
new XML. I think the new fields will be called something like
Part_Character01.

Add the fields to you report and test.

If all is well I think you can delete the Part table out of the report
Data Definition and the Crystal Report.

If you do need to add a table, then you do need to define the
relationship in Report Data Maint. There is a tab to do this.

Dale

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 12:10 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] no data

Dale, I defined it in Crystal. Where exactly do you do it in the Report
Definition? When I go there, there is absolutely no relationship
established for any tables. Perhaps there is the missing link. There is
other things I don't understand like Sequence control and
Outputreportlanguag eID.
Do I have to create a relationship? Thanks.

Ken
____________ _________ _________ __

----- Original Message ----
From: Dale Schuerman <dale.schuerman@ ramsys.com
<mailto:dale. schuerman% 40ramsys. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Thursday, July 24, 2008 9:57:12 AM
Subject: RE: [Vantage] no data

First step is to determine where the problem is.

Is the data in the XML? If it is then it is a Crystal issue. If not
you have a Report Definition issue.

Did you define the outer join in both Report Definition and Crystal?

Dale

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 11:41 AM
To: vantage@yahoogroups .com
Subject: [Vantage] no data

To all Crystal gurus:

I'm attempting to modify the Order Acknowledgement with data from the
Parts table UDF. I've added the table to the Report definition, created
the new report style. In Crystal I can see the Parts table and add the
fields to the report, however there is no data shown. The link is with
PartNum from OrderDtl and Parts table as left outer join. All other data
shows except the fields from Parts. Can anyone make suggestions? Thanks
for your input.

Ken

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

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

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

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






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

[system]

Ken,



EpicWeb has some articles and examples, help has some examples, and this
yahoo group.

Perspectives is in October and they will have sessions on a lot of these
topics.



Epicor has published the "Epicor Tools User Guide". It has some
information and some of it you just have to learn thru experimenting.



Dale

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 1:46 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] no data



Dale, you are a lifesaver. That did the trick. You don't happen to know
where I can get documentation on programming and customizing screens or
BPMs outside of training.

Again. Thanks for all the help.

Ken

________________________________

----- Original Message ----
From: Dale Schuerman <dale.schuerman@...
<mailto:dale.schuerman%40ramsys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 24, 2008 10:53:27 AM
Subject: RE: [Vantage] no data

Ken,

I am looking at a 8.03.4xx system so some thing may be different for
you..

I am looking at the Order Acknowledgment in the in the Report Data
Maint. In this case, you do not need to add the Part table.

If you go to the Linked Tables tab --> Description Fields tab. In the
drop down box choose PartNum. This will list the Fields

available and the Fields picked. Move over the UDF you want into
picked. After doing a print generate/Preview you should see your new
fields

in the XML.

In CR Developer, open the report, set the datasource location to your
new XML. I think the new fields will be called something like
Part_Character01.

Add the fields to you report and test.

If all is well I think you can delete the Part table out of the report
Data Definition and the Crystal Report.

If you do need to add a table, then you do need to define the
relationship in Report Data Maint. There is a tab to do this.

Dale

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 12:10 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] no data

Dale, I defined it in Crystal. Where exactly do you do it in the Report
Definition? When I go there, there is absolutely no relationship
established for any tables. Perhaps there is the missing link. There is
other things I don't understand like Sequence control and
Outputreportlanguag eID.
Do I have to create a relationship? Thanks.

Ken
____________ _________ _________ __

----- Original Message ----
From: Dale Schuerman <dale.schuerman@ ramsys.com
<mailto:dale. schuerman% 40ramsys. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Thursday, July 24, 2008 9:57:12 AM
Subject: RE: [Vantage] no data

First step is to determine where the problem is.

Is the data in the XML? If it is then it is a Crystal issue. If not
you have a Report Definition issue.

Did you define the outer join in both Report Definition and Crystal?

Dale

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Ken Taylor
Sent: Thursday, July 24, 2008 11:41 AM
To: vantage@yahoogroups .com
Subject: [Vantage] no data

To all Crystal gurus:

I'm attempting to modify the Order Acknowledgement with data from the
Parts table UDF. I've added the table to the Report definition, created
the new report style. In Crystal I can see the Parts table and add the
fields to the report, however there is no data shown. The link is with
PartNum from OrderDtl and Parts table as left outer join. All other data
shows except the fields from Parts. Can anyone make suggestions? Thanks
for your input.

Ken

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

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

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

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

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





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

[system]

Ken,
Did you establish the relationship of the Part table to OrderDtl in the report definition?

--- On Thu, 7/24/08, Ken Taylor <ktaylorv@...> wrote:

From: Ken Taylor <ktaylorv@...>
Subject: [Vantage] no data
To: vantage@yahoogroups.com
Date: Thursday, July 24, 2008, 9:41 AM






To all Crystal gurus:

I'm attempting to modify the Order Acknowledgement with data from the Parts table UDF. I've added the table to the Report definition, created the new report style. In Crystal I can see the Parts table and add the fields to the report, however there is no data shown. The link is with PartNum from OrderDtl and Parts table as left outer join. All other data shows except the fields from Parts. Can anyone make suggestions? Thanks for your input.

Ken

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


















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