OraFAQ Forum: Reports & Discoverer » Oracle Reports 10g create pop up (like alert in oracle forms)

Home » Developer & Programmer » Reports & Discoverer » Oracle Reports 10g create pop up (like alert in oracle forms) (Reports, 10g, Redhat Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Reports 10g create pop up (like alert in oracle forms) [message #412461]

Thu, 09 July 2009 09:42

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

shaz

Report message to a moderator

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

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.

Report message to a moderator