Thanks to McNets for the heads up on the map DataSources option. To solve the problem I had to:
Load up both servers as per the image in the question
Select Tools > Map DataSources
I was getting a runtime error at this point this was stopped by creating a datasource on the target server and clicking the "Load" buttons again in ReportSync
The resulting ...
As billinkc noted in his comment there is no way to propagate the subreport errors to the main reports.
As evidenced in this MSDN post you could try to use data driven subscriptions to drive the subscription, but that could get messy if there is any complexity involved real quick.
If you look at the SQL Agent jobs for a server using SSRS subscriptions you ...
I ran into this issue when attempting to run images from IIS Server which was locked down to TLS1.1 and TLS1.2
The issue was two fold
I had to update the Registry to add the following keys
Excel specifically provides a message: Dates and times that are negative or too large are displayed as ######.
So, that is a Excel limit. Further, you can type in strings that look like dates, but Excel may not think of them as dates. For example, if I make a column of date type and enter into the columns -53689, 01/01/1753, and 01/01/1900 (using my ...
Normally in SSRS you would use the SSRS management interface (/ReportsManager IIRC) to set user roles/perms by folder. They are normally inherited by subfolders though you can override that. The role 'browser' is most appropriate for end users as it allows them to run / view reports but not much more. If you grant a user 'browser' access for folder but not ...
The URL you are currently using is for the report manager.
Report RDLs are deployed to the report server URL, so change the path to http://localhost/reportserver.
Alternatively, you can find the correct URL for your server configuration in the Reporting Services Configuration Manager > Web Service URL (generally located in the Start menu > All Programs > ...
Interesting find. I was unaware of this setting until I built a page that used the SSRS execution history table as the sole source of a report's download count. To my surprise, the counts disappeared one day. At that point, I discovered the default value of 60 days retention. I recall increasing the retention setting in the GUI, but I did not set to 0.
As part of the troubleshooting I was doing to try and address the issue I ran Process Monitor while I was trying to start the service.
I tracked as event that also had a result of "Access Denied" which was the service trying to read files inside the directory where reporting services was installed an running from. In my case it was: "C:\Program Files\...
This should give you a start. It assumes that you've already cloned all the relevant objects and that all of your permissions are at the object or schema level (if you have column-level permissions, the script gets a little more complex, but not too bad).
@oldschema SYSNAME = N'schema1',
@newschema SYSNAME = N'schema1_dev';
Backup Encryption was added in SQL Server 2014.
And SQL 2008 R2 is out of support. So upgrade, and yes, otherwise you can use TDE, or write ordinary backups to an encrypted location (eg with BitLocker).
Fields!txtCurrentSubjectReportName.Value) = "School Life"
Fields!txtCurrentSubjectReportName.Value) = "My goal for this term..."
This may be a typo in your question, but just to be safe I'll post this as a possible answer - you shouldn't have those single quotes around @siteId, it should be like this:
The text string '@siteId' can't be converted into a uniqueidentifier for that join, and will result in the error you mentioned:
SELECT CAST('@siteId' ...
The documentation states that you should not enable snapshot isolation on SSRS database.
Enabling Snapshot Isolation on the Report Server Database.
You should follow the instructions there to turn it off.
Excerpt from the docs:
"...You cannot enable snapshot isolation on the report server database. If snapshot isolation is turned on, you ...
Yeah, SSRS can be a little cumbersome with its handling of empty/null values. Try adding an explicit isnothing() before the yellow option:
=Switch(Fields!DaysToExpiration.Value > 31, "Green",
Fields!User_Certification_Status.Value = 8, "Firebrick”,
Fields!User_Certification_Status.Value = 13, “Orange”,
I was able to hack together a solution from a few different blogs-
You should use CONVERT when converting between date/datetime and varchar datatypes.
Relying on implicit conversion for date formats can give unexpected results.
By using CONVERT you are able to explicitly specify date & time styles for your data. Date format of DD-MMM-YYYY, corresponds to date format 105, so you could use something like this:
You can use CAST to convert your VARCHAR value into DATE format.
Syntax for CAST:
CAST ( expression AS data_type [ ( length ) ] )
Sample execution: You can convert into DATE alone or DATETIME format:
DECLARE @TestDate AS VARCHAR (12) = '22-MAY-2015';
SELECT CAST(@TestDate AS DATE);
DECLARE @TestDate1 AS VARCHAR (12) = '22-MAY-2015';
After a lot of digging around, I didn’t get anywhere, then eventually I got Microsoft involved to help me with the problem.
MS solution architect confirmed that the Report Builder requires a direct connection to SQL Server when launched hence the working with data sets in the report builder failed. Apparently this is BY DESIGN and it is not going to change....
The only way I know how to do this is to remove either the left-hand or right-hand border from the cells where it is double. A very laborious work-around and something that should be addressed as a bug.
If you don't move the permissions too the service account under which SQL Server is running may not be able to access them.
You can use Robocopy to do this quite easily. I tend to use the following.
ROBOCOPY <source> <target> /MIR /SEC /SECFIX
More detaisl on this command can be found here
More Robocopy options can be found here
As suggested in my comment I would not PIVOT the data within the SQL and let SSRS do the PIVOTING by using a matrix. Why? Because your report will not be flexible should you choose to allow users to specify their own number of periods.
This kind of report is much easier with a Date dimension table so you can easily figure out the week start/end date between ...
Microsoft Assessment and Planning Toolkit should do the trick.
MAP performs a detailed analysis of hardware for migration to Windows 8, Windows 7, Windows Server 2012, Windows Server 2008 R2, SQL Server 2012, SQL Server 2008 R2, Microsoft Office 2010, and Office 365.
It specifically mentions SQL 2012 at some point, but I guess the same would work for ...
There is some Technet information on the intended behaviour of the export: https://technet.microsoft.com/en-us/library/dd255234(v=sql.105).aspx
Images, charts, sparklines, data bars, maps, gauges, indicators, and
lines are positioned within one Excel cell but they sit on top of the
cell grid. Lines are rendered as cell borders.
This isn't a complete answer, but I do not recommend having live reports passing user credentials to SQL Server.
Suppose a malicious report developer builds some kind of report that does Nasty Things that would require sysadmin privileges (vandalism, granting privileges, whatever). Just deploy the report, and trick someone with sysadmin to run it (CSRF ...
1 – Permission to Access Data from sql server. (for which after some research I have decided to make use of datareader role.
When you create your report in SSRS you want to set up the data source with an account with adequate privileges within the database to run the report (In your data source under credentials). Typically we use a service account for this ...