Yeah, thanks, Keith. :-)
I think I will go have that martini(s) now.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Keith Mailloux
Sent: Thursday, August 08, 2013 3:43 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 9.05 PO Release...
Welcome to the sadistic world of tranglc. The only way I have discovered to
get around it is to create a subreport in your form using the same data
source (xml file) and link the subreport to the main report using a
calculated field(s) , converted to numeric, based on the key1, key2 etc.
fields. In the subreport you can display only the gl numbers you were after.
You still need to do the whole rdd dance but it sounds like you have that
figured out ok.
Keith
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Vic Drecchio
Sent: Thursday, August 08, 2013 2:46 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 9.05 PO Release...
I had another diatribe written up regarding this ridiculous
afterthought-db-architecture.. I figured it was best to delete it.
OK, so I'm sure it's just me, but I'm simply trying to get the GLAcct# on
the PO Form. It was a 5 minute ordeal in 8.03. So now they band-aid on
this extra UD-like table.
I modify the Report Data Def for the POForm. They certainly couldn't make
it simple for us and used a Linked Table from PORel.. Nope.. So you need to
create a new Relationship. OK. but:
PORel.PONum, POLine and PORel are all INTEGER type fields. The stupid
TranGLC.Key1, Key2 and Key3 fields are. you guessed it. CHARACTER type
fields.
It won't join correctly and I get no results in my XML for the TranGLC
table.
Am I missing something obvious?
#TimeForaMartini
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On
Behalf Of
Ted Koch
Sent: Thursday, August 08, 2013 12:18 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 9.05 PO Release...
Vic,
TranGLC table.
RelatedToFile = PORel
Key1 = PONum
Key2 = POLine
Key3 = PORel
________________________________
From: Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40swepcotube.com>
<mailto:vic.drecchio%40swepcotube.com>
<mailto:vic.drecchio%40swepcotube.com> >
To: Vantage Yahoo <vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Sent: Thursday, August 8, 2013 12:11 PM
Subject: [Vantage] 9.05 PO Release...
What happened to the GL Acct info in the PORel table in 9.05? In 8.03
PORel.ExpDivision, PORel.ExpChart and PORel.ExpGLDept would be its location.
Where did they move it to in 9.05? I've done some querying and cannot seem
to find it.
Thanks. I'm sure I'll find it 10 seconds after pressing SEND.. :-)
[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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
[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]
[Non-text portions of this message have been removed]
I think I will go have that martini(s) now.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Keith Mailloux
Sent: Thursday, August 08, 2013 3:43 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 9.05 PO Release...
Welcome to the sadistic world of tranglc. The only way I have discovered to
get around it is to create a subreport in your form using the same data
source (xml file) and link the subreport to the main report using a
calculated field(s) , converted to numeric, based on the key1, key2 etc.
fields. In the subreport you can display only the gl numbers you were after.
You still need to do the whole rdd dance but it sounds like you have that
figured out ok.
Keith
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Vic Drecchio
Sent: Thursday, August 08, 2013 2:46 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 9.05 PO Release...
I had another diatribe written up regarding this ridiculous
afterthought-db-architecture.. I figured it was best to delete it.
OK, so I'm sure it's just me, but I'm simply trying to get the GLAcct# on
the PO Form. It was a 5 minute ordeal in 8.03. So now they band-aid on
this extra UD-like table.
I modify the Report Data Def for the POForm. They certainly couldn't make
it simple for us and used a Linked Table from PORel.. Nope.. So you need to
create a new Relationship. OK. but:
PORel.PONum, POLine and PORel are all INTEGER type fields. The stupid
TranGLC.Key1, Key2 and Key3 fields are. you guessed it. CHARACTER type
fields.
It won't join correctly and I get no results in my XML for the TranGLC
table.
Am I missing something obvious?
#TimeForaMartini
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On
Behalf Of
Ted Koch
Sent: Thursday, August 08, 2013 12:18 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 9.05 PO Release...
Vic,
TranGLC table.
RelatedToFile = PORel
Key1 = PONum
Key2 = POLine
Key3 = PORel
________________________________
From: Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40swepcotube.com>
<mailto:vic.drecchio%40swepcotube.com>
<mailto:vic.drecchio%40swepcotube.com> >
To: Vantage Yahoo <vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Sent: Thursday, August 8, 2013 12:11 PM
Subject: [Vantage] 9.05 PO Release...
What happened to the GL Acct info in the PORel table in 9.05? In 8.03
PORel.ExpDivision, PORel.ExpChart and PORel.ExpGLDept would be its location.
Where did they move it to in 9.05? I've done some querying and cannot seem
to find it.
Thanks. I'm sure I'll find it 10 seconds after pressing SEND.. :-)
[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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
[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]
[Non-text portions of this message have been removed]