OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Cursors in Report

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

Cursors in Report [message #227096]

Tue, 27 March 2007 06:02

tipyyt
Messages: 11
Registered: March 2007
Location: Karachi

Junior Member

I want to Create a Curosr in Report...how can i DO that...
plz send a suitable example.

Regards
Danish Hayder.
sdhr_251@hotmail.com

Report message to a moderator

Re: Cursors in Report [message #227106 is a reply to message #227096]

Tue, 27 March 2007 06:14

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

What is the scenerio for the cursor to use in report?
What is your layout of the report?

Generally report works on single SELECT statement.

Cursors can be used in Formula columns, Placeholder columns, action triggers etc.

What is your requirement?

Bhupinder Singh

Report message to a moderator

Re: Cursors in Report [message #227121 is a reply to message #227106]

Tue, 27 March 2007 06:30

tipyyt
Messages: 11
Registered: March 2007
Location: Karachi

Junior Member

I have report,it is a tabular report.getting data from a view,and a view getting data from 6 different tables,.

I want that my report getting data of my choice.I forms i handle it through cursors and FOR loop.

Once report is Run I put data in parameter forms..that Parameter Pass in Cursor and by result of that return cursor i want manupulation in Report...

If u have IDEA of FOXPRO.U can easily get my question

Report message to a moderator

Re: Cursors in Report [message #227340 is a reply to message #227121]

Wed, 28 March 2007 01:24

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

Hi!
You can build entire SELECT statement (with whatever selection you want) in your form and
then send that statement to the report using lexical parameters.

Bhupinder Singh

Report message to a moderator

Previous Topic:	Oracle report using XML as input file.
Next Topic:	printing the data tilll the bottom end of the physical page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 01:46:04 CST 2024