| *URGENT HELP NEEDED* [message #89688] |
Thu, 24 June 2004 06:11  |
Steve
Messages: 190
Registered: September 1999
|
Senior Member |
|
|
Hello -
I need some help regarding Reports 6i. I have created a parameter form for my report, the parameter is p_award_num_req. The goal is to utilize the parameter when the report is run to filter data based on the entry. I have two conditions. The first, if the user does not make an entry, I need to display all awards from the table. The second is, if the user makes a partial entry, I'd like to use a wildcard and LIKE statement in the WHERE clause to retrieve the matches. I really do not know where to start. I have been fumbling around with triggers to try and handle the NULL entry (problem #1), but I cannot get the wildcard to work. Currently, the final portion of my WHERE clause reads 'AND award_number LIKE ':p_award_num_req'' I know this is incorrect, but am I on the right track? Thanks.
Steve
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
