Home » Developer & Programmer » Reports & Discoverer » Oracle Reports 10g create pop up (like alert in oracle forms) (Reports, 10g, Redhat Linux)
Oracle Reports 10g create pop up (like alert in oracle forms) [message #412461] Thu, 09 July 2009 09:42 Go to next message
dlwixon
Messages: 92
Registered: September 2008
Member
I need a way to create a pop up (like an alert in Oracle Forms) that alerts a user when one queried value in the report is greater than another queried value.

Any suggestions?

Can this be done using javascript?

If so, how?

Note: I'm not trying to check values on the parameter form. I'm also not trying to check values that are sent to the report. I'm trying to check values that are returned from the queries.

Thanks


[Updated on: Thu, 09 July 2009 09:58]

Report message to a moderator

Re: Oracle Reports 10g create pop up (like alert in oracle forms) [message #412522 is a reply to message #412461] Thu, 09 July 2009 15:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wouldn't know about Java script. Also, I don't know how to create a pop-up window. But you might try to use conditional formatting and see what it offers.
Re: Oracle Reports 10g create pop up (like alert in oracle forms) [message #412551 is a reply to message #412522] Fri, 10 July 2009 00:06 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
well, use the srw package.
just write the format trigger on any of the comparing fields, and then use the srw package.
for further reference:-
srw.message (1,<your field>);

hope this helps.
Re: Oracle Reports 10g create pop up (like alert in oracle forms) [message #412596 is a reply to message #412551] Fri, 10 July 2009 01:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
shaz /forum/fa/2115/0/
Re: Oracle Reports 10g create pop up (like alert in oracle forms) [message #418603 is a reply to message #412461] Mon, 17 August 2009 10:57 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member
Thanks but srw.message does not work that way in 10g. It did in Oracle reports 6.

All it will do in 10g is write to logs if tracing is on.

This is why I'm looking for an alternative.

We're converting reports 6 to 10g. We had srw.message in reports 6. That functionality no longer works in 10g.

Metalink has instructed me to put all of the queries in the forms that call the reports and then show an alert there if needed.

This will slow things down. We'll have the queries running in the form before calling the reports and then run the queries in the reports.

Our users don't want conditional formatting

They want a popup as that's what they're used to. So the pop up is written in the requirements.
Re: Oracle Reports 10g create pop up (like alert in oracle forms) [message #419069 is a reply to message #412461] Wed, 19 August 2009 14:14 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member
According to metalink there is no functionality like this in Oracle Reports 10g.

So: no popups for reports.
Re: Oracle Reports 10g create pop up (like alert in oracle forms) [message #419323 is a reply to message #412461] Fri, 21 August 2009 04:13 Go to previous message
shaz
Messages: 182
Registered: June 2009
Senior Member
whats the harm in conditional formatting??
Previous Topic: How to configure reports in linux to use particular fonts
Next Topic: Open PDF not working
Goto Forum:
  


Current Time: Fri Mar 29 08:55:32 CDT 2024