ERPstuff - Oracle EBS Community

Thanks Mirza Bahi i am great full to you for this if i need any query i ask you soon thanks again.



Chears

Najm

Report query is select * from emp where ((:p_losal is not null and :p_hisal is not null and sal between :p_losal and :p_hisal) or (:p_losal is null or :p_hisal is null)) /* by this between query if I am not entered any amount, report shows all the records and if I entered any value reports shows ent...

as we saw many techniques relayted to Forms and DBA we firnd their so many tips but we did not find any tips related to Reports is their any side to learn reports with the tips.




Chears

Najm

Dear Administrator i want practicaly. The link you mention is ok but there is not mention in a form that were can i use it and which trigger i use for reports or were can i use it on procedure i mean is it outside to the button or i have to giving a path.


Chears

Najm

I have a procedure and i attached this procedure with a form button when I press the button my database should be hanged for some time and i don't know that how much it takes time therefore i make a Progress Bar (Percentage Bar) to know how much percent left but i am unable to attached it with form ...

Mr. Admin why did you not uploaded the Reports Examples i mean report Tips.

Najm

Thanks It's Work

Najm

For Example i have a Inventry report i run it day by day some day reports print on 2 pages some days it print on 3 pages and some time it print only on 1 page and i mention hardcoded page number in the foter of a report then i learn in book that if i use Place Holder for page number then it is not n...

I think you did not understand please let me know how can i upload any report or form on this forum.

Najm

Very Great full for taking intrust but it does not fulfils the requirement i don't want to run any alter/update query becoz for example today i have a dept no 30 on top then after some days it should be deptno 50,80 or any other highest deptno and as on i want dynamic query.

Najm

Please also Let us know the Latest Price of the Complete Certification Examinations

Najm

I have attendance sheet reports which have the Fields S. No, Name and about to 45 Blank Boxes I think every one is familiar with the attendance sheet I display the S. No, Name through table and create up to 45 Manual boxes but some times I want the attendance sheet of 40 Session some time 15 session...

1 SELECT DEPTNO,DNAME FROM DEPT 2 ORDER BY DEPTNO DESC DEPTNO DNAME --------- -------------- 40 OPERATIONS 30 SALES 20 RESEARCH 10 ACCOUNTING i want the Second Highest Deptno on the Top and the others are as it is Which query is Apply there fore the result like this DEPTNO DNAME --------- ----------...

I know the General Formula to Calculating GPA but i am unable to calculate CGPA therefore i make another table in which i calculate and insert GPA / CGPA is there any way to calculate GPA / CGPA through Query or through functions.

Najm