Home » Developer & Programmer » Reports & Discoverer » passing/testing DATA parameter (Oracle developer 6i)
passing/testing DATA parameter [message #325257] Thu, 05 June 2008 07:18 Go to next message
jramya
Messages: 42
Registered: April 2008
Member
Hi All,
I am new oracle forms and reports.I am trying to pass a record group from a form to a report as a 'DATA PARAMETER'.
I need to check the report data,if its a text parameter i can use a lexical,user parameter and do it.How can i do in case of record group or how to imply to report engine to refer to a record group.
Any source of information can be helpful.
Re: passing/testing DATA parameter [message #327908 is a reply to message #325257] Wed, 18 June 2008 06:24 Go to previous messageGo to next message
shahnirav86
Messages: 13
Registered: June 2008
Location: anand,gujarat
Junior Member

YOU WANT USE LEXICAL PARAMETER IN REPORT THE


ONE USER PARAMETER HAVE A:='WHERE NAME:='NIRAV';

YOU SIMPLY WRITE IN QUERY
SELECT * FROM ENAME &A
IT'S WORK

[Updated on: Wed, 18 June 2008 06:26]

Report message to a moderator

Re: passing/testing DATA parameter [message #328204 is a reply to message #327908] Thu, 19 June 2008 06:30 Go to previous message
jramya
Messages: 42
Registered: April 2008
Member
Hi shahnirav86,
Thank you for your tip.
I did tried it having a dummy query in report,passing DATA PARAMETER from form which replaces the dummy query to actual query and executes it and this helped me.
Previous Topic: Queries in data model of report
Next Topic: How to fill the specified color
Goto Forum:
  


Current Time: Sat Nov 30 03:46:56 CST 2024