OraFAQ Forum: Reports & Discoverer » Shall we pass WHERE clause to the reports from form? how? List down the steps

Home » Developer & Programmer » Reports & Discoverer » Shall we pass WHERE clause to the reports from form? how? List down the steps

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

Shall we pass WHERE clause to the reports from form? how? List down the steps [message #90313]

Thu, 27 January 2005 19:32

Senthil Kumar.T.D
Messages: 3
Registered: January 2005

Junior Member

Shall we pass WHERE clause to the reports from form? how? List down the steps

Report message to a moderator

Re: Shall we pass WHERE clause to the reports from form? how? List down the step [message #90319 is a reply to message #90313]

Fri, 28 January 2005 06:00

ÇÊ
Messages: 15
Registered: September 2002

Junior Member

Shall you? Depends on your requirements. There are times when it is very handy. There are other times when it doesn't make sense.

If you decide to use it, read up on the documentation on how to pass parameters. Essentially, that's all you're doing.

Build a huge string filling in the user-selected parameters:

EX: ' WHERE emp_id = '||to_char(:p_emp_id);

Pass that string to your report.

In your report, change your data model:

SELECT yourfields
FROM your_table
&p_where

Where p_where is the parameter you passed.

Report message to a moderator

Re: Shall we pass WHERE clause to the reports from form? how? List down the step [message #90343 is a reply to message #90319]

Tue, 01 February 2005 19:08

senthilkumar
Messages: 9
Registered: October 2001

Junior Member

thanks

Report message to a moderator

Previous Topic:	Discoverer and SQLserver
Next Topic:	ERP Training

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 10:17:36 CDT 2024