Home » Developer & Programmer » Reports & Discoverer » ADD FIELD TO REPORT
ADD FIELD TO REPORT [message #513291] Sat, 25 June 2011 21:03 Go to next message
hassan08
Messages: 91
Registered: June 2011
Location: egypt
Member
really i faced problem and i cant solve it
i have query in report builder such as

select ename,sal,empno
from emp
when want to add new column such as "hiredate" in this query
the value no appear

and try mor than times


[Topic title typo fixed by LF; was "FILED" instead of "FIELD"]

[Updated on: Tue, 28 June 2011 15:46] by Moderator

Report message to a moderator

Re: ADD FILED TO REPORT [message #513297 is a reply to message #513291] Sun, 26 June 2011 03:01 Go to previous messageGo to next message
vamsi kasina
Messages: 2095
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Adding column in the query doesn't show the column.
You need to add the field in the layout editor.

By
Vamsi
Re: ADD FILED TO REPORT [message #513575 is a reply to message #513297] Tue, 28 June 2011 05:25 Go to previous messageGo to next message
hassan08
Messages: 91
Registered: June 2011
Location: egypt
Member
I CAN SEND TO YOU THE TABLE AND REPORT TO ADD THIS FILED
SEND TO YOU PRIVATE MESSAGE ?
because i need to solve this problem but i cant
Re: ADD FILED TO REPORT [message #513665 is a reply to message #513575] Tue, 28 June 2011 12:31 Go to previous messageGo to next message
Littlefoot
Messages: 19510
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is a simple report you are talking about. Its layout is simple as well (most probably). It means that you could use it to practice and test your skills in adding another field to query (which you managed to do) and layout. It is not a simple task, as you need to resize frames, possibly move current fields and/or labels, add new ones, etc.

By far the simplest way is to delete current layout (as it is simple) and let Wizard do the job for you. Then you'd make it fancy, if necessary. On the other hand, if current layout is a complex one, deleting and starting over from scratch might not be the optimal solution. That's why you should give your best now, when things are simple, get a routine and be able to cope with more complex problems in the future.

Having someone to do that for you might solve your problem (short term), but would be counter-productive later. In my opinion, you should do that by yourself.
Re: ADD FILED TO REPORT [message #513675 is a reply to message #513291] Tue, 28 June 2011 15:32 Go to previous messageGo to next message
hassan08
Messages: 91
Registered: June 2011
Location: egypt
Member
OK MY PROBLEM SOLVED IT
THANK YOU
ALL
Re: ADD FILED TO REPORT [message #513679 is a reply to message #513675] Tue, 28 June 2011 20:48 Go to previous message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Please read point no # 6 :-Do not post in all capitals http://www.orafaq.com/forum/t/88153/0/
Previous Topic: blink option in pdf report
Next Topic: Drill-down report from another Drill-down report
Goto Forum:
  


Current Time: Wed Aug 27 18:07:56 CDT 2014

Total time taken to generate the page: 0.15699 seconds