Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

Monday, February 20, 2012

Report Renderiring in EXCEL ..

I am using Reporting Services 2000 Service Pack 2, on a .NET 2003
Plateform. - ASP .NET in a VB .NET Project.
I have disabled the EXCEL from my default renedering formats by placing
Visible="false" in RSReportServer.config file for EXCEL.
Now the problem is that I want one report to export to excel. How can I
achieve this without changing the above line?
If anyone could tell me about an article or example implementation of the
same. I will realy appreciate.Are you using SSRS in a custom application. Disabling visiblity on the config
file is for the whole reports and not for individual reports. In that case if
you are in a custome app. then you can use URL access for generating excel or
you can use render method of the rs web serives.
Amarnath
"Tanveer Malik" wrote:
> I am using Reporting Services 2000 Service Pack 2, on a .NET 2003
> Plateform. - ASP .NET in a VB .NET Project.
> I have disabled the EXCEL from my default renedering formats by placing
> Visible="false" in RSReportServer.config file for EXCEL.
> Now the problem is that I want one report to export to excel. How can I
> achieve this without changing the above line?
> If anyone could tell me about an article or example implementation of the
> same. I will realy appreciate.
>
>

Report Render Format Excel: name on each Sheet

Hello;

There is any way to put a name to each sheet when using Render Format to Excel file?

Thanks

Luis

Quick answer: this is currently not supported.

You might want to review the following related threads:

* http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1713177&SiteID=1

* http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=309746&SiteID=1

-- Robert