OraFAQ Forum: Forms » Calling multiple reports through alert

Home » Developer & Programmer » Forms » Calling multiple reports through alert (10g)

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

Calling multiple reports through alert [message #494481]

Tue, 15 February 2011 02:41

shanie
Messages: 118
Registered: January 2011

Senior Member

Hello All,

I need code for calling two reports using alerts.
Please suggest some solution.

Thanks and Regards,
Shanie

Report message to a moderator

Re: Calling multiple reports through alert [message #494496 is a reply to message #494481]

Tue, 15 February 2011 04:14

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Explain the relationship between the two reports and the alert?
What actual problem are you facing?

Report message to a moderator

Re: Calling multiple reports through alert [message #494501 is a reply to message #494496]

Tue, 15 February 2011 04:45

shanie
Messages: 118
Registered: January 2011

Senior Member

Hello,

Here Both reports are same. In one report two print outs are there. Like Student Copy and Admin Copy. The actual requirement is sometimes they dont need Admin copy they want to print only Student copy. So I prepared another report of student copy. and thought to call the report using Alerts.

I need code to call both reports using two buttons in Alerts.

Please suggest some solution by using emp or dept table.

Regards,
Shanie

Report message to a moderator

Re: Calling multiple reports through alert [message #494503 is a reply to message #494501]

Tue, 15 February 2011 04:53

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

You know how to call a report from forms don't you?
If so what is the problem? You check the value returned from the show_alert builtin and call the appropriate report.
This is really basic forms programming.

Report message to a moderator

Re: Calling multiple reports through alert [message #494505 is a reply to message #494503]

Tue, 15 February 2011 05:40

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

Senior Member
Account Moderator

I'd rather maintain a single report. Call it with a parameter (PAR_COPY_TYPE) (such as 'SA' (both Student and Admin copy) and 'S' (Student copy only)). Create format trigger on Admin copy frame:

return (:par_copy_type = 'SA');

Report message to a moderator

Previous Topic:	Populate tree based on header block
Next Topic:	Issue with D2KWUTIL.PLL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 13:59:38 CDT 2024