Link change log table

Some folks have reported as of .405A that this works. The Phrase Builder does do the necessary type conversion, but at least in .405 the BAQ doesn't return anything.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jasper Recto
Sent: Wednesday, August 05, 2009 10:29 AM
To: Vantage Groups (vantage@yahoogroups.com)
Subject: [Vantage] Link change log table

Does anybody know how I can link the change log table to it's corresponding tables using report builder.

For example, there are entries in the change log for the PODetail table. I would like to link the PODetail table to the change log but the 2 fields are not the same data type so it won't work.

Any ideas?

Thanks,
Jasper



[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
Does anybody know how I can link the change log table to it's corresponding tables using report builder.

For example, there are entries in the change log for the PODetail table. I would like to link the PODetail table to the change log but the 2 fields are not the same data type so it won't work.

Any ideas?

Thanks,
Jasper



[Non-text portions of this message have been removed]
The only solution I've ever come up with is to link by Company only and then select in filter. Performance sucks but it can at least be done. If there is something else you can link to such as a specific date that can help performance but usually prevents running from Vantage menu. Useful only for "one off" fact finding.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jasper Recto
Sent: Wednesday, August 05, 2009 9:29 AM
To: Vantage Groups (vantage@yahoogroups.com)
Subject: [Vantage] Link change log table



Does anybody know how I can link the change log table to it's corresponding tables using report builder.

For example, there are entries in the change log for the PODetail table. I would like to link the PODetail table to the change log but the 2 fields are not the same data type so it won't work.

Any ideas?

Thanks,
Jasper

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





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