Thanks Mirza Bahi i am great full to you for this if i need any query i ask you soon thanks again.
Chears
Najm
Search found 74 matches
- Mon May 08, 2006 4:22 am
- Forum: Oracle Forms & Reports
- Topic: Learn Some Interesting Forms Techniques
- Replies: 5
- Views: 10220
- Fri May 05, 2006 2:52 am
- Forum: Oracle Forms & Reports
- Topic: Report Query
- Replies: 4
- Views: 1911
Report Query
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...
- Thu May 04, 2006 2:11 am
- Forum: Oracle Forms & Reports
- Topic: Were did we find Report Technique
- Replies: 2
- Views: 2262
Were did we find Report Technique
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
Chears
Najm
- Sat Apr 29, 2006 7:15 am
- Forum: Oracle Forms & Reports
- Topic: Progress Bar Attachement
- Replies: 2
- Views: 2144
- Sat Apr 29, 2006 3:43 am
- Forum: Oracle Forms & Reports
- Topic: Progress Bar Attachement
- Replies: 2
- Views: 2144
Progress Bar Attachement
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 ...
- Sat Apr 29, 2006 1:33 am
- Forum: Oracle Forms & Reports
- Topic: Learn Some Interesting Forms Techniques
- Replies: 5
- Views: 10220
- Fri Apr 28, 2006 7:50 am
- Forum: Oracle Forms & Reports
- Topic: Report Parameter Query
- Replies: 4
- Views: 2656
- Fri Apr 28, 2006 7:21 am
- Forum: Oracle Forms & Reports
- Topic: PlaceHolder
- Replies: 4
- Views: 3545
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...
- Fri Apr 21, 2006 4:47 am
- Forum: Oracle Forms & Reports
- Topic: Attendance Sheet of selective Number of Sessions.
- Replies: 5
- Views: 3292
- Fri Apr 21, 2006 4:36 am
- Forum: Oracle Forms & Reports
- Topic: Report Parameter Query
- Replies: 4
- Views: 2656
- Thu Apr 20, 2006 4:17 am
- Forum: General / Others
- Topic: Oracle database prices
- Replies: 1
- Views: 2031
- Thu Apr 20, 2006 3:21 am
- Forum: Oracle Forms & Reports
- Topic: Attendance Sheet of selective Number of Sessions.
- Replies: 5
- Views: 3292
Attendance Sheet of selective Number of Sessions.
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...
- Thu Apr 20, 2006 2:35 am
- Forum: Oracle Forms & Reports
- Topic: Report Parameter Query
- Replies: 4
- Views: 2656
Report Parameter Query
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 --------- ----------...
- Wed Apr 05, 2006 8:14 am
- Forum: Oracle Forms & Reports
- Topic: GPA / CGPA Calculation Through Query / Function
- Replies: 1
- Views: 1646
GPA / CGPA Calculation Through Query / Function
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
Najm