Report Editing [message #341361] |
Mon, 18 August 2008 09:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Hi guyz,
i create one report after that i increse the length in database
table.
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 ?
Regards
[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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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 asSELECT 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.
|
|
|