Home » Developer & Programmer » Reports & Discoverer » Can't edit report field width to match changed db field width (Oracle Reports, 10.1.2.3, Linux)
Can't edit report field width to match changed db field width [message #444139] Thu, 18 February 2010 17:07 Go to next message
dlwixon
Messages: 92
Registered: September 2008
Member
I have an Oracle Report.

After creating the report, I changed a field width on the database table from varchar2(4) to varchar2(20).

Now Oracle reports won't let me change the field width on the report field to match the database field width.

Anyone?
Re: Can't edit report field width to match changed db field width [message #444141 is a reply to message #444139] Thu, 18 February 2010 17:44 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member
I was able to fix this by deleting the columns from the report layout and from the query, recompiling, adding back to the query and then back to the layout.
Re: Can't edit report field width to match changed db field width [message #444145 is a reply to message #444141] Thu, 18 February 2010 21:09 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
which version you are using?
Oracle Reports, 10.1.2.3, Linux)
Is that 10.1.2.3 your database version?
Quote:
Now Oracle reports won't let me change the field width on the report field to match the database field width.

If you assign the source for that field in the layout then it will automatically takes the width then why you are assigning the width for that ?

sriram Smile
Re: Can't edit report field width to match changed db field width [message #444192 is a reply to message #444139] Fri, 19 February 2010 04:16 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
I think you'll find the problem was that the width the field was set to was the width of the db column before he changed it.
Previous Topic: Placeholder column
Next Topic: Discoverer reports with a particular item
Goto Forum:
  


Current Time: Fri Dec 09 08:11:11 CST 2016

Total time taken to generate the page: 0.06475 seconds