[CLOSED] Export to excel

September 23, 2015, 09:01 AM

User1

Hi,

In my report,
there 2 different report in a different fex files.

I need to export both of the report in a single excel.

How do I append the result to the excel.

Thanks,
User1

This message has been edited. Last edited by: <Kathryn Henning>,

September 23, 2015, 09:13 AM

SWES

Hello User1,

Like MartinY and others already suggested, I strongly recommend you to follow WebFOCUS courses. This kind of basic questions is not what Focal Point is meant for.

September 23, 2015, 09:28 AM

Tomsweb

Can you list the fields you will be working with?

September 23, 2015, 09:34 AM

Clayton Peacock

 
-* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
-* This is main procedure exl_rpt_main.fex importing the 2 procedures
-* into main procedure
-INCLUDE exl_rpt1
-INCLUDE exl_rpt2
-EXIT
-* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 

-* This is exl_rpt1.fex

TABLE FILE CAR
HEADING
"By Country"
BY COUNTRY
ON TABLE PCHOLD FORMAT XLSX OPEN NOBREAK
END

-* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
-* This is exl_rpt2.fex

TABLE FILE CAR
HEADING
"By Car"
BY CAR
ON TABLE PCHOLD FORMAT XLSX CLOSE
END