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..

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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????

Report message to a moderator

Previous Topic: Forms Installation Query
Next Topic: SQL command concat with block name problems..
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 10 01:56:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.