I have a subreport inside my report. I am passing paramter. I would like to use action, jump to subreport. For some reason it doesnot work in excel when jumping to subreport-- getting a error message. Is it possible in SSRS 2008 ? simam

Hi Simam, According to your description, I was able to reproduce the issue. When we export a report to Excel, the drillthrough links are rendered as Excel hyperlinks. When clicking a link, it opens the default browser and navigates to the HTML view of the target. It seems that the URL of the target report may not be parsed correctly and an error message appears in the browser. To work around the issue, I suggest that you use the Go to URL action instead of the Go to report action. Before we add the drillthrough, we need to deploy the drillthrough report to the report server. Lets assume the URL of the target drillthrough report is http://msdn.microsoft.com/en-us/library/ms152835.aspx http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/3986f13d-e7ef-4bf4-b638-9af082f646b0 If you have any questions, please feel free to let me know. Regards, Mike Yin

Hi Simam, Due to an unexpected issue with the forum, some content of my reply were missing. Here I have posted the complete reply below: According to your description, I was able to reproduce the issue. When we export a report to Excel, the drillthrough links are rendered as Excel hyperlinks. When clicking a link, it opens the default browser and navigates to the HTML view of the target. It seems that the URL of the target report may not be parsed correctly and an error message appears in the browser. To work around the issue, I suggest that you use the Go to URL action instead of the Go to report action. Before we add the drillthrough, we need to deploy the drillthrough report to the report server. Lets assume the URL of the target drillthrough report is /reportserver?/Reports/test&rs:Command=Render">http://<servername>/reportserver?/Reports/test&rs:Command=Render& REPORTEIN= & Fields!REPORTEIN.Value If the parameter REPORTEIN is a single value parameter, you can set the expression of the drillthrough action to: = http://msdn.microsoft.com/en-us/library/ms152835.aspxhttp://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/3986f13d-e7ef-4bf4-b638-9af082f646b0 If you have any questions, please feel free to let me know. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Hi Simam, Due to an unexpected issue with the forum, some content of my reply were missing. Here I have posted the complete reply below via an embedded screenshot: According to your description, I was able to reproduce the issue. When we export a report to Excel, the drillthrough links are rendered as Excel hyperlinks. When clicking a link, it opens the default browser and navigates to the HTML view of the target. It seems that the URL of the target report may not be parsed correctly and an error message appears in the browser. References: http://msdn.microsoft.com/en-us/library/ms152835.aspxhttp://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/3986f13d-e7ef-4bf4-b638-9af082f646b0 If you have concerns on the reply, I suggest that you create a new thread and we will continue working with you on the issue. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Mike, Thank you for work around, problem is we are not using report server. We have our own application which run the reports for different companies and send them all together. Thank yousimam

Hi Shimam, Thanks for your feedback. Now that you use reports in custom application not on a report server, I suggest that you use the drilldown action instead of the drillthrough action. In Reporting Services, we can create a drilldown report to show/hide a report item by clicking the +/- symbol. For more information, please see: How to: Add a Visibility Toggle to an Item Additionally, if you are working with .NET Framework applications, you can add full-featured reports to custom applications by using the ReportView controls. The ReporViewer control provides the capability to render reports that exist in an environment where a report server has not been installed (local processing mode). In local processing mode, all report processing is performed on the computer that hosts the application and all data used by the report is provided by the host application. For more information, you can refer to: ReportViewer Controls Hope this helps. Regards, Mike Yin

Hi Shimam, Thanks for your feedback. Now that you use reports in custom application not on a report server, I suggest that you use the drilldown action instead of the drillthrough action. In Reporting Services, we can create a drilldown report to show/hide a report item by clicking the +/- symbol. For more information, please see: How to: Add a Visibility Toggle to an Item Additionally, if you are working with .NET Framework applications, you can add full-featured reports to custom applications by using the ReportView controls. The ReporViewer control provides the capability to render reports that exist in an environment where a report server has not been installed (local processing mode). In local processing mode, all report processing is performed on the computer that hosts the application and all data used by the report is provided by the host application. For more information, you can refer to: ReportViewer Controls Hope this helps. Regards, Mike Yin

Hi Mike I am not getting any alert in my mailbox due to some reason. Am I the only one who is facing this problem? Please replyPlease let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click Mark as Answer if this resolves your problem or Vote as Helpful if you find it helpful.

Mike, Before trying drillthrough action I was trying to use drilldown. Problem in drilldown is the column which has subreport is too wide(based on the size of the subreport( doesn't look good). My subreport has 10 columns I don't like the expanded sell where I have drill down invisible. I hope you understand what I am trying to explain. Thank you simam