Re: List of values in Reports 2.5

In article <3vdc4j$4ku_at_athena.ulaval.ca>,

   Nicolas Rancourt <boloria_at_gmc.ulaval.ca> wrote:
>I create a report and in my parameters form I want to use a LOV.
>I' able to do that but when I run this report, I can't choose a null value
>for my LOV.
>
>When I blank the field, report use the last value of all the choice.
>And the check box Restricted to predetermined values is'nt selected.
>
>Anybody can help me !!!

I found the same limitation with LOV on the parameter form. I talked to Oracle Support and they said that it's the way it is.

I created a workaround which might be of some use to you. The workaround is:

On the LOV query insert "Select null, 'N/A' from dual" before the query and then "Union" the required query after it. This gives a null record as the first record of the query.

My report didn't run when there were a lot of rows returned in the LOV. I had some test data of about 300 rows and it worked fine. I then added 7000 rows to the table and stopped working with an error message. Oracle support is now looking at this problem.

You should test your report for large amounts of rows in the LOV field.

Regards

Tony :)

• Tony Cristiano =
• Analyst Programmer =
• Queensland Transport (ARMIS Project) =

  ---

• "Opportunity always knocks at the least opportune moment." =

  ---