| Report Editing [message #341361] |
Mon, 18 August 2008 09:34  |
*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  |
 |
Littlefoot
Messages: 21808
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 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
