chosing between parameters in reports

[KBALDWIN1]

>:-<
I have two parameters on reports parameter form. One parameter is a fill in while the other one is an LOV. The LOV has the following select statement:

select distinct keys_text form v_track

. My parameter form works fine on runtime. It allows the user to select the blank that appears on the LOV and then insert an SSN in the other field, to run the report looking for the SSN.

The problem. When running this on the web the blank on the LOV is no longer available. I need the blank or null value so the user can choose which field they want to use to run the report.

 

[mmontesano]

Does your table V_TRACK actually have a row with a blank KEYS_TEXT column? If so is the column NULL or a space? If not, you could either add such a row to V_TRACK or change the LOV select to be:

select distinct keys_text from v_track
union
select ' ' from dual

Please let us know if you find a solution. monte
email: mmontesano@usa.net