Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssrs]

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

244 questions
0
votes
1 answer

SSRS Report fails with conversion error but runs fine in ssms?

I have an issue with a report that was written before my time (I warn you it's got a lot of code and the error makes no sense). Basically its a stored procedure that creates a table variable and then inserts into it multiple times from different…
SQL_Kid
  • 1
  • 1
0
votes
2 answers

SSRS 2005 Copy reports, data model, etc

Anyone know how I can copy the user reports (and model) someone has created to point at another database (same schema). I don't really want to recreate the data model becuase (a) it's really complicated and (b) the previous developer added lots of…
BIDeveloper
  • 187
  • 10
0
votes
2 answers

Why isn't sql server using all of the available memory

I Have SQL server 2012 standard 64bit with 64GB RAM and 40 CPU cores. In the server properties, I can see that all the RAM is listed in the memory field on the general tab. Underneath the Memory tab, I have set the minimum to 50,000 MB and the…
AWippler
  • 1,065
  • 1
  • 12
  • 32
0
votes
2 answers

Restricting SSRS subscriptions to shared schedules only

I'm reasonably new to SQL Server Reporting Services and Report Manager, and completely new to SSRS's Subscriptions. We're running SSRS 2008. Out of the box it seems that a user with the Browser role can create a Subscription to a report and schedule…
Matt Frear
  • 301
  • 1
  • 2
  • 6
0
votes
1 answer

SQL 2008 Report Manager not working

I have a SQL 2008 developer edition with SSRS and the report manager is only available from the local machine. If I try to access it from any other machine I get challenged for my domain u/name and pwd 3 times and then the screen stays blank. I have…
Fatherjack
  • 419
  • 3
  • 12
0
votes
1 answer

Sharepoint and SSRS report trust relationship ssl/tls secure channel remote certificate is invalid

I have no experience with sharepoint at all. but this is what I observed. I intermittently getting this error message on my sharepoint. could not establish trust relationship for the ssl/tls secure channel. Remote Certificate is invalid according…
BobNoobGuy
  • 101
  • 1
  • 4
0
votes
1 answer

Reporting Services 2000 server is not recognizing Internet Explorer 8 as up level

The reports are getting rendered in HTML 3.2 instead of 4.0. Which stops the toolbar from appearing. Has anybody managed to fix this issue?
Mesh
  • 213
  • 3
  • 10
0
votes
1 answer

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of CPUs is not in power of 2. I found this article…
Mike
  • 1
0
votes
1 answer

Clustered instance - kerberos double hop woes

We've recently migrated our virtualised SQL databases to a bare metal solution in an active/active cluster. Everything is working great except SQL Reports. Ok, so a rundown of our setup here as it relates to SQL and Reports: XXYYSQ01 is our old…
Aaron Mason
  • 703
  • 6
  • 20
0
votes
2 answers

Install RSClientPrint for Reporting Services 2012 using .bat file and still be able to use 2005

I have a Reporting Services 2005 server that when users accessed it and tried to print reports would get a message asking them to install the print control, which they could not do because of lack of permission. A work around I had found at the…
John Wesley Gordon
  • 183
  • 1
  • 3
  • 10
0
votes
2 answers

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, but not clear how to add or install them. This is…
Adam Szabo
  • 121
  • 1
  • 7
0
votes
1 answer

Change SMTP server for SBS 2011 Self Monitoring Reports

SBS 2011 sends daily/weekly/instant reports from the account SBSMonAcct@. It uses localhost as the SMTP transport as being SBS Exchange is usually installed. I want to use an external SMTP server. Where can I change these settings? Thanks.
Dom
  • 741
  • 1
  • 8
  • 19
0
votes
1 answer

Very extremely weird IIS\Reporting Services permission issue

Server 2012 Standard Reporting Services 2012 I have 2 URLs for my Reporting Services: http://MACHINE-NAME/reportserver https://domain.com/reportserver When using the local url locally everything works fine. When using the external url externally…
JustAGuy
  • 639
  • 3
  • 23
  • 38
0
votes
2 answers

Problem with printing on Sql Report Server 2005 and WinXP updates

We have installed and ruining MS SQL Report Server on WINSERV2003 and users access reports thought IE, recently I have more and more troubles making them able to print. I know it is problem with one of MS updates (KB956803 KB956931), But lately and…
adopilot
  • 1,521
  • 6
  • 25
  • 41
0
votes
1 answer

Default error page in SSRS 2008

We are using SSRS 2008. Is there a way to show a default error page if there is an error in the Reporting Services? If so how do I go about doing this? Currently getting the following error..... Service Unavailable HTTP Error 503. The service is…
Etienne
  • 273
  • 5
  • 16
1 2 3
…
16 17