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);
        //execInfo.Parameters[0].
        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 1.5.0.7
Theme by Mads Kristensen

About the author

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

E-mail me Send mail

Calendar

<<  September 2017  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar

Recent comments

Tags

Disclaimer

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

© Copyright 2017

Sign in