I'm trying to configure SSRS to use email subscription feature. This SSRS server is hosted on AWS and I have an SMTP relay to use. This SMTP relay requires an userid and password to authenticate. I tried SSRS configuration manager and also the config file, but couldnt find how and where to use this user name and password for the relay. I would appreciate if someone can help me with the configurations. The same SMTP relay and account details are working fine when I'm trying to configure the Database email on SQL Server.

IN SSRS, I have a parameter named Comment which I set to Allow multiple values and specified available values for it. My problem is that if I select one value, I will get results but if I select more than one, I will get an error. The problem is probably because I wrote my SQL statement like this: dbo.tbl_Status.Comments LIKE ('%' + @Comment + '%') NB: I need to use LIKE and not IN

My ssrs server was moved to a different domain because of which the Users table need to be updated with new SID current sid: S-1-5-21-39949945-591092532-1226208319-1007 I want to convert this sid into varbinary(85) which would look something like this: 0x0105000000000005150000005AE2326D3D9AC66DD5CCABEE56040000 I had earlier found a link but unable to find it now. Any tips?

I have a SQL Server Reporting Services (SSRS) 2012 report that is populated via stored procedure (SP). The SP returns various fields, one of which is a BIGINT datatype. When I execute the SSRS report directly the value is properly displayed, but when I export the output to Excel, it gets rounded to the nearest thousandth. For instance, this is an example of what I'm seeing. The proper value: 480758225903628660 The value shown in the Excel File: 480758225903629000 It's rounding **8660** to **9000**. Truly frustrating, and [Microsoft's documentation](https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-microsoft-excel-report-builder-and-ssrs) mentions nothing about this behavior. I've also dug everywhere on the report that I can think of that may affect this, such as the Text Box Properties: ...the Placeholder Properties: ... and the Value of the field itself: I can "fix" it by converting the field to a string by wrapping the field value in a [CStr() or .ToString()](https://learn.microsoft.com/en-us/sql/reporting-services/report-design/data-types-in-expressions-report-builder-and-ssrs) function, but that also treats the output as a string and not a number. Is there a way to export this to Excel so that the rounding doesn't occur but still keeps this value numeric?

Now I can't access Reporting Services through SSMS. I can't even connect to Reporting Services now.

We've recently deployed a new SSRS Server 2012, that can use Windows Integrated Security. We configured the servers to properly use Kerberos authentication and we solved the double hop issue. Now, all our reports are using Shared data sources that are configured to use Windows Integrated Security instead of storing an execution user on the data source setup page. It all works fine and I was very happy about it, as it increased our security (as the execute permission is derived from the AD user and not from the hard-coded execution user), but now we're running into a problem: When we try to create a Report Subscriptions on report that are using a Shared data source that uses Windows Integrated Security, we're getting the error message: >Subscriptions cannot be created because the credentials used to run reports are not stored, or if a linked report, the link is no longer valid I've googled around, and all the links I've found tell me to simply either configure the shared data source to have stored credentials, or configure the report to have custom data source with stored credentials. _This contradicts the whole point of us have Windows Integrated Security!_ Is there any way around it? The sole purpose of SSPI in our use case is to authenticate to the database. The RS server has reports that use data sources on different SQL Servers. We are not, for example, using Integrated Security for row-level security, or to show different data to different users.

I have a specific contact for my SSRS subscriptions that does not receive any mail from SSRS. her email is an organization email, everyone else including me are getting emails but only that specific user doesn't. I checked ssrs logs and i see it was sent successfully: > notification!WindowsService_0!1aa0!12/05/2019-14:15:23:: i INFO: Notification af94f76f-d236-4ffb-b4e7-8450d206f654 completed. Success: True, Status: Mail sent to contact1@organization.com;contact2@organization.com;, DeliveryExtension: Report Server Email, Report: Notables Report (Euro), Attempt 0 This is what i tried so far: 1. recreating the subscription 2. recreating reports 3. creating a simple report with no attached files 4. checking all her mail folders and junk mail 5. restarting SSRS services 6. IT team checked the mail server shes not receiving the mails they say it doesn't even go through the mailing server. 7. She does get regular mails 8. sending mail from the same server via SQL works. 9. when sending email to a group she belongs too she still doesn't get mail. it happens with all reports in that server Any suggestions? Thanks

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'm trying to create a ReportServer database on a different server (Server_AT) other that my Reporting Service server (Server_RT). ON Server_AT, I created the RSExecRole as per the script here . Then created a login 'Reporter' with user 'Reporter' and assigned the RSExecRole. Now when I use the configuration wizard -> create a new ReportServer database-> enter the SQL Server credential for Reporter as prompted-> and finish. Now the process fails - constantly with on error after another that one of permissions in the RSExecRole cannot be found. The ReportServer database does gets created on Server_AT but the user is dbo- but I am not able to connect to this database either (when I try next time). What am I missing here?

Our company is moving from SSRS 2012 to SSRS 2017. I would like to know if anyone has done a similar migration. If yes, could you please guide me through the steps? From what I read about the migration, it looks like its a very tiring process since I will have to download each report from 2012 server and upload it into 2017 server. or use PowerShell scripting to automate the same. If anyone knows a better way to do it, I am all ears. Thanks

We're using SSRS 2012. We tried to limit the permission level of users, and assigned them "Manage Individual subscriptions" role, instead of "Content Manager" or "Subscription Manager", however, now when a user tries to create an email subscription for a report, the CC/BCC and Comments sections are missing. See picture below. With a higher role level, the subscription pages looks like: We can live without CC/Bcc, but the comments section is important to the users. Can we some how enable this comment section and keep the role level low (Manage Individual subscriptions only)?

We have 2 node setup cluster, after a failover I can't see the reporting services, even the service it self is missing. I checked control panel program manager, SSRS is not installed, I open reporting service configuration manager when clicking Find, it can't find the server. Is there a way to retrieve that. There are active reports already running before the failover. Sorry I'm new in SSRS, I researched the web and can't find any solution.

I received this request from a developer: > When I try to download *.rdl report files from myssrs_server/Reports > I’m getting this error: > Would you be able to extend my permissions so I can download reports > from all branches? What is the minimal permission I should grant in order for him to get this done? Any alternatives? (I was thinking about granting read only access to the reportServer database or something on those lines - but I don't want to make their lives too difficult ) I found this article very good regarding ssrs permissions: SQL Server Reporting Services 2012 Permissions Webpage were all the ssrs Predefined Roles are explained.

This is a very annoying thing happening to the reports I am developing. The top breadcrumb sometimes works fine while at times breaks into multiple lines. I have only IE 11 in my environment, Is it the browser issue? If not then please help me fix this. Below is the screenshot.

Whats the simplest way to deploy multiple reports (.rdl) along with the respective data sources to a machine which cannot be connected to from Visual Studio? I can only place files at a given location, connect to the report server via remote desktop and execute them. I am not permitted to open firewall ports, or establish any other sort of connectivity between my machine and the report server. One way is to manually upload the files one at a time, which I wish to avoid.

We have a third party software that generates reports by adding a new "temp" report to the SSRS catalog every time a user prints a report so now the dbo.catalog table is almost 3 GB and has 16K+ rows worth of one time only reports. Is there a way to safely purge these rows from this table? To be clear, I am talking about ReportServer not ReportServerTempDB so EXEC FlushReportFromCache @Path and EXEC CleanExpiredCache are of no help. From what I am reading online Microsoft does not want you messing with this table directly so there is little documentation. I can't find any sort of official maintenance function that works on dbo.catalog. I don't expect many people want to mass delete their reports so this does not surprise me.

I am converting a crystal report to ssrs report, i am trying to implement "Format With Multiple Columns" feature of crystal report to ssrs. I have a Main tablix that has two Two Groups - 1st Group - PolicyType - 2nd Group - WeekNumber Under Week Number group, i have inserted a rectangle and a matrix within it. The matrix will show the policy number generated in every week. The matrix should only contain 6 columns and the grouping for matrix is as below - Row Grouping : Ceiling(RowNumber("WeekNumber") / 6) - Column Grouping : Ceiling(RowNumber("WeekNumber") MOD 6) I need a output like below **InsuranceType1**
***Week 1***
Policy Number
1001 1002 1003 1004 1005 1006
1007 1008 1009 1010
***Week 2***
Policy Number
2001 2002 2003 2004 2005 2006
2007 2008 2009 2010

I am able to get a similar output but the sorting within the matrix is not working, ie., i get the following result
**InsuranceType1**
***Week 1***
Policy Number
1002 1003 1001 1004 1007 1006
1005 1008 1009 1010
***Week 2***
Policy Number
2008 2009 2003 2004 2005 2006
2007 2001 2002 2010

i have not used any sorting on the Matrix, nor in the group of matrix the only sorting is on the main tablix groups PolicyType and WeekNumber and both are in ascending order. What i have tried is: 1. Sort Matrix using PolicyNumber, but that will only output first row and first column (very strange!!!). 2. Add an additional sort of PolicyNumber in Group WeekNumber (did not work either)
i have no option of modifying the stored procedure to return the row number back to the report as the client is strict on SP modification as they want to get this report backward compatible. Please help!!

This is currently in a cloud lab environment. We're not allowed to join any AD domains. We have a linux server (RHEL 6) running MySQL 5.3 and a Windows SQL Server 2012 on Win 2k8 R2. Our laptop is Win 7 64bit running Report Builder 3.0. We created an OBDC connection to the MySQL database and are able to build reports in Report Builder. However, if we add the connection to the report server (http:// IP_ADDRESS/reportserver) it gives us the following error when trying to publish: > For more information about this error navigate to the report server on > the local server machine, or enable remote errors. > > Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) > > An error has occurred during report processing. (rsProcessingAborted) I am able to open SQL Management Studio locally on my laptop and connect to the remote SQL server without issue.

I am investigating a SSRS 2012 Report which used to return data from an Oracle database. However, recently it stopped returning data. The report will sit there and run forever until something times out. Our report catalog database is also on a separate server which does not show any issues in the logs or while monitoring the performance. I do not see any errors in the Event log, SQL Server Logs, Reporting Services logs or the Oracle database logs. If I strip out the query from the report it returns rows in a few minutes. Is there a method for monitoring what is happening with the communication between the report server and the oracle server? How can I troubleshoot this issue if none of the logs are reporting any problems? Looks like I am now getting Timeout errors in the report logs. System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. When I run the query against the Oracle database using SQL Plus, it takes about 8 minutes to run.

I want to have row limitation(for example, display only 10 rows in every page) to my table in the report. I could limit the rows with Ceiling method where I could find refer. However, I have to group based on two criteria before using row limit. One is I want to group by category by category name, after that group by based on Region. And have my row limit after that. How could I achieve this? And I want to do all of these in report level. Kindly share any insight on that matter. Thanks.