Report Data Definitions

Yahoo Archive
1
I'm working with a copy of the QuotForm report data definition, adding it to the QuotForm report style. I've been able to include and exclude fields, passing them to the .xml file and to my report.

I have two problems; first with zLookupLink tables, second with adding new tables.

zLookupLink tables - Some of these links don't produce accurate lookups. In particular, I added the ShipTo table on the Pick Links tab and added some address fields on the Fields Picked screen. The results yield the customer's address instead of the ship to address listed on the quote header. Am I missing something here?

Adding new tables – I added the QuoteCnt table to the RDD, created a relationship with the Company and QuoteNum fields, excluded some fields and ran the data. I get the new table and the fields in the .xml and the report, but the fields are empty. I also tried adding criteria in the RDD, using the same fields noted above, and running this both with and without the relationship setup…still yielding empty data fields. What am I missing here as well?

Jim Terranova
Accel Group Inc
Implimenting V 9.05.700B
2
I'm working with the Scheduled Shipments report data definition and
trying to add the "OrderDate" to the orders displayed.

When I add the table in the Data Definitions "OrderHed" I can never
seem to access it through Crystal Reports. I drag and drop the
OrderDate from the OrderHed table, but it simply whites out the report.

Any help would be great.

Thanks,

--SF
3
I had to create a separate Crystal Report for this because of the exact same
issue.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sanfranc415
Sent: Thursday, October 04, 2007 5:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Data Definitions

I'm working with the Scheduled Shipments report data definition and
trying to add the "OrderDate" to the orders displayed.

When I add the table in the Data Definitions "OrderHed" I can never
seem to access it through Crystal Reports. I drag and drop the
OrderDate from the OrderHed table, but it simply whites out the report.

Any help would be great.

Thanks,

--SF



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
4
What Version of vantage?

I was able to do it in our test 8.03.403b environment


--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
>
> I had to create a separate Crystal Report for this because of the
exact same
> issue.
>
> Scott
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> sanfranc415
> Sent: Thursday, October 04, 2007 5:16 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Data Definitions
>
> I'm working with the Scheduled Shipments report data definition and
> trying to add the "OrderDate" to the orders displayed.
>
> When I add the table in the Data Definitions "OrderHed" I can never
> seem to access it through Crystal Reports. I drag and drop the
> OrderDate from the OrderHed table, but it simply whites out the
report.
>
> Any help would be great.
>
> Thanks,
>
> --SF
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
5
I'm wondering if anybody knows if there's a setting or a way to remove the schema from an invoice when it's printed to a text file for edi purposes. Every invoice that prints out has the schema at the beginning of the file and our EDI provider wants to know if it can be removed prior to us sending the text file to them. I looked in report data def, report style and I didn't see anything.
6
No way from Vantage to do it that I know of. I use a program called AWK. It is
a programming language which processes text files. With AWK you could easily
strip off the schema from the file after it has been created.




________________________________
From: jortega4087 <jortega@...>
To: vantage@yahoogroups.com
Sent: Wed, February 2, 2011 4:12:12 PM
Subject: [Vantage] Report Data Definitions

Â
I'm wondering if anybody knows if there's a setting or a way to remove the
schema from an invoice when it's printed to a text file for edi purposes. Every
invoice that prints out has the schema at the beginning of the file and our EDI
provider wants to know if it can be removed prior to us sending the text file to
them. I looked in report data def, report style and I didn't see anything.








[Non-text portions of this message have been removed]
7
Would EDIARFrm (ARForm for EDI Outbound Documents ) work for you? It would be
a flat file instead of an XML file.



________________________________
From: jortega4087 <jortega@...>
To: vantage@yahoogroups.com
Sent: Wed, February 2, 2011 3:12:12 PM
Subject: [Vantage] Report Data Definitions

Â
I'm wondering if anybody knows if there's a setting or a way to remove the
schema from an invoice when it's printed to a text file for edi purposes. Every
invoice that prints out has the schema at the beginning of the file and our EDI
provider wants to know if it can be removed prior to us sending the text file to
them. I looked in report data def, report style and I didn't see anything.








[Non-text portions of this message have been removed]
8
I just tried that report data def but when printed, it still has the schema. you're right, it is a flat file but still includes the schema.. thanks for the suggestion.

--- In vantage@yahoogroups.com, DD <ddavis4569@...> wrote:
>
> Would EDIARFrm (ARForm for EDI Outbound Documents ) work for you? It would be
> a flat file instead of an XML file.
>
>
>
> ________________________________
> From: jortega4087 <jortega@...>
> To: vantage@yahoogroups.com
> Sent: Wed, February 2, 2011 3:12:12 PM
> Subject: [Vantage] Report Data Definitions
>
> ÂÂ
> I'm wondering if anybody knows if there's a setting or a way to remove the
> schema from an invoice when it's printed to a text file for edi purposes. Every
> invoice that prints out has the schema at the beginning of the file and our EDI
> provider wants to know if it can be removed prior to us sending the text file to
> them. I looked in report data def, report style and I didn't see anything.
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
You could also use a batch file to remove lines begins with Schema...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jortega4087
Sent: Wednesday, February 02, 2011 4:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Data Definitions



I just tried that report data def but when printed, it still has the schema. you're right, it is a flat file but still includes the schema.. thanks for the suggestion.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, DD <ddavis4569@...> wrote:
>
> Would EDIARFrm (ARForm for EDI Outbound Documents ) work for you? It would be
> a flat file instead of an XML file.
>
>
>
> ________________________________
> From: jortega4087 <jortega@...>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Wed, February 2, 2011 3:12:12 PM
> Subject: [Vantage] Report Data Definitions
>
> Â
> I'm wondering if anybody knows if there's a setting or a way to remove the
> schema from an invoice when it's printed to a text file for edi purposes. Every
> invoice that prints out has the schema at the beginning of the file and our EDI
> provider wants to know if it can be removed prior to us sending the text file to
> them. I looked in report data def, report style and I didn't see anything.
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
10
Are we only able to copy and customize the Report Data Definitions that are included with the software? I've been able to do this and get the results in a new Crystal report. But if I create a new RDD from scratch and assign it to a new Report Style, how do I launch it getting it to create the new .xml file?

I've used the BAQ Report Designer for flat table reports, but I need to get more complex information. I haven't tried the Dashboard Reports yet. We're currently using ODBC in V5 and have a ton of reports to redevelop.

Jim Terranova
Accel Group Inc
Implementing V 9.05.700B
11
You can't create new RDD's and use them without the SDK.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Wed, Sep 12, 2012 at 4:20 PM, james.terranova@... <
jimt@...> wrote:

> **
>
>
> Are we only able to copy and customize the Report Data Definitions that
> are included with the software? I've been able to do this and get the
> results in a new Crystal report. But if I create a new RDD from scratch and
> assign it to a new Report Style, how do I launch it getting it to create
> the new .xml file?
>
> I've used the BAQ Report Designer for flat table reports, but I need to
> get more complex information. I haven't tried the Dashboard Reports yet.
> We're currently using ODBC in V5 and have a ton of reports to redevelop.
>
> Jim Terranova
> Accel Group Inc
> Implementing V 9.05.700B
>
>
>


[Non-text portions of this message have been removed]
12
For new reports you would use BAQs, same for dashboards. In E9 "most" reports/dashboards can be accomplished with BAQs. While it is a single table result it can be the result of some pretty involved joins.

You can also do a direct progress call from embedded for more elaborate data-sets. With that you would typically also use an embedded call to crystal reports passing the data-set returned from progress to the crystal object.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "james.terranova@..." <jimt@...> wrote:
>
> Are we only able to copy and customize the Report Data Definitions that are included with the software? I've been able to do this and get the results in a new Crystal report. But if I create a new RDD from scratch and assign it to a new Report Style, how do I launch it getting it to create the new .xml file?
>
> I've used the BAQ Report Designer for flat table reports, but I need to get more complex information. I haven't tried the Dashboard Reports yet. We're currently using ODBC in V5 and have a ton of reports to redevelop.
>
> Jim Terranova
> Accel Group Inc
> Implementing V 9.05.700B
>