Home » Developer & Programmer » Reports & Discoverer » Report Editing (Windows XP Oracle 9i Dev 6i)
Report Editing [message #341361] Mon, 18 August 2008 09:34 Go to next message
Messages: 157
Registered: March 2008
Location: Riyadh
Karma: 0
Senior Member
Hi guyz,

i create one report after that i increse the length in database

before i have text_item varchar2(20)
the length of the column is not enough for values so i alter the table andit working fine in forms but i dont no how to increse the legth of a item in report.

can someone tell me how to edit the report and increse the length example 20 to 100 ?


[Updated on: Mon, 18 August 2008 09:35]

Report message to a moderator

Re: Report Editing [message #341363 is a reply to message #341361] Mon, 18 August 2008 09:43 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Karma: 0
Senior Member
Account Moderator
Slightly change a query; one way would be to use item's alias (which is the same as the item).

For example, if it was the original report query (before you have altered the table)
SELECT text_item 
FROM your_table
rewrite it as
SELECT text_item text_item 
FROM your_table

Doing so, you won't have to change anything else in the report, not even field's source name, and the report will reflect changes made in the database.

Once the report is recompiled, you may remove that column alias.
Previous Topic: regarding column
Next Topic: square box over my field
Goto Forum:

Current Time: Tue Aug 22 11:57:21 CDT 2017

Total time taken to generate the page: 0.04517 seconds