Home » Developer & Programmer » Reports & Discoverer » Cursors in Report
icon1.gif  Cursors in Report [message #227096] Tue, 27 March 2007 06:02 Go to next message
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
Re: Cursors in Report [message #227106 is a reply to message #227096] Tue, 27 March 2007 06:14 Go to previous messageGo to next message
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
Re: Cursors in Report [message #227121 is a reply to message #227106] Tue, 27 March 2007 06:30 Go to previous messageGo to next message
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
Re: Cursors in Report [message #227340 is a reply to message #227121] Wed, 28 March 2007 01:24 Go to previous message
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
Previous Topic: Oracle report using XML as input file.
Next Topic: printing the data tilll the bottom end of the physical page
Goto Forum:
  


Current Time: Sat Dec 10 01:04:55 CST 2016

Total time taken to generate the page: 0.10237 seconds