Home » Developer & Programmer » Reports & Discoverer » Can i do this
icon2.gif  Can i do this [message #240864] Sat, 26 May 2007 12:58 Go to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
HAY ANYONE PLZ TELL ME THAT HOW CAN WE USE CURSORS IN REPORTS AND WHERE DO WE CODE THEM WHETHER IN CF_1 OR IN CP_1 IN REPORTS 6i.
M LAEEQUE A
Re: Can i do this [message #240866 is a reply to message #240864] Sat, 26 May 2007 15:42 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Cursors are cursors, no matter where they are. If you don't have to use them, I guess you will not. But, if you decide to use one, put it into any PL/SQL procedure. And yes, you may use it in both Formula and Placeholder column.
icon2.gif  Re: Can i do this [message #241872 is a reply to message #240866] Wed, 30 May 2007 15:10 Go to previous messageGo to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
hay thanx for reply,
can u plz send me a little e.g of using cursors, so i use it in formula columns to check it bcz i m facing little problem of using cursors in reports plz.
thanx in advancE
Re: Can i do this [message #241879 is a reply to message #240864] Wed, 30 May 2007 16:16 Go to previous message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
What problem are u facing...

About CF and CP

CF : Formula Column.
You have to return a value to it. It cannot be assigned a value from any other formula/place holder column.

CP: Place holder Column.
You can assign it a value from another formula/place holder column and also return a value to it from within its own code.

ENJOY Cool
Previous Topic: Duplicate Rolls in report
Next Topic: destype=mail
Goto Forum:
  


Current Time: Sun Dec 04 04:32:10 CST 2016

Total time taken to generate the page: 0.17263 seconds