Hi All... I have generated a drill down report. now i want a new functionality to be added. a have added a push button on the report output. I want that when i click that button the drill down report output should be save as csv file, upto the level the report is expanded. Can anyone help me out in this??

Kumud Vaish

This message has been edited. Last edited by: Kerry,

The CSV part is easy, just create another drilldown that creates the CSV.

As for the level the report has been expanded to, I assume it is an accordian report ?

Hi Waz
Actually I hv made the same and csv file is working fine. it gets overwritten acc. to data whenever I expand or collapse it. It is fine with less amount of data,but for bulk data this can degrade the performance I believe. So is there any other solution to do the same?? and if u cn provide me the code for the same it would be great help

Kumud Vaish

Have you thought about useing FOCCACHE ?

You could have a copy of the extracted data available, and it should be quicker.

I hv implemented the code as:

-DEFAULT &filename='e:\CSV\kag20.csv';
FILEDEF OUTPUT2 DISK &filename
-------sqlcode-------
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS MYDATA TO HOLD AS FOCCACHE/MYDATA
END
----CSSCODE--------------------
ENDSTYLE
END
SAVE AS OUTPUT2 FORMAT COMT

and, still now my csv is fetting overwritten whenever i am expanding or collapsing my report. Is this code is has bug? Please help me out

Is this your actual code ?

What you need to do is to create the hold file first time through.

Then with each drilldown, don't create the hold file, but just table from it.

You can pass a parameter or check to see if the FOCCACHE file exists to determine which to do.

Then in the report use dialog manager to handle what to do.

e.g.

-IF &HOLDEXISTS EQ 'YES' THEN GOTO SHOW_RPT ;

{Extract part}

-SHOW_RPT

{Report part}

You may have to FILEDEF the hold file in the report part.