We recently noticed a slow running query being generated by the population of filter drop downs in Report Builder. This was SQL 2005 instance of Reporting Services connecting to a SQL 2012 server as the data source. 357 more words
Tags » SSRS
To adjust some of the properties of a SQL Server Reporting Services instance , for example, how long the execution logs are retained, or whether or not you display meaningful error messages to the user, you have to do the following: 89 more words
User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
- Run the IE browser as administrator. 89 more words
- Get the folder list in the SQL Report Server
- Using ForEachLoop, Create the folder structure in the local file system
- Using ExportColumn, export the the XML file… 1,799 more words
The table MSP_TimeByDay in the reporting database for on premise Project Server stores date information in day, week, year, quarter , etc..
Unfortunately the columns TimeWeekOfTheYear and TimeYear does not store ISO week and year. 138 more words