Hi All,

I have learned that whenever we run a drill down report the database get hit for the first time, for the data retrieval. When we click any drill down link, the database again gets hit.
I am finding any solution to this, such as when data hits for the first time,it should get store in cache at client and when I click on some drill down link,data should get populated to report from client cache.

Can anyone help me out in this???

-Regards
-Kumud Vaish

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

Do a search on this forum for the term 'foccache'. You'll probably get exactly what you're looking for...

But be aware that
(a) foccache expires
(b) foccache is accessible only to the same user, in the same browser session

So, if the intention is that the output of a run may be stored and distributed to other users, or stored and reopened by the same user, the drilldown report needs to sense whether the file (synonym and data) still exists in foccache -- and, if not, the drilldown report program must be able to proceed without it.

Thanx a ton Gamp and j.gross

I am working on the same n hope it works. Please do help me further if I don't find any solution on it.

-Regards
-Kumud Vaish

TABLE FILE CAR SUM DC RC BY MODEL BY SEATS
OB TABLE HOLD AS FOCCACHE/MYSTUFF
END
TABLE FILE FOCCACHE/MYSTUFF
SUM DC RC BY MODEL
(DRILL DOWN ON MODEL TO THE DETAILS.FEX)
EMD

The detail fex does:

TABLE FILE FOCCACHE/MYSTUFF
PRINT RC DC BY SEATS
WHERE MODEL EQ '&MODEL'
END

But add the robustness in detail fex to deal with the MYSTUFF files not being there.

Thanks for the help guys!!!

-regards
-Kumud Vaish