Feb 18, 2011 · The guy who created all the reporting using SSRS has left, and I am trying to troubleshoot one of the reports being generated. How do I get access to look at the query that is generating the report.

Dec 8, 2014 · I have a report in SQL Server Reporting Services (SSRS) that I'd like to schedule to run automatically as an email. I'd like the report to be attached as Excel file. According to the Microsoft ove...

Jan 15, 2015 · The databases are created together and bound by name. By default, the database names are reportserver and reportservertempdb, respectively. Report Server Temporary Database Each report server database uses a related temporary database to store session and execution data, cached reports, and work tables that are generated by the report server.

Apr 12, 2013 · First go to your control panel , select Date , time and Number Format . Now select English (United Kingdom) from the drop down list. Make sure the shor date field is equal to 'dd/mm/yyyy'. Press Apply. Now go to SSRS and right click on the report in the empty space and select properties.

Jan 26, 2016 · Is there a simple way to view the SQL Queries actually generated by SSRS other than running profile traces to capture them? Is there some way from within the BIDS editor to see this?

I'm wanting to be able to input any given report server url and display a list of reports available on that server. I found this question, and it's useful if I compile the project with a reference to a specific sql server (How do I get a list of the reports available on a reporting services instance).

Feb 4, 2016 · I have an expression in a table that checks if there was a return value. If the query returns empty or null I want to set the value to 0. =IIF(IsNothing(Fields!DndCount.Value),0,Fields!DndCount.V...

I'm using SQL Server (2012), and using the two (simplified) tables below, how do I create 3 separate reports (daily, weekly and monthly) and include the following calculated fields: 1. new users c...

The way I was able to fix it was to create the ssrs report in a whole new project (obviously nothing wrong with the query) and save it off to the side. Then I reopened my original ssrs project, right clicked on Reports, then Add, then add Existing Item. …

Open Reporting Services Configuration Manager -> then connect to the report server instance -> then click on Report Manager URL. In the Report Manager URL page, click the Advanced button -> then in the Multiple Identities for Report Manager, click Add.