print invoice [message #521359] |
Mon, 29 August 2011 04:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6a332a7d3ee420f1ebcd6d64d1201058?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|