SSRS 2005 deployment to FBA enabled MOSS site

I was having problem to deployed SSRS 2005 Report Model from visual studio to SharePoint Integrated mode with Forms Authentication enabled on MOSS site. It gives an error message "A connection could not be made to report server "http"//<sharepointservername>/"

Though, I was successfully able to deploy SSRS 2005 Report Model from visual studio to SharePoint Integrated mode with Windows Authentication enabled on MOSS site.

I installed SharePoint 2007 server, SQL server 2005 Developer Edition with sp2 and also applied hotfixes from Microsoft for reports to work with Forms Authentication.

I also worked with Microsoft Support team and I tried to find the resolution, at the last I came to one common point that its design limitation of SharePoint and sql server, so Microsoft support team told me that because of security reason, it has been designed that way only.

Few people already notice this bug and some of them get the temporary patch/fix from Microsoft but its not permanent solution, Microsoft is saying that this problem will resolved with SQL Server SP3.

Reference link :

http://www.sharepointblogs.com/nrdev/archive/2007/06/21/ssrs-in-sharepoint-2007-site-using-forms-based-authentication-sharepoint-integrated-mode.aspx

Disabling some file export options in Reporting Service

There are some options available in Reporting services to export reports.

If you want to disable few options from that list into all application on your server then you can make it visible false by editing one central config file named "rsreportserver.config"

You need to make visible false which ever extension you don't want in the list of export report.

But if you want to make this for only one particular application then you can write down below code into your application:

private void DisableUnwantedExportFormats()
{
foreach (RenderingExtension extension in ReportViewer1.ServerReport.ListRenderingExtensions())
{
if (extension.Name == "XML" || extension.Name == "IMAGE" || extension.Name == "MHTML"
|| extension.Name == "PDF" || extension.Name =="RGDI" || extension.Name == "XLTemplate"
|| extension.Name == "WordTemplate" || extension.Name == "HTML4.0" || extension.Name == "HTML3.2")
{
FieldInfo info = extension.GetType().GetField("m_serverExtension", BindingFlags.NonPublic |     BindingFlags.Instance);
if (info != null)
{
Extension rsExtension = info.GetValue(extension) as Extension;
if (rsExtension != null)
{
rsExtension.Visible = false;
}
}
}
}
}