You had mistaken me as i had not asked for any code.
I again describe my problem.
I design data report though data environment
adding connection and 2 sql commands parent command 1 and child command2.
command 1 = select * from customer where ccode=?
command 2 = select Q.ccode,D.pcode,P.pname,D.desc,D.price from Quotation Q,PartDesc D,Parts P where Q.ccode=? and Q.dcode=D.dcode and D.pcode=P.pcode
then i take data report and design the whole as per requirement
data source = dataenvironment
data member = command1
placing the required field on data reports section.
On form, i call below procedure after saving the data which shows data report and got print.
Public Sub PrintQuote() Load DataEnvironment1 DataEnvironment1.Command1 CInt(Trim(Me.txtCustCode.Text)) DataReport1.Show Unload DataEnvironment1 End Sub
but it will say error "report width is larger than paper width".
i always find difficult how to get print for anything.
suggest.where i had made mistake.