Home » Developer & Programmer » Reports & Discoverer » Urgent!!!!!!!!pls help
Urgent!!!!!!!!pls help [message #88202] Fri, 03 May 2002 10:50 Go to next message
Lipi
Messages: 4
Registered: March 2002
Junior Member
hi,

i wanna make a report from a view. the view will be dynamic and the view will be created according to the user parameter passing from report. suppose in the report i'll use start_date and end_date as user parameter and i need the view using the data ranging those dates.is it possible? can anybody help me?

thax
Lipi
Re: Urgent!!!!!!!!pls help [message #88206 is a reply to message #88202] Mon, 06 May 2002 12:12 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
I dont think you need to create a view for your problem..you can directly build up the query (dynamically) and hit the base table itself.

Create a report with a lexical parameter..in the after parameter form trigger build up your new query and set it to lexical parameter.

Report wud give you dymanic result as needed.

Oraboy
Previous Topic: Re: ORA-00904 in Oracle Discoverer
Next Topic: ITS URGENT PLEASE REPLY
Goto Forum:
  


Current Time: Thu Nov 21 15:34:53 CST 2024