Bring additional info to Sales Order Backlog report

Scott,
  Good add. It's the obvious things that are so elusive.
Thanks -Karl


________________________________
From: Scott Litzau <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Thursday, June 7, 2012 11:24 AM
Subject: RE: [Vantage] Re: Bring additional info to Sales Order Backlog report


Â
In Crystal you can pull from multiple data sources. So your report pulls in
the XML data but you can also add a Subreport using ODBC back to Vantage to
get the OrderHed Table using the XML data to link to Order Number \ Order
Line (not sure what links you need to create). Then place on the report
where you want. When the report runs it will use the generated XML data but
also grab the OrderHed data you want using ODBC.

Scott

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
b_ordway
Sent: Thursday, June 07, 2012 1:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Bring additional info to Sales Order Backlog report

Sorry, as far as I know you will have to rewrite reports like this.
Epicor tables like BKlog only appear to allow joins to other table in the
RDD. The added tables won't return any data though.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Karl
Dash <dashkarl@...> wrote:
>
> The Epicor Sales Order Backlog report in Vantage 803.408 is a Crystal
report that uses an Epicor created table (Bklog) with specific info as they
defined the report. I want to bring in field UserDate1 from the OrderHead
table. I went into the Report Data Maintenance and added the table and tried
to establish a relationship with the existing Bklog table but apparently
there are no 'key' fields in Bklog� to attach to.
> �
> The UserDate1 field is also not an 'excluded' field in Bklog. Is this a
situation that anyone has solved before other than rewriting the report?
> �
> Thanks -Karl
>
> [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]
The Epicor Sales Order Backlog report in Vantage 803.408 is a Crystal report that uses an Epicor created table (Bklog) with specific info as they defined the report. I want to bring in field UserDate1 from the OrderHead table. I went into the Report Data Maintenance and added the table and tried to establish a relationship with the existing Bklog table but apparently there are no 'key' fields in Bklog to attach to.
Â
The UserDate1 field is also not an 'excluded' field in Bklog. Is this a situation that anyone has solved before other than rewriting the report?
Â
Thanks -Karl

[Non-text portions of this message have been removed]
Sorry, as far as I know you will have to rewrite reports like this.
Epicor tables like BKlog only appear to allow joins to other table in the RDD. The added tables won't return any data though.

--- In vantage@yahoogroups.com, Karl Dash <dashkarl@...> wrote:
>
> The Epicor Sales Order Backlog report in Vantage 803.408 is a Crystal report that uses an Epicor created table (Bklog) with specific info as they defined the report. I want to bring in field UserDate1 from the OrderHead table. I went into the Report Data Maintenance and added the table and tried to establish a relationship with the existing Bklog table but apparently there are no 'key' fields in Bklog� to attach to.
> �
> The UserDate1 field is also not an 'excluded' field in Bklog. Is this a situation that anyone has solved before other than rewriting the report?
> �
> Thanks -Karl
>
> [Non-text portions of this message have been removed]
>
In Crystal you can pull from multiple data sources. So your report pulls in
the XML data but you can also add a Subreport using ODBC back to Vantage to
get the OrderHed Table using the XML data to link to Order Number \ Order
Line (not sure what links you need to create). Then place on the report
where you want. When the report runs it will use the generated XML data but
also grab the OrderHed data you want using ODBC.



Scott



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
b_ordway
Sent: Thursday, June 07, 2012 1:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Bring additional info to Sales Order Backlog report





Sorry, as far as I know you will have to rewrite reports like this.
Epicor tables like BKlog only appear to allow joins to other table in the
RDD. The added tables won't return any data though.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Karl
Dash <dashkarl@...> wrote:
>
> The Epicor Sales Order Backlog report in Vantage 803.408 is a Crystal
report that uses an Epicor created table (Bklog) with specific info as they
defined the report. I want to bring in field UserDate1 from the OrderHead
table. I went into the Report Data Maintenance and added the table and tried
to establish a relationship with the existing Bklog table but apparently
there are no 'key' fields in Bklog� to attach to.
> �
> The UserDate1 field is also not an 'excluded' field in Bklog. Is this a
situation that anyone has solved before other than rewriting the report?
> �
> Thanks -Karl
>
> [Non-text portions of this message have been removed]
>





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