Home » Developer & Programmer » Reports & Discoverer » Stored Procedure in Crystal Reports
Stored Procedure in Crystal Reports [message #90002] Sat, 25 September 2004 20:28 Go to next message
sam k
Messages: 23
Registered: September 2004
Junior Member
Hi

I am working oracle 9i with crystal reports 10.

Can any one  like to let me  know how to call a stored procedure in my Report??

  EX :: I have a Stored procedure in Oracle called (SP1) and when i run my Report(RP1) it needs to call Sp1 for for populating tables.

  how can i call SP in to my RP1??

plzz let me know ASAP

Thx in Adv

cheers

Report message to a moderator

Re: Stored Procedure in Crystal Reports [message #90003 is a reply to message #90002] Mon, 27 September 2004 01:39 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
Simply add the call of your Procedure to any of the following report triggers:
1.Before-parameter-form
2.After-parameter-form

HTH
Regards
Himanshu

Report message to a moderator

Re: Stored Procedure in Crystal Reports [message #147770 is a reply to message #90003] Mon, 21 November 2005 00:02 Go to previous message
swatijvishwas
Messages: 7
Registered: July 2005
Location: india
Junior Member
hello ,
i am swati, this is my first time when i am using crystal report, i just wanted to know that is it possible to call crystal report from Forms in Oracle , if yes pl tell me the detail coding ,
thanks in advance
swati

Report message to a moderator

Previous Topic: Counting Discoverer installations
Next Topic: Different report output Windows XP & 2000
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 19:26:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.