Yup just did....Parse out that Recon.TmpReference FormulaName: PackNum
Split(ToText({Recon.TmpReference}),'PS:',-1,0)[2]
You need to add ShipDtl table to the RDD relating just
Recon.Company>ShipDtl.Company; add the fields, Company, PackNum, and
whatever fields you need
Then create a subreport with the fields you want (Qty) and do your subreport
links Recon.Company>ShipDtl.Company and ParseFormula PackNum>ShipDtl.PackNum
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Friday, October 09, 2009 8:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 8.03.405a Inv Wip Reconciliation Report
Before I start down this path, on a Friday no less, I thought I wouls ask
the group....
I need to get the qty from the pack slip that is embedded in the 'reference'
column.
I want to avoid ODBC
Has anyone done something like this to this report?
[Non-text portions of this message have been removed]
Split(ToText({Recon.TmpReference}),'PS:',-1,0)[2]
You need to add ShipDtl table to the RDD relating just
Recon.Company>ShipDtl.Company; add the fields, Company, PackNum, and
whatever fields you need
Then create a subreport with the fields you want (Qty) and do your subreport
links Recon.Company>ShipDtl.Company and ParseFormula PackNum>ShipDtl.PackNum
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Friday, October 09, 2009 8:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 8.03.405a Inv Wip Reconciliation Report
Before I start down this path, on a Friday no less, I thought I wouls ask
the group....
I need to get the qty from the pack slip that is embedded in the 'reference'
column.
I want to avoid ODBC
Has anyone done something like this to this report?
[Non-text portions of this message have been removed]