Microsoft Excel report generation from Oracle Forms 10g

5 pts.
Tags:
Microsoft Excel
Oracle Forms
Oracle Forms 10g
Oracle interoperability
Oracle reporting
what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you want to generate the excel documents at the client side, you could use WebUtil.

Have a look at the following pages:

——————

You will find that there is no good way … The best way I found was generating an HTML file using webutil …

-Jfryynmt

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • jashim
    thanks'

    40 pointsBadges:
    report
  • keshavdev
    DECLARE
       v_outfile text_io.file_type;
       v_outstring      varchar2(1000);
       v_outstring1      varchar2(1000);
       L_EMP_CODE       NUMBER(10);
       L_InvDate        Varchar2(10);
       L_CheqDate       Varchar2(10);
       L_TOTAL          NUMBER(15,3);
         TOTAL            NUMBER(15,3);
         L_TOTAL_UNITS    NUMBER(15,3);
         L_INOCULINE_QTY1 NUMBER:=0;
         L_INOCULINE_QTY2 NUMBER:=0;
         L_INOCULINE_QTY3 NUMBER:=0;
         L_SRNO           NUMBER:=0;                
         L_AMT            NUMBER(15,2);
         L_NAME           VARCHAR2(100);
         L_BALANCE                 NUMBER(15,2);
         L_EARN_SUM             NUMBER:=0;
         L_TOT_SUM                 NUMBER:=0;
         L_AMT_SUM                 NUMBER:=0;
         L_BAL_SUM                 NUMBER:=0;
       
       
       CURSOR CUR_EMPLOYEE  IS                    
                        SELECT A.EMP_CODE,NVL(SUM(A.NET_BASIC),0) EARN_BASIC              
                    FROM BPAYT_SALARYREG A, BPAYT020 B
                    WHERE A.EMP_CODE = B.EMP_CODE
                    AND B.EMP_MEDI ='Y'                               
                   -- WHERE   TO_CHAR(SAL_MONTH,'MON-RRRR') BETWEEN TO_CHAR(:BPAYT551.FROM_DATE,'MON-RRRR') AND TO_CHAR(:BPAYT551.TO_DATE,'MON-RRRR')
                    AND   A.SAL_MONTH BETWEEN :BPAYT551.FROM_DATE AND :BPAYT551.TO_DATE                
                    GROUP BY A.EMP_CODE
                    ORDER BY A.EMP_CODE;
                    
            
    BEGIN    
        
                IF :BPAYT551.FROM_DATE IS NULL THEN
                        :CONTENT.MESSAGES:='PLEASE ENTER DATE....';
                    RAISE FORM_TRIGGER_FAILURE;
                END IF;
                
                
                IF :BPAYT552.EMP_CODE IS NULL THEN
                    :CONTENT.MESSAGES:='FIRST POPULATE DATA....';
                    RAISE FORM_TRIGGER_FAILURE;
                END IF;
                    
        
                 V_outfile := text_io.fopen('C:\ERP\MEDICAL.CSV','w');
                TEXT_IO.PUT_LINE(V_OUTFILE,V_OUTSTRING);
                
                V_OUTSTRING :=''||'COMPANY NAME :-'||','||','||:G_COMP_TITLE;
                TEXT_IO.PUT_LINE(V_OUTFILE,V_OUTSTRING);

             V_OUTSTRING :=''||'DATE FROM :-'||','||:BPAYT551.FROM_DATE||','||' DATE TO :-'||','||:BPAYT551.TO_DATE    ;
               TEXT_IO.PUT_LINE(V_OUTFILE,V_OUTSTRING);


                V_OUTSTRING :='Sr #'||','||'Employee Code'||','||'Employee Name'||','||'Earn Basic'||','||'8.33% Of EB'||','||
                'Actual Paid'||','||'Balance';
            
                    
                TEXT_IO.PUT_LINE(V_OUTFILE,V_OUTSTRING);
            
            V_outstring := '';
            TEXT_IO.PUT_LINE(V_OUTFILE, V_OUTSTRING);
             
           GO_BLOCK('BPAYT551');
           FIRST_RECORD;
       
            
       
           FOR REC_EMPLOYEE IN CUR_EMPLOYEE  LOOP
               
                    SELECT EMP_FNAME||' '||EMP_LNAME INTO L_NAME FROM BCOMT006
                   WHERE EMP_CODE = REC_EMPLOYEE.EMP_CODE;
                   
     
            L_SRNO :=  L_SRNO +1;
            L_AMT := GET_MEDI_AMT(REC_EMPLOYEE.EMP_CODE,:BPAYT551.FROM_DATE,LAST_DAY(:BPAYT551.TO_DATE));
            L_TOTAL := NVL((REC_EMPLOYEE.EARN_BASIC * 8.33) /100,0);
            L_BALANCE := NVL(L_TOTAL - L_AMT,0);
         
                     V_outstring := L_SRNO     ||','||
                       REC_EMPLOYEE.EMP_CODE   ||','||
              L_Name                  ||','||
              REC_EMPLOYEE.EARN_BASIC ||','||
              L_TOTAL                 ||','||
              L_AMT                   ||','||
              L_BALANCE;
                   
             
                 TEXT_IO.PUT_LINE(V_OUTFILE, V_OUTSTRING);
       
                                      
                                     L_EARN_SUM := NVL(L_EARN_SUM + REC_EMPLOYEE.EARN_BASIC,0);
                                     L_TOT_SUM :=  NVL(L_TOT_SUM + L_TOTAL,0);
                                      L_AMT_SUM := NVL( L_AMT_SUM + L_AMT,0);
                                      L_BAL_SUM := NVL(L_BAL_SUM + L_BALANCE,0);
                     
                     ----------------------
                            
              V_OUTSTRING1 := ','||','||'GRAND TOTAL'||','||L_EARN_SUM||','||L_TOT_SUM||','||L_AMT_SUM||','||L_BAL_SUM;


       
           END LOOP;
                TEXT_IO.PUT_LINE(V_OUTFILE,V_OUTSTRING1);
           
            text_io.fclose(v_outfile);
           FIRST_RECORD;
           :content.messages := 'File (C:\ERP\MEDICAL ) Generated Successfully....';
           
           EXCEPTION
               WHEN OTHERS THEN
               MESSAGE(' ' );PAUSE;
           
    END;
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following