OraFAQ Forum: Reports & Discoverer » Issue with binding parameter in Data wizard query

Home » Developer & Programmer » Reports & Discoverer » Issue with binding parameter in Data wizard query (Oracle reports 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue with binding parameter in Data wizard query [message #602297]

Mon, 02 December 2013 18:16

Berryfinn
Messages: 1
Registered: December 2013

Junior Member

I had created a parameter (:p_attributes) and I am trying to use it in the query in Data wizard.
This parameter will be displayed in the parameter form, and will be a free-entry data-label.

I had used the below query to pull data but i dont see any data in the specific column.
The below mentioned code is part of a select statement (select clause)
The 'samples' table has 3 columns - id, name, text_value

Select text_value
from samples
where name=:p_attributes

Please let me know if I am missing something here.

Thank You for your help.

Report message to a moderator

Re: Issue with binding parameter in Data wizard query [message #602303 is a reply to message #602297]

Mon, 02 December 2013 22:30

shahzad-ul-hasan
Messages: 639
Registered: August 2002

Senior Member

send me parametrer form picture and report layout. also view the attached rdf file for your understanding.

Attachment: stock.RDF
(Size: 88.00KB, Downloaded 3076 times)

Report message to a moderator

Re: Issue with binding parameter in Data wizard query [message #602327 is a reply to message #602303]

Tue, 03 December 2013 04:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Does the same query - when ran in SQL*Plus - return any values?

What exactly do you put into that parameter's value? Could you run a query (in SQL*Plus, again), using exactly the same SELECT statement, with the same WHERE clause as you use in this report?

How do I do that? I prepare the whole SELECT statement in SQL*Plus and - once I'm done and satisfied with results it returns - simply copy/paste it into report.

Report message to a moderator

Previous Topic:	One report, Multiple Copies
Next Topic:	Serial Number Field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 15:00:43 CST 2024