details

DEPID(Number)    DEPTNAME(VARCHAR)

 

0                         

1                              HR&Admin

2                              Finance

3                              IT

4                              Accounts

 

For generating an employee t  report,when i create a parameter for Department Name,the LOV is dispalying only HR&Admin,Finance,IT,Accounts.But there are some employees under the DEPTID=0.I tried convert DBNULL to Default.But i can't find any difference.

How can i  populate the department with ID=0 in LOV.

 

Thanks & Regards

i did add the string to lov using the command. but the record slection formula is not working for me bcz i'm using deptname as parameter.