OraFAQ Forum: Forms » Passing 'ALL' value in reports 10g parameter

Home » Developer & Programmer » Forms » Passing 'ALL' value in reports 10g parameter (Oracle Reports 10g)

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

Passing 'ALL' value in reports 10g parameter [message #683349]

Fri, 01 January 2021 16:07

sau
Messages: 1
Registered: January 2021

Junior Member

Dear All,

can anybody know this! it is working fine in reports 6i, when same am using in reports 10g it is not showing any value.

in my query condition am using

where company = :from_company
and (department = :from_dept or from_dept='ALL')

and am passing value in runtime as 'ALL' in department field.

Report message to a moderator

Re: Passing 'ALL' value in reports 10g parameter [message #683353 is a reply to message #683349]

Sat, 02 January 2021 05:31

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

Senior Member
Account Moderator

If that's exactly how your code looks like, then it seems that the last "from_dept" misses a colon:

and (department = :from_dept or from_dept='ALL')
                               ^
                               |
                              here

Report message to a moderator

Previous Topic:	How do I get it to work in my client
Next Topic:	Insert record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 28 16:06:56 CDT 2026