Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

print x Labels (link to repeater table), stating position y (using lbass method)

Status
Not open for further replies.

MyriamA

Technical User
Aug 14, 2012
2
CA
thread767-1439697
hello,
I found Lbass's great method to print Crystal Report labels starting at a position, but I can't figure out how to link the external Repeater table that I created, and that I link on the field qty of my main table.
In Database Expert, I link 3 mysql tables (odbc :Sage 50...) with a Repeater table done in MS-Access (we can't add to that mysql database).
Crystal generates the following SQL query :
"
Sage 50: UNIVERSL.SAI
SELECT `titrline1`.`dQty`, `titrline1`.`dPrice`, `titrline1`.`sSource`, `titrec1`.`lId`, `titrline1`.`lITRecId`, `titrline1`.`lInventId`
FROM `simply`.`titrec` `titrec1` INNER JOIN `simply`.`titrline` `titrline1` ON `titrec1`.`lId`=`titrline1`.`lITRecId`
WHERE `titrline1`.`lITRecId`=187
EXTERNAL JOIN titrline1.dQty={?REPEATER: REPEATER.Qty} AND titrline1.lInventId={?Sage 50: UNIVERSL.SAI: tinvprc1.lInventId}

REPEATER
SELECT `REPEATER`.`Qty`
FROM `REPEATER` `REPEATER`
WHERE `REPEATER`.`Qty`={?Sage 50: UNIVERSL.SAI: titrline1.dQty}

Sage 50: UNIVERSL.SAI
SELECT `tinvprc1`.`lPrcListId`, `tinvprc1`.`dPrice`, `tinvprc1`.`lInventId`
FROM `simply`.`tinvprc` `tinvprc1`
WHERE `tinvprc1`.`lInventId`={?Sage 50: UNIVERSL.SAI: titrline1.lInventId} AND `tinvprc1`.`lPrcListId`=1
"

I can't figure out how to write the statement in the Add Command feature to mix with Lbass query.
"
Union All
Select Null,Null,Null,Null,Null,Null,Null
From `simply`.`titrec` `titrec1` (??)
Where {?LabelNo} >= 0
Order by 1
"

any idea?
many thanks & regards,

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top