Home » Developer & Programmer » Forms » Passing 'ALL' value in reports 10g parameter (Oracle Reports 10g)
icon6.gif  Passing 'ALL' value in reports 10g parameter [message #683349] Fri, 01 January 2021 16:07 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 03 11:42:17 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.