A commonly used name for Microsoft SQL Server Reporting Services (SSRS), a web based reporting tool bundled with Microsoft SQL Server.

learn more… | top users | synonyms

0
votes
1answer
13 views

Find out CPU usage by reporting server

Is there a way to found out what is the CPU usage of the reporting server? Sometimes the CPU usage is rised up by 40% percent for several seconds. I think the reporting server is causing it but I am ...
0
votes
1answer
38 views

SSRS Domain Migration

My company is currently going through a data center migration. We are now down to the SQL Servers and this includes SSRS. The bad thing that is going to hit us is the current SSRS server is being ...
0
votes
1answer
103 views

SSRS minus first two dates as the header

I have a SSRS report that has one column called startime that is listed in mm:dd:yyyy hh:mm:ss format. For the header of this column I want to minus the first date from the second date to give me an ...
0
votes
1answer
18 views

SSRS 2012 and SharePoint 2010 Standard

Is it possible to use Report Builder Model, Report Builder Report, Report Data Sources with a Sharepoint Standard 2010 edition?
0
votes
1answer
144 views

Configuring Reporting Services - ExecutionLogDaysKept

Is it possible to set Reporting Services options when Reporting Services is not installed on a server? Is this how a SQL Server instance used by SharePoint works? I'm a new DBA (very junior...), and ...
2
votes
0answers
79 views

SSRS URL Changes while navigating

I am trying to track down the root cause of this issue I keep seeing. We have SSRS running with a custom URL like https://reporting.companyname.com/reports. When I connect to that address I can ...
2
votes
0answers
182 views

Exporting SSRS report to Excel

We have a number of SSRS reports and want to show the report in Excel format to the users. SSRS has provided an option to save the report in Excel format (.xls), however when the report is saved as ...
2
votes
0answers
72 views

Troubleshoot Microsoft SQL Server Reporting Services unexpected error

I have an error implementing reports on reporting services from Visual Studio 2005 but I can do it from the Reports Manager Microsoft SQL Server Reporting Services VersiĆ³n 10.0.5500.0. The ...
1
vote
0answers
92 views

How to handle many columns / variable schema?

I apologize in advance in case this question has been asked already. I'm working on revamping a reporting application used within my company. The requirements are: Support addition of new fields ...
1
vote
0answers
292 views

SSRS 2012 - Dynamically change value of textbox in report header

I am in the process of converting some MS Access 2003 reports to SSRS 2012 (using VS 2010 to develop the reports). I have a report with a number of parameters. Some of the parameters are populated ...
1
vote
0answers
172 views

SQL Server Reporting Services (MSSQLSERVER) Process using high memory

We have the Reporting Services installed on our database but we are not actually using it. Generally, the running process takes up a few MB but all of a sudden it has jumped to 4GB. We have restarted ...
1
vote
0answers
63 views

Does reporting webservice url contain the function that helps to export the report to the client version?

The reporting webservice url contains the webservice url that contains all the information of the Reports which are created in SSRS. As the report has been created on reporting service, i want to ...
1
vote
0answers
105 views

Using #temp to work around Reporting Services blocking issue

Having utterly failed to resolve why a perfectly acceptable but admitidly large stored procedure was suffering the blocking process lck_m_s when called via a report in SQL Reporting Services I have ...
1
vote
0answers
362 views

SSRS 2008 report fast in test, slow in production: parameter sniffing problem?

We recently had an issue with reports running in an integrated SharePoint environment where the report runs fine in development, test and staging, but very slow (times out) in production. Running ...
1
vote
0answers
146 views

Is it possible to configure Reporting Services to emit browser compatibility headers?

We have a dashboard that hosts some Reporting Services (2008) reports within frames. The dashboard runs in the browser's standards compliance mode, but this is causing some of the reporting services ...
1
vote
0answers
280 views

Problem with sorting matrix groups in SSRS

I've hit the following issue in SQL Server 2005 Reporting Services This is a slightly odd and complicated situation: I have a table containing various groups and within each group is also embedded a ...
1
vote
0answers
464 views

Keep original column names in SSRS report designer 3.0?

I have queries returns a lot of (over a hundred) columns which names contain important underscores, >, < and Uppercase/lowercase characters. However, when creating the reports, SSRS designer (3.0) ...
1
vote
0answers
1k views

Problems with cross forest authentication in SQL Reporting

We're currently running an SQL 2008 R2 Cluster with Reporting Services running, all for use with System Center Operations Manager 2007 R2 (RU3). Our users are on a different domains to the SCOM and ...
0
votes
0answers
5 views

Send parameter from a report to another SSRS 2010

I would like to send parameter from a report1 to report2 in action of textbox (in report1), I found just tuto for sending parameter to Subreports. Some help
0
votes
0answers
9 views

SSRS data source - specify machine account credentials

When I create websites in IIS that connect to a SQL Server database I can set the website to run as the machine account and give permissions to that machine account within SQL Server, which allows me ...
0
votes
0answers
36 views

Accessing SSRS receive System.UnauthorizedAccessException

Trying to log into localhost/reports I get the following error on the screen. An internal error occurred on the report server. See the error log for more details. (rsInternalError) Access is ...
0
votes
0answers
39 views

SQL-SRS create a report that is evaluated every day

Is there any functionality in the SQL Server Reporting Services to run a query every day and graph the result or do i need to use a seperate table and cronjob to run the query and save the result plus ...
0
votes
0answers
56 views

Installer Error while Installing SQL Server Reporting Services

I have a Windows 2008 R2 Server 64bit, I have already installed SQL Server 2008 R2 SP2 64bit Enterprise Edition, Which is working fine, without any issues. Now when I am trying to install Reporting ...
0
votes
0answers
33 views

Reporting Services Scripter ScheduleID Error

I'm currently in a SQL Server 2005 environment that's being upgraded to 2012. I need a tool to script out all of my SSRS subscriptions, and I chose to use RSScripter. I'm having an issue whenever I ...
0
votes
0answers
76 views

SQL Server Reporting Service dynamically change connection string

We have set up our Microsoft 2012 Analysis Server as per Microsoft's best practice guide found here: http://technet.microsoft.com/library/Cc966449 In particular, we're looking at how to swap from AS2 ...
0
votes
0answers
69 views

SQL Server Reporting Services Upgrade/Migration

I couldn't find any documentation on this. I'm currently doing a dry run of SSRS 2005 to SSRS 2008 R2 upgrade/migration. I've backed everything up (encryption key and configuration files) and did a ...
0
votes
0answers
601 views

How to determine if SQL Server Reporting Services database is being used?

I have a SQL 2005 server that needs to be decommissioned. For regular databases, I have a couple scripts that look at sys.dm_db_index_usage_stats to determine last access. My normal process is to make ...
0
votes
0answers
2k views

SSRS report viewer - log on failed (rsLogonFailed)

I was redirected here from StackOverflow... I have set up a web based report viewer using the SSRS reportviewer control (sql server 2008 r2) including the ability to specify credentials. When I ...