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
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: 21123
Registered: June 2005
Location: Croatia, Europe
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: report help related to frame elasticity
Goto Forum:

Current Time: Tue Jun 27 04:04:21 CDT 2017

Total time taken to generate the page: 0.05527 seconds