Reports Parameters

[mike]

Version 12.0.2.1818 (64) bit.

When I run a report with parameters, the parameters form is not visible until I click the PL/SQL Developer icon on the Windows task bar.

 

[Marco Kalter]

I cannot reproduce this. Do you run the report from the menu or from the Report Window?

 

[mike]

I open it from the ribbon menu.

I wonder if it is because of how I have the variables. The variables have a list that includes a SQL statement that takes about 10 seconds to return. The status bar says "Initializing...", it flashes after the 10 seconds and then nothing. If I click on the pl/sql Developer icon on the start bar after the flash, then the "Variables" window shows up.

Here is how I have the variables:

AND h.user_concurrent_program_name = '&'

AND nvl(h.actual_start_date, SYSDATE) >= to_date('&', 'dd-mon-yyyy')

AND nvl(h.actual_start_date, SYSDATE)

 

[Marco Kalter]

Can you easily modify your report in such a way that it only uses standard dictionary views and still reproduces the issue? If so, can you do so and send it to support@allroundautomations.com?

 

[mike]

The Tables report has this problem for me. I think it came with pl/sql developer. Just in case it didn't, this is the text.

select t.* from all_tables t
where t.owner like &
and t.table_name like &
order by t.owner, t.table_name

 

[Marco Kalter]

It works fine for me. Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[mike]

Yes. I sent it just now. Thanks for looking into this!

Mike

 

[mike]

You know what? It wasn't working for over a week. For the last two days, it has worked perfect every time and I've been using it a lot. I don't know what changed, but if I'm the only one that had the issue, perhaps you don't need to worry about it.

Have a good day!
Mike