Record selection problem

[MALICKA]

I am doing CR for Quotation based on 2 tables
Product & Quotation
Grouping by Quotation number
But the probelm is only those record present in the product table is selected
But in quotation there are some product which is not in table .
HOw can i resolve this.
even i try to modify the join condition but i get dll err

 

[synapsevampire]

It sounds like you NEED to alter the JOIN, if you're getting DLL errors, then that's a different issue.

I think that you want a LEFT OUTER from quotation to product (which is very odd that you can quote on something which doesn't exist...).

What type of connectivity are you using? How are you calling the report?

Try changing the connectivity type, and make sure that you have the latest hot patches installed from CR.

You didn't share much with us, such as database used, version of CR, etc., so it's difficult to nail the problem.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[MALICKA]

HI
Tks for your responce
I am using CR 8.5 & OLE DB to connect to sql server
Calling the report thru the parameter

Call frmPrint.GetParameter("icsqn.rpt", "QUOTATION", "txqtndtl.qn_no", txtQnNo.Text,txtQnNo1.Text)

In selction formula
CrystalReport1.SelectionFormula = "{" & key_field & "} in '" & txtField(0) & "' to '" & txtField(1) & "'"

QUERY
_______
SELECT * // IN DETAIL
FROM
((ICS.dbo.txqtnhdr txqtnhdr INNER JOIN ICS.dbo.txqtndtl txqtndtl ON
txqtnhdr."qn_no" = txqtndtl."qn_no" AND
txqtnhdr."qn_rev" = txqtndtl."qn_rev&quotINNER JOIN ics.dbo.maprduct maprduct ON
txqtndtl."qn_prod_no" = maprduct."prod_no"
ORDER BY
txqtndtl."qn_no" ASC,
txqtndtl."qn_seq_no" ASC

Tks

 

[MALICKA]

HI K
Tks for your great help
when i change inner join to left outer it worked perfectly
tks again