Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multiple rows from cursor need to be returned to report

Status
Not open for further replies.

young01

Programmer
Dec 17, 2003
4
US
I am somewhat of a newbie to Oracle Reports...here is my problem. I have a table which contains records of member information. In this table a specific member can have several records of the same type information, for example...problems. I have created a formula column that contains a cursor that will gather all the records for a particular member. I need to output a report for each member showing all of their problems on a single report. I have been unable to figure out how to return multiple records to the report from the cursor in the formula column.

Any help is GREATLY appreciated.
 
Formula column is not needed for this task. Just select all records and make group by employee (in the data model, not in SQL). As it sounds, the report can be done with Report Wizard. Use Group-Left or Group-Above type.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top