OraFAQ Forum: Forms » Forms or Reports / Not Sure

Home » Developer & Programmer » Forms » Forms or Reports / Not Sure

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

Forms or Reports / Not Sure [message #158314]

Thu, 09 February 2006 19:56

shatishr
Messages: 52
Registered: September 2005
Location: Shah Alam

Member

hie all,
im not really sure if this is the correct forum for me to post but i need to know something.

i have about 10 reports developed by Oracle Reports. and i have compiled all of them.
Now, my management want me to do a screen whereby if i click "REPORT 1", it should open report 1.. and etc...

Do we use Oracle Forms to do this and if yes how do i do it ? Any site I can learn from... ?? Pls help

Report message to a moderator

Re: Forms or Reports / Not Sure [message #158320 is a reply to message #158314]

Thu, 09 February 2006 22:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Yes. There are a few alternatives - drop down list or ten buttons or items in a menu bar.

Look in the Forms reference manual for run_product (6i) or run_report_object and web.show_document (9i/10g). Also search this forum for these keywords.

David

Report message to a moderator

Re: Forms or Reports / Not Sure [message #158340 is a reply to message #158320]

Fri, 10 February 2006 01:17

shatishr
Messages: 52
Registered: September 2005
Location: Shah Alam

Member

hie very sorry for the disturbance
for testing purposes, i created a button on the form and tried my very best to put in some infor i got from the manuals but i cant to see to call the report...

can someone guide ?

Report message to a moderator

Re: Forms or Reports / Not Sure [message #158366 is a reply to message #158340]

Fri, 10 February 2006 04:01

mail2me
Messages: 5
Registered: February 2006

Junior Member

Hi,
1)You can use a drop down box to get a list of report;
2)After selecting the report id u will have to call the report
for calling the report u will have to use

Run_Product(REPORTS,'C:\Work\Reports\'||:REPORT_LIST, ASYNCHRONOUS, RUNTIME,FILESYSTEM,'');
for more detail about run_product

u can use this code in when_button_pressed

so that would be enough to call your report

I HAVE ALSO ATTACHED SAMPLE FORM TAHT WILL HELP YOU

JUST SEE THE LIST OF VAL
AND BUTTON CODE

Attachment: TEST.fmb
(Size: 40.00KB, Downloaded 1052 times)

Report message to a moderator

Re: Forms or Reports / Not Sure [message #158561 is a reply to message #158366]

Mon, 13 February 2006 03:44

shatishr
Messages: 52
Registered: September 2005
Location: Shah Alam

Member

i tried editing the push button script that you gave me...
is this the way

DECLARE
REPORT_ID		Report_Control_A1;

	begin
		Report_Control_A1:=	FIND_REPORT_OBJECT('L:\RA\RA\TRAP\Report_Control_A1.rdf') ;
			
	Run_Product(REPORTS,'L:\RA\RA\TRAP\Report_Control_A1.rdf'||:REPORT_LIST, ASYNCHRONOUS, RUNTIME,FILESYSTEM,'');
	END;

am not so sure whether to use the .rdf or .rep
Can u check whether there is problem with the above ?

Thanks a lot

Report message to a moderator

Re: Forms or Reports / Not Sure [message #158700 is a reply to message #158561]

Mon, 13 February 2006 22:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I recommend putting the path to your reports in the REPORTS_PATH entry of the registry and then just refer to the form by name without directory name or extension. I also recommend only using 'rdf' reports as they run just as well as 'rep' reports and if you move to a mixed windows/unix environment you don't have to worry about recompiling.

David

Upd: spelling

[Updated on: Sun, 19 February 2006 23:49]

Report message to a moderator

Re: Forms or Reports / Not Sure [message #158921 is a reply to message #158700]

Wed, 15 February 2006 01:30

shatishr
Messages: 52
Registered: September 2005
Location: Shah Alam

Member

DECLARE
REPORT_ID		L:\RA\RA\TRAP\Report_Control_A1.rdf;

	begin
        Report_Control_A1:=	FIND_REPORT_OBJECT
       ('Report_Control_A1') ;
			
	Run_Product(REPORTS,'Report_Control_A1'||:REPORT_LIST,
        ASYNCHRONOUS, RUNTIME,FILESYSTEM,'');
	END;

dj.. is this way okie ?

Report message to a moderator

Re: Forms or Reports / Not Sure [message #159050 is a reply to message #158921]

Wed, 15 February 2006 18:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What version of Forms and Reports are you running?

David

Report message to a moderator

Re: Forms or Reports / Not Sure [message #159271 is a reply to message #159050]

Fri, 17 February 2006 01:52

shatishr
Messages: 52
Registered: September 2005
Location: Shah Alam

Member

hie dj,
im using oracle forms version 6i and my reports are also developed by 6i.

im trying based on this particular report
Name : Report_Control_A1.rdf
Path : L:\RA\RA\TRAP\TRAP Reports\Report_Control_A1.rdf

could u pls help here.
thanks a lot

Report message to a moderator

Re: Forms or Reports / Not Sure [message #159469 is a reply to message #159271]

Sun, 19 February 2006 23:50

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please review my previous post http://www.orafaq.com/forum/m/158700/67467/#msg_158700 do what I suggested and then come back with any problems.

David

Report message to a moderator

Previous Topic:	libraries how to use it
Next Topic:	Forms Configuration Files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:38:27 CDT 2024