V( - TranGLC in Forms

Yahoo Archive
1
I second that, it was standard inclusion on our custom V8 PO forms, but with the revamp on everything GL they have done some rather unique things for reasons I can't comprehend. BPM to transfer the values is your best bet, but I'd go with ShortChar over Char unless you absolutely had to because you ran out.. with char's you can't sort, group or do much else in crystal...

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084

(Click the logo to view our site)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of John Driggers
Sent: Sunday, February 17, 2013 9:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] V( - TranGLC in Forms

You'll need to overcome the mismatch. Even if the you get the data into your XML, Crystal won't join tables if the types don't match. Your best bet is to use a BPM or Data Directive to copy the data on the PO into Char01, Char02, etc and then link on that.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*


On Fri, Feb 15, 2013 at 4:56 PM, K mailloux <maillouxk@...> wrote:

> **
>
>
> I am trying to include GL account info in our PO Release line. I tried
> customizing an RDD for the POFOrm adding the TranGLC table and joining
> the Company, PO, Line and Release to Company, Key1,key2 and Key3 respectively.
> I know the PO info is numeric and the key fields in TranGLC are strings.
> Does the RDD take care of the mismatch or am I at the mercy of the
> poor design of this table relationship?
>
> I can link the tranglc in the form using totext conversions and
> subreport links without issue however the xml file dose not contain any TranGLC data.
> The schema does have the tranGLC schema.
>
> Can you say ODBC????
>
> Thanks
>
> Keith Mailloux
>
>
>


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



------------------------------------

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/linksYahoo! Groups Links
2
I am trying to include GL account info in our PO Release line. I tried customizing an RDD for the POFOrm adding the TranGLC table and joining the Company, PO, Line and Release to Company, Key1,key2 and Key3 respectively. I know the PO info is numeric and the key fields in TranGLC are strings. Does the RDD take care of the mismatch or am I at the mercy of the poor design of this table relationship?

I can link the tranglc in the form using totext conversions and subreport links without issue however the xml file dose not contain any TranGLC data. The schema does have the tranGLC schema.

Can you say ODBC????

Thanks

Keith Mailloux
3
You'll need to overcome the mismatch. Even if the you get the data into
your XML, Crystal won't join tables if the types don't match. Your best bet
is to use a BPM or Data Directive to copy the data on the PO into Char01,
Char02, etc and then link on that.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*


On Fri, Feb 15, 2013 at 4:56 PM, K mailloux <maillouxk@...> wrote:

> **
>
>
> I am trying to include GL account info in our PO Release line. I tried
> customizing an RDD for the POFOrm adding the TranGLC table and joining the
> Company, PO, Line and Release to Company, Key1,key2 and Key3 respectively.
> I know the PO info is numeric and the key fields in TranGLC are strings.
> Does the RDD take care of the mismatch or am I at the mercy of the poor
> design of this table relationship?
>
> I can link the tranglc in the form using totext conversions and subreport
> links without issue however the xml file dose not contain any TranGLC data.
> The schema does have the tranGLC schema.
>
> Can you say ODBC????
>
> Thanks
>
> Keith Mailloux
>
>
>


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