SSRS turn off paging

by ebarcza 5/14/2013 10:45:00 AM
You set the report's InteractiveHeight to 0 to disable paging.

Tags: ,

SQL Server Reporting Services

SUBSTRING in SSRS

by ebarcza 11/28/2011 11:43:00 AM
simple really... it's called the MID function in SSRS


MID(str as string, Start as int32, End as int32)


=Mid(Fields!CommodityType.Value, 2, Len(Fields!CommodityType.Value))

Tags: ,

SQL Server Reporting Services

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

Insert New line in RDL or RDLC

by ebarcza 4/20/2011 7:14:00 AM
Adding a new line to a SSRS report RDL textbox is simple =Fields!PeriodStart.Value + vbCrLf + "test"

Tags: , , ,

RDLC

SSRS Blank page at the end of a report

by ebarcza 4/15/2011 7:42:00 AM
I always seem to get a blank page at the end of a report. It starts off just fine but then at some point a blank page will appear at the end. SSRS has a propery called ConsumeContainerWhite space that is set to False by default. Changing the value to true elimates the blank page in most cases. Note that this is a report level property. If it doesn't then make sure the size of the body isn't too big. Reduce the width of the body until the blank page goes away... Hope this helps!

Tags: , ,

SQL Server Reporting Services

Group number in SSRS RDL report

by ebarcza 4/15/2011 7:00:00 AM

I needed to get the running count of Groups in the group header... This expression took care of it -

=RunningValue(Fields!MeterNumber.Value, CountDistinct, Nothing)

Also I needed to hide the Group header for the first Group. To accomplish this i added this expression to the visibility property of the textbox after merging all the cells in the row

=IIF(RunningValue(Fields!PoolName.Value, CountDistinct,Nothing) = 1, true, False

Success!!

Tags: , , ,

VB.NET

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