| print invoice [message #521359] |
Mon, 29 August 2011 04:35  |
 |
0204ag
Messages: 11
Registered: August 2011
Location: Bahrain
|
Junior Member |
|
|
hi,
i am using forms 6i to make the invoice which has fields lik items, invoice number, date etc and the print button. So i am making the invoice report in report6i.
My problem is that when i press the print button it should print that particular invoice with the invoice number that i am currently viewing.
This is the code i am using:
select inv_no, inv_date from inv_hdr
where inv_no = (select max(inv_no) from inv_hdr);
But it gives only the latest invoice number entered (because of max)( i am entering the invoice number in a text field in forms)where as i want is if m viewing invoice numbr 5 it should print invoice 5 regardless of the total invoices entered.
can anyone suggest me the right query? or how to pass a variable from forms to reports if thats possible?
Thanks
|
|
|
|
| Re: print invoice [message #521418 is a reply to message #521359] |
Mon, 29 August 2011 13:23  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
where inv_no = :block.column;
??? without any helpful information like block and column names, my guess may be of no use.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
