Report Data Definition help needed

system · September 7, 2009, 5:34pm

Is your DSN different for the computer you are creating the subreports on vs. the computer the other ODBC Reports were made on?

Bruce

-----Original Message-----
From: vantage@yahoogroups.com on behalf of Sean McDaniel
Sent: Sat 9/5/2009 10:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Report Data Definition help needed

We were using sub-reports as well until we figured out how to modify the
report data definitions.

The only limitation I've found is that you can add tables up to two levels
deep. Beyond that and they simply don't return anything

So if you added the tables OrderHed -> OrderDtl -> OrderRel the OrderRel
table wouldn't show up at all.

Not sure if this is by design or not.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ortman11@...
Sent: Friday, September 04, 2009 3:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Data Definition help needed

I'll be interested to see if it works for you. I had to create a sub report
to pull the ShipHead.TrackingNumber into the ARForm. (we dont use EDI).

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote:

>
> Add a new relationship
>
> Give it a name and description
>
> Select the parent table that you are linking your new table to
>
> Select the ShipHead as the child
>
> If you can use an existing index, great, otherwise save and add the

columns

> to join on below on this relationship.
>
>
>
> Save everything. Rerun the report using the new definition.
>
> Open Crystal and point it to the XML you just produced.
>
> Your ShipHead table should be in there.
>
>
>
> Go into Database Export and add the new table and join it and you should

be

> all set.
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of

> sgotschall
> Sent: Friday, September 04, 2009 1:53 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Report Data Definition help needed
>
>
>
>
>
> Vantage 8.03.408A Progress
>
> I need some help adding data to a RDD. The RDD is EDIARFrm and the data I
> need to add to it is ShipHead.TrackingNumber and ShipHead.ShortChar01. I
> duplicated the RDD and added the ShipHead table, but I can't figure out

how

> to set up the relationships.
>
> Any Ideas?
>
>
>
>
>
> [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 · September 4, 2009, 1:53pm

Vantage 8.03.408A Progress

I need some help adding data to a RDD. The RDD is EDIARFrm and the data I need to add to it is ShipHead.TrackingNumber and ShipHead.ShortChar01. I duplicated the RDD and added the ShipHead table, but I can't figure out how to set up the relationships.

Any Ideas?

system · September 4, 2009, 2:12pm

Add a new relationship

Give it a name and description

Select the parent table that you are linking your new table to

Select the ShipHead as the child

If you can use an existing index, great, otherwise save and add the columns
to join on below on this relationship.

Save everything. Rerun the report using the new definition.

Open Crystal and point it to the XML you just produced.

Your ShipHead table should be in there.

Go into Database Export and add the new table and join it and you should be
all set.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sgotschall
Sent: Friday, September 04, 2009 1:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Data Definition help needed

Vantage 8.03.408A Progress

I need some help adding data to a RDD. The RDD is EDIARFrm and the data I
need to add to it is ShipHead.TrackingNumber and ShipHead.ShortChar01. I
duplicated the RDD and added the ShipHead table, but I can't figure out how
to set up the relationships.

Any Ideas?

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

system · September 4, 2009, 3:10pm

Thanks Sean.Â I thought you had to have a key specified and that was hanging me up.

________________________________
From: Sean McDaniel <smcdanie@...>
To: vantage@yahoogroups.com
Sent: Friday, September 4, 2009 2:11:54 PM
Subject: RE: [Vantage] Report Data Definition help needed

Â
Add a new relationship

Give it a name and description

Select the parent table that you are linking your new table to

Select the ShipHead as the child

If you can use an existing index, great, otherwise save and add the columns
to join on below on this relationship.

Save everything. Rerun the report using the new definition.

Open Crystal and point it to the XML you just produced.

Your ShipHead table should be in there.

Go into Database Export and add the new table and join it and you should be
all set.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
sgotschall
Sent: Friday, September 04, 2009 1:53 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Report Data Definition help needed

Vantage 8.03.408A Progress

I need some help adding data to a RDD. The RDD is EDIARFrm and the data I
need to add to it is ShipHead.TrackingNu mber and ShipHead.ShortChar0 1. I
duplicated the RDD and added the ShipHead table, but I can't figure out how
to set up the relationships.

Any Ideas?

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

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

system · September 4, 2009, 3:17pm

I'll be interested to see if it works for you. I had to create a sub report to pull the ShipHead.TrackingNumber into the ARForm. (we dont use EDI).

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> Add a new relationship
>
> Give it a name and description
>
> Select the parent table that you are linking your new table to
>
> Select the ShipHead as the child
>
> If you can use an existing index, great, otherwise save and add the columns
> to join on below on this relationship.
>
>
>
> Save everything. Rerun the report using the new definition.
>
> Open Crystal and point it to the XML you just produced.
>
> Your ShipHead table should be in there.
>
>
>
> Go into Database Export and add the new table and join it and you should be
> all set.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> sgotschall
> Sent: Friday, September 04, 2009 1:53 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Data Definition help needed
>
>
>
>
>
> Vantage 8.03.408A Progress
>
> I need some help adding data to a RDD. The RDD is EDIARFrm and the data I
> need to add to it is ShipHead.TrackingNumber and ShipHead.ShortChar01. I
> duplicated the RDD and added the ShipHead table, but I can't figure out how
> to set up the relationships.
>
> Any Ideas?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · September 4, 2009, 3:36pm

As it turns out I went with a different approach.Â We already have code in place to send out shipping notifications when an Invoice is created.Â I made a quickÂ addition to the 4GL code and dropped the tracking and shipvia information into shortchar01 and shortchar02 field of the invoice header.Â Now I don't need to modify the RDD, I only have to add a couple of links to my outbound EDI map.Â It also has the added benefit in that I can now display this information on the printedÂ invoice with just a small modification to the Crystal Report.Â Up until now, we have had to copy and paste this information into the Invoice header comments, not a big deal but every little bit helps.

________________________________
From: "ortman11@..." <agortman@...>
To: vantage@yahoogroups.com
Sent: Friday, September 4, 2009 3:17:42 PM
Subject: [Vantage] Re: Report Data Definition help needed

Â
I'll be interested to see if it works for you. I had to create a sub report to pull the ShipHead.TrackingNu mber into the ARForm. (we dont use EDI).

--- In vantage@yahoogroups .com, "Sean McDaniel" <smcdanie@.. .> wrote:
>
> Add a new relationship
>
> Give it a name and description
>
> Select the parent table that you are linking your new table to
>
> Select the ShipHead as the child
>
> If you can use an existing index, great, otherwise save and add the columns
> to join on below on this relationship.
>
>
>
> Save everything. Rerun the report using the new definition.
>
> Open Crystal and point it to the XML you just produced.
>
> Your ShipHead table should be in there.
>
>
>
> Go into Database Export and add the new table and join it and you should be
> all set.
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
> sgotschall
> Sent: Friday, September 04, 2009 1:53 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Report Data Definition help needed
>
>
>
>
>
> Vantage 8.03.408A Progress
>
> I need some help adding data to a RDD. The RDD is EDIARFrm and the data I
> need to add to it is ShipHead.TrackingNu mber and ShipHead.ShortChar0 1. I
> duplicated the RDD and added the ShipHead table, but I can't figure out how
> to set up the relationships.
>
> Any Ideas?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · September 5, 2009, 11:55am

We were using sub-reports as well until we figured out how to modify the
report data definitions.

The only limitation I've found is that you can add tables up to two levels
deep. Beyond that and they simply don't return anything

So if you added the tables OrderHed -> OrderDtl -> OrderRel the OrderRel
table wouldn't show up at all.

Not sure if this is by design or not.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ortman11@...
Sent: Friday, September 04, 2009 3:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Data Definition help needed

I'll be interested to see if it works for you. I had to create a sub report
to pull the ShipHead.TrackingNumber into the ARForm. (we dont use EDI).

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote: