| how to display data using user variable [message #458083] |
Thu, 27 May 2010 05:17  |
ashish_f
Messages: 14
Registered: May 2010
|
Junior Member |
|
|
following is my query model
SELECT INV.VENDOR_ID,inv.invoice_date,inv.po_header_id,
INV.INVOICE_ID,
INV.INVOICE_NUM,
INV.INVOICE_AMOUNT
FROM AP_INVOICES_ALL INV
,AP_SUPPLIERS SUP
WHERE
INV.VENDOR_ID=SUP.VENDOR_ID
AND
SUP.VENDOR_NAME = :V_NAME
i want to display data using V_NAME
FOLLWING IS MY CODE
<xsl:for-each select="//LIST_G_INVOICE_ID/G_INVOICE_ID">
<Cell ss:StyleID="s25">
<Data ss:Type="String"><xsl:value-of select=" "/></Data>
</Cell>
WHAT i have to write in select field
[Updated on: Thu, 27 May 2010 05:28] Report message to a moderator |
|
|
|
|
|
| Re: how to display data using user variable [message #458114 is a reply to message #458090] |
Thu, 27 May 2010 07:37  |
ashish_f
Messages: 14
Registered: May 2010
|
Junior Member |
|
|
i have created data model in oracle report and wrote that query
in SQL query
after that i m designing layout in xml to see output as Excel format through oracle application R12
V_NAME IS bind variable(see SQL Query)
i want 2 display data using that bind variable
so,what we have 2 write in data retrival tag(see bold statement)
[Updated on: Thu, 27 May 2010 07:42] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
