ERPstuff - Oracle EBS Community

I want to write Button Label in multiple line like i have a button and i want a label that

Press
Button

but when i create Button lable did not write in multiple line it should write in single line i want it in multiple row
Please Let me know how can i do it

Thanks


Cheers

I have report in which the data is for example is an Emp when i run the query in a report for a single employe select * from emp where empno =:ENO; the results shows EMPNO ENAME JOB MGR SAL COMM DEPTNO 7499 ALLEN SALESMAN 7698 1600 300 30 EMPNO ENAME JOB MGR SAL COMM DEPTNO 7782 CLARK MANAGER 7839 2...

Dears I have an operating system of XP and Windows NT and i have diffrent reports in my database when i run any repot and then print it my printer did not print but when i run same report in Windows 2000 it prints and when i print other documents Ms-word it prints i have a printer HP LaserJet 1300 P...

It's ok i know about the Ceil i use it frequently but i want to say that how i am using the Cail in a Summary Column r u understand i mean how i use this Ceil in Summary Column.

Najm

By Using 99 or NN it's not Round up the values Mean when i use NN or 99 the number like 2.2 convert into 2 -- but i want it 3 completly roundup 4.2 convert into 4 -- but i want it 5 completly roundup 5.5 convert into 6 -- but i want it 6 completly roundup 6.7 convert into 7 -- but i want it 7 comple...

Dears I have some Marks Like this Marks --------- 8 5 6.5 8.4 4.8 3.3 i want to roundup these all in a report i know how to convert it in a round but i have the column of this marks are function and i think there is a Format Mask field i want to roundup these marks through format mask how can i do t...

Dears I have a query it#8217;s a typical and based on Auditing query The query is!! let me tell the Conditions i simply explain it i have a table of Salary in which the fields are EMPNO, ENAME, SALID (Salary Id), ENTRYDATE i want to know those EMP Whose Salary Raised after the Net Salary Entered Let...

Dears i have a Client i am connecting it to Gl server i use all the ways but when i connect the message shows Packet writer Failure what can i do now I uninstall the Developer and then install again and make a new connection now i have only 1 way left Reinstall the windows can any 1 help me in this ...

I think you can use outer join or innerjoin did you use it before or not.
Thanks

Cheers

Najm

I think most of the peuple do not understand your question please write clearly and easy words.

Thanks


Cheers

Najm

It's very easy you have to go to the datablock of that filed and go to insert allowed option and set value = No

Najm

Here is a Sample Query of If Else by this query i got the result like this

SELECT EMPNO,ENAME FROM
(SELECT EMPNO,ENAME, ROWNUM SI
FROM EMP ORDER BY EMPNO DESC
) ORDER BY CASE WHEN SI=2 THEN 0 ELSE SI END

4 B --- Second Last is on Top in Desc order
5 A
3 C
2 D
1 E

Cheers

Najm

I Lost my Microsoft Access password how can i recover it

Najm

You want it in a report or a Sql Plsql


Cheers
Najm

Najm

In a Report double Click the field of that count then click the Format Mask Drop down list or write in that Lov NNN.NNN...... or if you want in a query use Round(Column_Name,3)

Thanks
Cheers





Najm