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:
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.
[Non-text portions of this message have been removed]
  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:
>report that uses an Epicor created table (Bklog) with specific info as they
> The Epicor Sales Order Backlog report in Vantage 803.408 is a Crystal
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.
> �situation that anyone has solved before other than rewriting the report?
> The UserDate1 field is also not an 'excluded' field in Bklog. Is this a
> �[Non-text portions of this message have been removed]
> Thanks -Karl
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]