I have been creating some reports in SSRS 2008 R2. When I need to make borders that show up for all rows, both on the top and bottom of the report, as well as all the rows in between I can tell that the inner borders of the report are thicker because it is actually 2 borders side by side. Is there a way to collapse borders that are side by side?

One of our SSRS reports loads images from external sources and one of these sources has been locked down to tls 1.2 (which is fair and we're expecting more of our clients to be doing this in the future) The tls 1.2 update has been applied to the server holding the ReportServer database and the two Reporting Services endpoints held on seperate machines. All three machines have been tested locally and can all load the secured image in their browsers but when a report is ran using SSRS it fails I've set up a report for testing which has no database connection, it is simply a non secured image link and a tls 1.2 secured image link, The error I get is: Warning [rsInvalidImageReference] The ImageData for the image ‘Image2’ is invalid. Details: The request was aborted: Could not create SSL/TLS secure channel. This leaves the image as src(unknown) in the actual report So I feel like I've missed something in the installation of the tls 1.2 patch Anyone have any ideas what might be going on?

I'm dealing with a scenario where SSRS is being provided to remote clients on a different domain. We've discovered that they can launch Report Builder (a ClickOnce application) from their Report Manager browser session, but RB then uses their local credentials when trying to do anything (e.g. hit a datasource) in the RB session. This article (http://technet.microsoft.com/en-us/library/ms365173(v=sql.105).aspx) seems to indicate that it won't be possible to hack our way around this; whereas this one about Azure (http://msdn.microsoft.com/en-us/library/windowsazure/dn189155.aspx) appears to indicate that a local RB session may be able to interact successfully with Azure - does this suggest there's a glimmer of hope? We are currently running SQL 2008 R2.

I am trying to get the last second of the last month as a default value for a parameter. I can get the last day of the last month from this query on social.msdn.microsoft.com > last month last day expression: DateValue(DateAdd("D",-1,DateAdd("D",-(Day(Now)-1),Now))) The about would return 12am of the last day of the month. Starting with that I made one change so that I can get the last second of the last month. =DateValue(DateAdd("S",-1,DateAdd("D",-(Day(Now)-1),Now))) That does not work though as the time is still set to midnight. How do I get the last second of the last month as a datetime value? --- This has no affect on underlying queries that deal with report data. This is purely about showing an end user the start and end dates in a report header. "9/1/2018 00:00:00 to 9/30/2018 11:59:59" "9/1/2018 00:00:00 to 10/1/2018 00:00:00". The former example to my end users is clearer that the data is in the month where as seeing number for the next month (like in the second example) is ... unsettling

I am new to SQL Server Reporting Services and report designing; can anyone help me in this? I have two questions: 1. How can I create a column for users to input data? After that, I need to perform some operations on the data entered by the user, which I need to display in another column. 2. How can I round a decimal to the nearest integer? For example, 6.03 to 6 and 6.52 to 7.

How do I show a message if none of the rows returned have a specific value? If all of the results in a report have a status of "OK", I want to return a message indicating that there were no warnings. How can I do that? Steve

I know the we can use custom code in SSRS and I know you have actions on Textbox items in a SSRS report. Is it possible to "combine" this functionality for the following, which I appreciate is quite out the normal use of SSRS I wish to produce a list of outstanding requisitions for purchase orders from the SQL tables of our ERP system. In the report against each item would be a Text box with the word "Approve" in The idea is for the requisitions the user wishes to approve they would click on the "Approve" and then use the custom code would fire a SQL procedure, passing in the id of the requisition to the procedure. This procedure would interact with the ERP system to do the approval. Is this possible? Some pseudo code for the SSRS report code Imports System.data.sqlclient Dim connectionString AS String = "Server=XXXXXXX;Database=db1234;User Id=user_name;Password=my_password" Dim Command As New SQLCommand("[CHC_AppBuilder].[Testssrscall]", connectionString) Command.CommandType = CommandType.StoredProcedure Command.ExecuteNonQuery() The SQL procedure [CHC_AppBuilder].[Testssrscall] just currently executes dbmail to myself Problems so far: 1. Location of the System.data.sqlclient.dll to add the references as per you would in visual studio, so far not been able to test the code. 2. Trigger the Stored procedure per item.

I am trying to migrate our SSRS 2008R2 server to a fresh install of SSRS 2016. I am using ReportSync and have managed to get connect to both servers OK. I created a test folder with a test report on the 2008 server and have migrated that fine to the 2016 server. The problem is arising when I am trying to migrate the Data Sources folder. As you can see from the screen shot, there is not plus symbol next to this folder, suggesting it is empty, yet when I browse the folder using the Reports Manager in Internet Explorer, I can see the Data Sources there. Furthermore, we have a Data Source in the Datasets folder (don't ask!) and when I expand that folder out in ReportSync, I cannot see this Data Source. The credentials I have used in the ReportSync tool are the same as I am browsing the webpage with and this is a domain account. The account is in the BUILTIN\Administrators group which has "Content Manager" role on the Data Sources folder

Is it possible to encrypt 2008 R2 backups like TDE for instance? What I've read is encrypting the whole database and that way the backups will be encrypted. But can you have TDE encrypted backups alone?

How to use OR in IIF statement in SSRS =IIF((Fields!txtCurrentSubjectReportName.Value="", Fields!txtSubjectArchivedName.Value, Fields!txtCurrentSubjectReportName.Value) = "School Life" OR "My goal for this term..." OR "Student Reflective Comment", True, False) Its throwing error

We have to migrate our existing SSRS database from an old SQL server to our new SQL cluster. With this opportunity we would like to install de the reporting server on separate machine from the database. I have installed SQL Server Reporting Serv**ice** on a new server, but came to the conclustion that de tool uses the reporting server from the old database... Is it possible to have the reporting on a separate server including the web server?

I have a relatively new instance on SSRS 2008R2 SP3 running on Windows Server 2008 R2. I am trying to set up separate domain service accounts for the separate SQL Services i.e. agent, engine, reporting, etc. I have done this successfully for the Agent and Engine services using simple Domain accounts and following the required permissions from learn.microsoft.com . At first I had made local accounts for all services because of a video I watched that used that as an _example_. So now that I actually wanted to start using reporting services I switch the account to a newly created Domain account. Using the pertinent section in the above article I configured, via GPO, the account to have "Log On As A Service" right. I ensured that right is present in the groups I created. I then went into the Reporting Services Configuration Manager to change the account which was successful except that the step for starting the service ended in error.

System.InvalidOperationException: Cannot start service ReportServer on computer 'SQLSERVER01'. ---> System.ComponentModel.Win32Exception: Access is denied
   --- End of inner exception stack trace ---
   at System.ServiceProcess.ServiceController.Start(String[] args)
   at System.ServiceProcess.ServiceController.Start()
   at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

Event Viewer has a similar error which I include to save the questions.

The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error: 
Access is denied.

So this is a Windows permission issue but I don't see what the problem could be since the Log On As a Service permissions are set correctly. That is verified by the security logs that show a successful logon of the account. If I make my service account a local admin on the server then the service starts correctly but I should not have to do that.

I am creating a Dynamic CRM 2011 Report in SSRS. I use several joins, And use GUID in joins. For ex : Quote.OpportunityId=Opprtunity.OpportunityId The problem comes from parameters. I have a parameter which its label is a name and the value is GUID of a record. I retrieve them from a Dataset. The query of the this Dataset(named siteDataset) is this : select site.SiteId, site.Name from Site; the siteId goes to the value of the parameter and site.name goes to the label of the parameter, the Parameter is named siteId itself. But when I try to do this in another DataSet : siteGUIDInAnotherEntity='@siteId' Give me the subject Error. I even tried this : CONVERT(VARCHAR(50), site.SiteId) in siteId DataSet; But no success. Any help will appreciated.

__Current Environment__ I am in a bit of trouble here, I have a Reporting Services installed on one server and SQL Server database engine installed on another server. The users are connecting to Reports Manager which obviously points to the server where Reporting Services are installed. User use a generic login (a local admin account on the Report Server) to connect to the reports manager. But when the users click on the Report Builder button on the Reports Manager, It initially failed to launch complaining `"Application cannot retrieve the files. Authentication failed." After a lot of research I found out that, even though users entered the credentials of a Local account when connecting to the Reports Manager, but when they clicked on the Report Builder button, the credentials from their windows account were picked up hence the ClickOnce application failed to Authenticate the user and failed to Launch. I changed this behavior by allowing Basic Authentication on Reporting Server and Allowing Anonymous Authentication on Reports Builder. Now when the users click on the Report Builder instead of report builder just picking the credentials from the current user windows account it prompts for the credentials , the user passes the credentials of the Local Admin account on the reporting server and the ClickOnce Application is downloaded as expected. __Problem__ Now the report builder is launched fine and I can right click the The datasources folder in the left pane of the designer, browse for the available data sources , test connection (shows tested successfully) . But as soon as I click on the DataSet and try to add a new dataset it throws an error saying "Authentication failed, cannot connect to the datasources." Even though in the last step the connection test was successful but at this stage it is failing. __Important Note__ The SQL Server has no external IP, it can only be seen from the reporting server. Could this be the reason that the connection is failing? I mean does the report builder try to obtain a direct connection to the SQL Server when launched? Or is there anything else that I have missed out? Any pointer any suggestions are much appreciated , Thank you.

I have 7 pages in my SSRS report and also I'm used page break option. Is there any way available to export all the pages in single excel sheet. Please provide me solutions

I am creating a Report in SSRS. Its a Dynamic 2011 CRM Report. I have created some Tables. And some Rectangles. Each Rectangle contains some Tables. Also there is a Parameter that contains value from 1 to 4. It is a multiple values parameter. The goal is that the user select parameters( one or more ) and then tables based on the rec visibility condition appear.( Maybe two rec appear, or maybe all of them) We all know that there is IN operator in SQL Syntax. But I do not know how to make it here. I googled a lot but no success. Here is what I tried in rec visibility. =Parameters!type.Value.Equals("1") And in the second table : =Parameters!type.Value.Equals("2") till the last rectangle. Even changed to : =Parameters!type.IsMultiValue.Equals("1") I Also Put both of them in =iif, but no success. How can I perform this? Visibility of rectangle based on the multiple values parameter. Any help will appreciated.

I've got a SSRS report which is used for a wallboard to display basic stats and information to the department via a Raspberry Pi attached to a creen This has the AutoRefresh Option set to 60s however since patching today where we turned on Snapshot Isolation to remove a lot of blocking that was occuring every morning and mid afternoon when the daily reports ran the auto refresh option seems to be failing. I've tried re-deploying the report and even created a completely new report that just puts up the date& time to keep track of it refreshing, it sometimes works for a few minutes but then just stops refreshing The tests I ran included a refresh every 10 seconds to see if it was timing out the execution running over 60 seconds Out of the 5 separate executions I have just ran, one ran for 542 seconds before no longer refreshing, one ran for 339 one for 164 and two of them failed to refresh at all Previous this would run until the wifi connection was lost on the Pi and the page errors while refreshing (NOTE all testing has been done locally on wired connection no network drops) previous tests before that set have been done across different browses in / out incognito mode and all produce the same results Any idea why this is happening, and potential fix that doesn't involve us stopping everything on the server again to turn off Snapshot issolation

I'm developing a Report in SSRS for MS CRM 2011. There is a table named StringMapBase which contains Option Set we have declared in different entities. This table has Value and AttributeValue column. Every option Set I have created in any entity, has the Value(which is the name of that) and AttributeValue(which is the name I have choosed for that option set) in the StringMapBase table. If I named an Option Set, I should read the the name from StringMapBase. Like this : select SalesOrder.new_Order_Code, orderreceiptstep.new_NextFollow, orderreceiptstep.new_realization, StringMapBase.Value, orderreceiptstep.AccountIdName, orderreceiptstep.TotalReceivableAmount, orderreceiptstep.name, orderreceiptstep.DueDate, orderreceiptstep.ReceiptStepTypeIdName, StringMapBase.Value, from orderreceiptstep inner join StringMapBase on (orderreceiptstep.OrderReceiptStepStatus=StringMapBase.AttributeValue and StringMapBase.LangId=1065) It gives me the name of one Options Set. Now, The problem is that I have another Option set on the same entity that should get the name of that. It means I need another Inner Join Like above, Like this : inner join StringMapBase on (orderreceiptstep.OrderReceiptStepPrioriy=StringMapBase.AttributeValue and StringMapBase.LangId=1065) In the first I Used orderreceiptstep.OrderReceiptStepStatus of orderreceiptstep table and in the second I used orderreceiptstep.OrderReceiptStepPrioriy in the Inner Join clause. I want to Have These two joins on the same field, Like this : select SalesOrder.new_Order_Code, orderreceiptstep.new_NextFollow, orderreceiptstep.new_realization, StringMapBase.Value, orderreceiptstep.AccountIdName, orderreceiptstep.TotalReceivableAmount, orderreceiptstep.name, orderreceiptstep.DueDate, orderreceiptstep.ReceiptStepTypeIdName, StringMapBase.Value, from orderreceiptstep inner join StringMapBase on (orderreceiptstep.OrderReceiptStepStatus=StringMapBase.AttributeValue and StringMapBase.LangId=1065) inner join StringMapBase on (orderreceiptstep.OrderReceiptStepPrioriy=StringMapBase.AttributeValue and StringMapBase.LangId=1065) This means StringMapValue in the first Should return something, and in the second Inner Join must return another thing. How Can I do that?

I'm trying to get my report to display different color cells, depending on the condition. This is my current code: =Switch(Fields!DaysToExpiration.Value > 31, "Green", Fields!User_Certification_Status.Value = 8, "Firebrick”, Fields!User_Certification_Status.Value = 13, “Orange”, Fields!User_Certification_Status.Value = 11, “Orange”, Fields!User_Certification_Status.Value = 10, “Orange”, Fields!User_Certification_Status.Value = 12, “Orange”, Fields!DaysToExpiration.Value <= 30, "Yellow", 1=1, "Gray") So, my problem lies with the last part of the code. I'm using a matrix view, which means there are some cells where there is no data. SSRS is treating these like they have a value though (I'm assuming 0). This means that all the blank ones automatically turn to yellow, rather than gray. How can I get around this? Thank You.

I'm moving SSRS reports from a 2008R2 server to a 2014 server. I've moved all the RDLs with a 3rd party tool only to find none of the permissions exist on the target. I'm attempting to copy the permissions over with Powershell but the script errors when attempting to set the policy with .SetPolicies. The object members appear to be incompatible between 2008 R2 and 2014. Is it possible to move the perms from 2008R2 to 2014 via Powershell? $ReportServerUriSource = 'http://my2008Source/ReportServer/ReportService2010.asmx?wsdl ' $ReportServerUriTarget = 'http://my2014target/ReportServer/ReportService2010.asmx?wsdl ' $InheritParent = $true $rsProxy = New-WebServiceProxy -Uri $ReportServerUriSource - UseDefaultCredential $rsProxyTarget = New-WebServiceProxy -Uri $ReportServerUriTarget - UseDefaultCredential $SourceItems = $rsProxy.ListChildren("/MyReports", $true) | ` SELECT TypeName, Path, ID, Name $targetFolder = $rsProxyTarget.GetPolicies($SourceItem.Path, [ref]$InheritParent) foreach($SourceItem in $SourceItems) { $Policies = $rsProxy.GetPolicies($SourceItem.Path, [ref]$InheritParent) if($InheritParent -eq $false) { $Policy = $rsProxy.GetPolicies($SourceItem.Path, [ref]$InheritParent) $rsProxyTargetPath = $rsProxyTarget.GetPolicies($SourceItem.Path, [ref]$InheritParent) if($rsProxyTargetPath) { $rsProxyTarget.SetPolicies($SourceItem.Path, $Policy) } } } Error: > Cannot convert argument "Policies", with value: "Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy1er_ReportService2010_asmx_wsdl.Policy[]", > for "SetPolicies" to type "Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy3er_ReportService2010_asmx_wsdl.Policy[]": "Cannot convert the > "Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy1er_ReportService2010_asmx_wsdl.Policy" value of type > "Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy1er_ReportService2010_asmx_wsdl.Policy" to type > "Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy3er_ReportService2010_asmx_wsdl.Policy"." > At line:21 char:15 > + $rsProxyTarget.SetPolicies($SourceItem.Path, $Policy) > + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > + CategoryInfo : NotSpecified: (:) [], MethodException > + FullyQualifiedErrorId : MethodArgumentConversionInvalidCastArgument