drill down - Default sheet in an excel workbook

[mondans.sureshbabu]

Heya all,

I am expected to create a drill down to a report which'll generate an excel, which is a piece of a cake but now my requirement is to show one of the excel sheets in the workbook as default without altering the sheet order.

Eg., if the excel output has Sheet1,Sheet2 and Sheet3 I want to keep Sheet3 as default when the user opens the o/p.

Please let me know if its possible, if yes how will we achieve it.

-Thanks
Suresh

[jeetu]

Hi ,
So far this kind of feature is not available for Excel, the best option here is to change the page ordering  in page explorer-> report pages.

[mondans.sureshbabu]

 :o :o Thanks for that jeetu. I am kind of suprised, hopefully something comes up in the future. For now, I guess I have to be happy with re-ordering the pages manually only :(

The point of me searching this options is, This report will be a standalone report as well so only when I drill down I want Sheet3 to come up first,  when the report is run as a stanalone one don't want the page order to be altered.

Anyways I'll talk to user and see if I can create a copy for drill down alone. Thanks once again for your help.

-Suresh