Home » Developer & Programmer » Reports & Discoverer » how to display data using user variable (xml report)
how to display data using user variable [message #458083] Thu, 27 May 2010 05:17 Go to next message
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 #458090 is a reply to message #458083] Thu, 27 May 2010 06:05 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
I have no idea what you are trying to do here.
What is v_name?
Where does that code come from?
What do you mean by select field?
Re: how to display data using user variable [message #458114 is a reply to message #458090] Thu, 27 May 2010 07:37 Go to previous messageGo to next message
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

Re: how to display data using user variable [message #458506 is a reply to message #458114] Mon, 31 May 2010 02:20 Go to previous message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Is it related to BI Pusblisher?

By
Vamsi
Previous Topic: Print In Larger Page Size
Next Topic: I need process in real time how they prepare the reports and what are the requirements clearly
Goto Forum:
  


Current Time: Fri May 29 16:15:20 CDT 2020