I am using 2 tables from a database namely OEORDH and OEORDHO, the fields of the table are like this....
OEORDH
ORDUNIQ ORDNUMBR CUSTOMER CUSTGROUP BILLNAME
4546 QUT02 CUST01 GRI XYZ
4610 QUT03 CUST02 GR2 YYY
4738 QUT03 CUST01 GR1 XYZ
OEORDHO
ORDUNIQ OPTFIELD VALUE
4546 OPTFLD1 ABCDE
4546 OPTFLD2 DEFG
4610 OPTFLD3 ASDF
4738 OPTFLD1 ABCD
These are the contents of the two tables, actually I am preparing a sales order report, when I select a report of ORDNUMBR QUT02, I want the value in OEORDHO to be printed of the of the respective ORDUNIQ (i.e. value of 4546)
To be clear when I select QUTO02 I want "ABCDE" to be printed on my report. But as per now we are getting all the items of the value field on the report.
I wil tell u how I did it, I inserted a subreport and added a command from standard report creation wizard, and inserted the following query
select value
from oeordho
where orduniq in(select orduniq from oeordh)
And linked this subreport to OEORDH.ORDUNIQ.
By executing this all the items in the value field is printing on the report, is there any way to pass a parameter to that SQL query instead of (select orduniq from oeordh)???
I hope you understood the actually problem, if you did not understand plz tell me, I will try to explain more clearly
regards,
Vikram
IP Logged
