Home » Developer & Programmer » Forms » Usage of Reports/Forms
Usage of Reports/Forms [message #218819] Sat, 10 February 2007 14:47 Go to next message
Arunprakash.k
Messages: 2
Registered: February 2007
Junior Member
Hi guys..
I have a report to generate. Usually we use front end tools but i wanted to use oracle. I tried the report with a plsql block on UNIX n wrote it on to a file using UTL_FILE concept. But my problem is aligning the report according to the required format. I tried chr(9) ie tab to align the report it looked fine but when i ftp it to Windows n open with notepad/wordpad it looks bad..
I can use the sqlplus reports but..i need to fetch multiple rows with the help of cursors n print them one by one. So i need to know if i can write a sqlplus report in plsql block n use cursors n so on..or is there any other way...
Please suggest a way..
Re: Usage of Reports/Forms [message #219150 is a reply to message #218819] Tue, 13 February 2007 03:00 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I suggest using LPAD on number fields and RPAD on character fields to assist you with text alignment.

David

Upd: Typo in the commands. Doh!

[Updated on: Tue, 13 February 2007 03:01]

Report message to a moderator

Re: Usage of Reports/Forms [message #219216 is a reply to message #219150] Tue, 13 February 2007 10:30 Go to previous message
Arunprakash.k
Messages: 2
Registered: February 2007
Junior Member
hi david....
hmmm...thts real simple..now y dint i think of tht..neways thanks..btw is it possible do write a sqlplus report in a plsql block????
Previous Topic: Forms Installation Query
Next Topic: SQL command concat with block name problems..
Goto Forum:
  


Current Time: Fri Dec 09 05:37:43 CST 2016

Total time taken to generate the page: 0.08167 seconds