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,
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,