Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 drillthrough issue

Author  Topic 

adeshpande
Starting Member

1 Post

Posted - 2013-03-18 : 02:59:23
Hi ,

My question may be a bit simplistic,but can i drill through from one excel sheet to another?

I have researched quite a bit and some say it cannot be done??? I have doubts.

In layman terms,i want my 2nd level drill through report to open in a new excel sheet/tab and not in a plain HTML page. Can it be done? if yes,how?

Appreciated.

A

A

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-18 : 12:36:50
you can add rs:Format=Excel parameter to get report in excel format.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -