We are working on migrating our SSRS from SQL Server 2008 to SQL Server 2014. After brining the reports over I have a set of reports that will execute just fine but when I try to perform a standard export to excel from the 2014 Server I get a message box saying: > We found a problem with some content in ACM Consolidated > Invoie_2014.xlsx. Do you want us to recover as much as we can? > If you trust the source of this workbook, click yes. However, I do not receive the same message when exporting to Excel from the 2008 server. I believe the problem is related to some Numeric fields that are coming back with a value of 0.0000000000000000000. Has something changed with the excel export function between these two versions?

I am trying to extract the connection string for MS SSRS reports from the Report Server Catalog table. This is straightforward enough but if I change the Data Source in Report Builder, the change is not propagated to the Data Source definition on the Catalog table. Is the report definition stored elsewhere?

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.

I'm trying to figure out, how I can hide those rows in my report where Total Allocation and Total Cost IN BOTH COLUMNS TOGETHER are 0 in SSRS 2008. For example:

Total Allocation    Total Actual Cost
0                     0                

Here is the screenshot:


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

People at my organization use SQL Queries within SSRS reports: for instance SELECT name, age FROM egTable Then, this query is run on the database and then they use a FILTER within SSRS to get rid of unwanted rows. For instance, there is a filter in the SSRS called AGE, and this will be something like Age = 11 My proposition was that, this is bad: this way of doing things means that we are querying the ENTIRE table, and then from the GIANT resultset we are just getting rid of unwanted rows. Instead, we should be introducing a parameter: @age, and then write the query as follows: SELECT name, age FROM egTable WHERE age = @age Am I correct in saying that the first method pulls the entire table, whereas mine is far more efficient because it only returns a small result set? How can I verify/prove this?

I'm trying to figure out how to total values from a calculated field. In the example below, I have the following expression: =IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100, Fields!actualwork.Value * 77) Now I want to provide a total, but it doesn't show up on the report. Is there something I'm missing? " class="img-fluid rounded" style="max-width: 100%; height: auto; margin: 10px 0;" loading="lazy">

On the report Subscriptions page, under "Status" for Last Run, it has the following error: > Failure sending mail: Report processing has been canceled by the user. Mail will not be resent. It's a subscription, no **person** canceled this. Maybe there is a problem with a service. I can run the report fine right now. The only log I can find is here: > C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles There are two lines for the report: > notification!WindowsService_508!d24!02/10/2014-05:45:05:: i INFO: Handling subscription 75b94483-618d-4463-b6c0-90916b92cb6 to report ReportName, owner: domain\user, delivery extension: Report Server Email. > library!WindowsService_508!d24!02/10/2014-05:45:05:: i INFO: RenderForNewSession('/Reports/ReportName') These lines don't indicate an error occured. I've been looking through all of the logs I could find and I can't find any sort of description as to what would have caused this. I would like to find out where this information is logged, so I can create a job that looks for messages like this to alert users of a failed report. I would also like to know where the logs are in case I do need to troubleshoot something vague like this. I really would appreciate any help :)

I'd like to execute an SSRS subscription after some ETL work run by a SSIS package that takes a varying amount of time completes. I'm considering using [this method](http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/96275/) , which basically consists of SSIS calling the same stored procedure that the SQL Server Agent jobs for subscriptions call to execute a subscription. However, I'm not sure what the best way of managing permissions to execute the subscription would be. For example, I'm reluctant to add users to the RsExecRole because it's discouraged by Microsoft in some documents, and I'm reluctant to grant object-level permissions to execute the ReportServer.ado.AddEvent procedure because they'll likely get overlooked in any migrations. (Edit: I suppose we could work around this by having something execute the Agent job instead of calling the stored proc.) I'm also hoping to avoid issues with the the code that executes the subscription breaking when one of the GUIDs changes. How do SSRS professionals manage permissions for this type of request? Alternatively, is there a simpler method that bypasses these issues?

In SQL 2008 R2, I'm putting together some administrative queries on SSRS metadata to check proper configuration, and other sorts of proactive things. While querying the ReportServer db, I've been successful in checking reports, shared data sources, etc. The *one* thing that I am having trouble with is querying for any value within the Subscriptions.MatchData column. Everything from this column comes back as NULL (unless I return the entire contents of the column). Specifically, I need the value for EndDate. I've tried a number of tweaks to no avail, including toying around with XPath, XMLNamespace, etc. I found this basic example of how it is supposed to work in 2005. What is different about 2008 that this will not work? And how can I query this value in 2008 R2? ` SELECT [Description] ,x.m.value('StartDateTime','varchar(30)') AS StartDateTime ,x.m.value('EndDate','varchar(10)') AS EndDate FROM ( SELECT [description] ,CAST(MatchData AS XML) AS MatchData FROM ReportServer.dbo.Subscriptions ) AS P CROSS APPLY MatchData.nodes('//ScheduleDefinition') x(m) `

I have a single 2008 ssrs instance (#1) up and running and need to add a 2nd server also running ssrs 2008 (#2). The error message on the 2nd server is: > The report server cannot decrypt the symmetric key that is used to > access sensitive or encrypted data in a report server database. You > must either restore a backup key or delete all encrypted content. Searching on that error, I find plenty of links and posts about backing up and restoring keys, but that seems to move the problem from server #2 to server #1. Server #2 will start working, but #1 will get the same error. I found this regarding rskeymgmt.exe , but that seems to have no impact. The rskeymvmt command reports 'success', but even after restarting both instances of ssrs on each machine, nothing changes. I have also attempted to follow these steps , but my #2 instance never shows up in the scale-out deployment tab in the configuration manager. Any suggestions?

I have a query that returns the fields Order, Lat, Long, SpatialData, . SpatialData is a point. I want to create a line layer that draws lines between my points based on the order field. According to http://technet.microsoft.com/en-us/library/ee240828.aspx#LineLayer I need to do something like this: SELECT N'Path' AS Name , CAST( 'LINESTRING( -76.5001866085881 42.4310489934743, -76.4602850815536 43.4353224527794, -73.4728622833178 44.7028831413324)' AS geography) as Route But how do I go from my data to something like that?

I'm creating a SSRS report using BID 2008 and have a couple of questions: 1. Why is the page layout on the report different from print set up? For example I have set the page layout of the report in design mode to Landscape but when it is printed, it is portrait and the report is broken in many pages, the way that the table columns are broken makes the report not usable. How can we ensure what we see on the screen is the same as what will be printed (aligned with what was designed)? I've spent a considerable amount of time to do that, but have not had much success :( 2. My report length is relatively long, consisting of 3 pages (in design mode). I want to have multiple layouts in the report. For example page 1, 2 and 3 landscape and page 4 portrait. There is no sub report in the report. How can this be achieved?

I have to create a single report in MSSSRS to view calculated columns (Salary, Total Compensation, Performance Bonus, 401 (k)) by Employee, Department, Service Line, Geography, Quarter, etc. My modeler is going to give me one and only one single flat TABLE (No FACTS and Dimensions) that he has developed in MS Access and now he is going to load into MS SQL SERVER 2008 R2. Therefore, the question is how do I develop this report without having Dimensional Structure in place? Do I create a Multi-dimensional Views on a given single table or no matter what but he should create Star-Schema model? What if he doesn't create a Star schema structure then what are my options to create a report that requires viewing calculated columns by Employee, by Department, by Service Line, by Geography, by Quarter? Also, should I write multiple Stored Procedures or perform simple calculations in MSSSRS?

I have set up multiple dates as input parameters and in SQL query, I've set up the WHERE clause like: WHERE datecol1 >= @date1 OR (@date1 IS NULL) So that handles dates as optional parameters. I have three date parameters. I want to make the report such that if the user selects one date, other two should be nullified, like the null should become checked. Also, right now, I have this setting in default values part of the date parameter that i want to be dependent on the other date parameter. What am I doing wrong here? Because this still does not work.

**SQL SERVER EDITION- 2008 ENTERPRISE EVALUATION EDITION Operating System- Window Server 2008 R2** I've Created Local Smtp to use gmail id for Subscription of SSRS Report by Email as we don't have an Exchange Server. Used this link to Create local SMTP for gmail **Below is the Screen Shot of rsreportserver.Config File** **ERROR : on Report Manager** **Below is report log on after time report was executed.** library!WindowsService_16!2b30!05/20/2015-13:19:05:: i INFO: Schedule 3374e590-8374-4360-b5da-d487eacb0417 executed at 05/20/2015 13:19:05. schedule!WindowsService_16!2b30!05/20/2015-13:19:05:: Creating Time based subscription notification for subscription: ea7fc6ce-00df-4f6a-9050-e713986307ca library!WindowsService_16!2b30!05/20/2015-13:19:05:: i INFO: Schedule 3374e590-8374-4360-b5da-d487eacb0417 execution completed at 05/20/2015 13:19:05. library!WindowsService_16!2b30!05/20/2015-13:19:06:: i INFO: RenderForNewSession('/Subscription') library!WindowsService_16!2b30!05/20/2015-13:19:06:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties. library!WindowsService_16!2b30!05/20/2015-13:19:06:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties. library!ReportServer_0-24!1f08!05/20/2015-13:19:08:: Call to GetPermissionsAction(/Subscription). library!ReportServer_0-24!2484!05/20/2015-13:19:08:: Call to GetSystemPropertiesAction(). library!ReportServer_0-24!1f08!05/20/2015-13:19:08:: Call to GetPropertiesAction(/Subscription, PathBased). library!ReportServer_0-24!1f08!05/20/2015-13:19:08:: Call to GetSystemPermissionsAction(). library!ReportServer_0-24!2484!05/20/2015-13:19:08:: Call to ListSubscriptionsAction(/Subscription, null). library!ReportServer_0-24!1f08!05/20/2015-13:19:08:: Call to GetPropertiesAction(/Subscription, PathBased). library!ReportServer_0-24!2484!05/20/2015-13:19:08:: Call to GetSystemPropertiesAction(). library!WindowsService_16!2b30!05/20/2015-13:19:10:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties. library!WindowsService_16!2b30!05/20/2015-13:19:11:: i INFO: Initializing ChunkSegmentSize to default value of '32320' Bytes because it was not specified in Server system properties. library!WindowsService_16!2b30!05/20/2015-13:19:11:: i INFO: Initializing ResponseBufferSizeKb to default value of '64' KB because it was not specified in Server system properties. library!WindowsService_16!2b30!05/20/2015-13:19:11:: Using folder D:\Program Files\Microsoft SQL Server\MSRS10.SQLSVR2008_NEW\Reporting Services\RSTempFiles for temporary files. library!WindowsService_16!2b30!05/20/2015-13:19:13:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties. library!WindowsService_16!2b30!05/20/2015-13:19:13:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. library!WindowsService_16!37e0!05/20/2015-13:19:43:: i INFO: Call to CleanBatch() library!WindowsService_16!37e0!05/20/2015-13:19:43:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings. library!WindowsService_16!37e0!05/20/2015-13:19:43:: i INFO: Call to CleanBatch() ends Please Suggest if there's any requirement or step i'm left with. **PS: Local SMTP is working, i.e. i am able to receive email if i place an email.text file in C:\inetpub\mailroot\pickup**

I have SSRS2008 set up and running locally on the server (SRV0100). It is set up to run under the localsystem account for the service account (default). I changed the rsreportserver.config to use RSWindowsNTLM. I have set domain users up to have browser access to the reports. However - on other PC's, when I try to get to the report, it says: Error Message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the web server's administrator to give you access. I added 'Everyone' to the report as well as domain\Domain Users. Still the same issue even when restarting the SSRS service. Any help? I feel like I have read and tried everything :( thanks in advance! Andy

We have a SSRS 2008 (not R2) instance with a few hundred reports, and now, on a new machine we have installed a 2012 instance of SSRS. We need to migrate all the reports, while keeping all their rights and privileges, plus the datasources with credentials (some of them have local data sources). Is there a way to achieve this? The high number of reports does not allow us do it manually one by one. We tried to migrate a report, but as I said, the rights and credentials were lost. Any ideas? Thank you in advance!

Hi all can you please assist me, I would like to split my records into different year and month see below I want figure one to be split into different categories but this must all display on one page. my current result set is like this: Date Year Date Month Instructor Num Of Members 2013 November Jones 57 2013 November Smith 40 2013 November Moreleta 55 2013 November James 65 2013 November Soodie 65 2014 January Jones 47 2014 January Smith 55 2014 January Moreleta 60 2014 January James 73 2014 January Soodie 68 2014 February Jones 48 2014 February Smith 60 2014 February Moreleta 66 2014 February James 75 2014 February Soodie 68 I want them to be split like the one below. Can any of you assist me in doing this. Date Year Date Month Instructor Num Of Members 2013 November Jones 57 2013 November Smith 40 2013 November Moreleta 55 2013 November James 65 2013 November Soodie 65 2014 January Jones 47 2014 January Smith 55 2014 January Moreleta 60 2014 January James 73 2014 January Soodie 68 2014 February Jones 48 2014 February Smith 60 2014 February Moreleta 66 2014 February James 75 2014 February Soodie 68

I have a data source that is setup to store credentials on the report server and to use them when running reports. Given the following factors, I'm concerned about reports that use temporary tables in the SQL query text (not in a store procedure): 1. Due to SQL Server's connection pooling, reports that use this data source will all share a single connection (assuming they are being run near simultaneously). 2. Temporary tables are scoped on a per-connection basis. For example, if User A runs the report with one set of parameters, the temp table will be populated with one set of data. If User B runs the same report at the same time with different parameters, the query will populate the temp table with a different set of data, thus possibly mangling User A's report. Will the data in the temp table be shared across instances of a report and cause incorrect results?