OraFAQ Forum: Reports & Discoverer » Width field in property inspector in read only

Home » Developer & Programmer » Reports & Discoverer » Width field in property inspector in read only

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Width field in property inspector in read only [message #165485]

Thu, 30 March 2006 09:37

khask999
Messages: 2
Registered: March 2006
Location: Portsmouth, VA

Junior Member

I'm using Oracle Reports Builder from Oracle Development Suite 10g.

I'm working with report that is already created and when I double-click on the Data Model icon the Report Editor - Data Model screen comes up. I then double-click on a box named Q_SUM that opens up the SQL Query Statment Box and my query is:

select sum(m10_value_comit),
m10_m23_piin_call_nr
from m10_document_nr
group by m10_m23_piin_call_nr

and another box is created called G_SUM that holds the fields from the query.

The field created from sum(m10_value_comit) has a width of 38 in the property inspector and it is read-only, is there any way that I can make the width property editable in the property inspector?

Thanks,
KSH

Report message to a moderator

Re: Width field in property inspector in read only [message #165523 is a reply to message #165485]

Thu, 30 March 2006 15:23

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I *think* that it means that the datatype of this field is NUMBER(38) - the maximum NUMBER length in Oracle. It, really, means nothing much to you - if nothing else, it makes you sure you won't get out of space.
To adjust it according to your needs, change FORMAT (for example, 999,990.00) used to display the selected value.

Report message to a moderator

Re: Width field in property inspector in read only [message #165679 is a reply to message #165485]

Fri, 31 March 2006 06:56

khask999
Messages: 2
Registered: March 2006
Location: Portsmouth, VA

Junior Member

Thanks for your reply, I should have provided some more information.

The original format mask was NNNNNNNN0.00, I changed it to 999,990.00 and the field is still uneditable
( as is Column Type = Database - Scalar
and Datatype = Number ).
I tried about 10 different formats and still the same.

The m10_value_comit field is defined as Number(9,2) in the database. I think the sum function may be doing something but I'm not sure...

KSH

Report message to a moderator

Re: Width field in property inspector in read only [message #165773 is a reply to message #165679]

Sat, 01 April 2006 13:13

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It appears I didn't understand your question; what do you mean by "read only" and "uneditable"? Would you like to stretch this field? If so, don't try to do it in Data Model, but in Paper Layout; click on the field and drag black squares to set the desired width. Flex and Confine should be set to ON.

Report message to a moderator

Previous Topic:	Oracle Developer Suite 10g
Next Topic:	Automatic reports in Discoverer 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 15:33:57 CDT 2024