the edition of reporting services that you are using requires that you use local sql server

by ebarcza 5/5/2011 7:07:00 AM

When using Reporting Services in SQL Server Express you will most likely see this error at some point in time "The feature: the edition of reporting services that you are using requires that you use local sql server relation databases for report data sources and the report server database". is not supported in this edition of Reporting Services"

This error rears its ugly head when trying to view the report in Report Manager. You can, however, run the report in the Business Intelligence Studio just fine.

This is because SQL Express installs with an instance name of ServerName\SQLExpress. Visual Studio seems to ignore this instance name if there is only one instance running. When you deploy to the Server and try to run it through the report manager however you will get the "local sql server" error.

To fix this all you have to do is go into the Datasource and modify the connection string to use the instance name... like this - Data Source="ServerName\SQLEXPRESS";Initial Catalog=YourDatabaseName... I hope this helps!

Tags: , , ,

SQL Server Reporting Services

Setting SSRS Parameters in C#

by ebarcza 2/18/2011 5:02:00 AM

Example of how to set parameters via code behind for an SSRS rdl report

        ReportExecutionService rs = new ReportExecutionService();
        rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
        rs.Url = "http://ServerName/reportserver/ReportExecution2005.asmx";

        ExecutionInfo execInfo = new ExecutionInfo();
        ExecutionHeader execHeader = new ExecutionHeader();

        rs.ExecutionHeaderValue = execHeader;

        execInfo = rs.LoadReport(reportPath, historyID);
        ParameterValue prmCompanyID_1 = new ParameterValue();
        prmCompanyID_1.Name = "iCompanyID";
        prmCompanyID_1.Value = "276";

        ParameterValue prmCompanyID_2 = new ParameterValue();
        prmCompanyID_2.Name = "CompanyID";
        prmCompanyID_2.Value = "276";

        ParameterValue prmProdMonth = new ParameterValue();
        prmProdMonth.Name = "ProdMonth";
        prmProdMonth.Value = "12";

        ParameterValue prmProdYear = new ParameterValue();
        prmProdYear.Name = "ProdYear";
        prmProdYear.Value = "2010";

        ParameterValue[] prmList = new ParameterValue[4] { prmCompanyID_1, prmCompanyID_2, prmProdMonth, prmProdYear };

        rs.SetExecutionParameters(prmList, "en-us");

Tags: , ,

SQL Server Reporting Services

Powered by BlogEngine.NET
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail


<<  September 2022  >>

View posts in large calendar

Recent comments



The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2022

Sign in