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.
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: 21806
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
Previous Topic: How do I get it to work in my client
Next Topic: Insert record
Goto Forum:
  


Current Time: Thu Mar 28 16:38:26 CDT 2024