Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssrs-2008-r2]

SQL Server Reporting Services 2008 R2, a web based reporting tool produced by Microsoft and bundled with SQL Server 2008 R2.

50 questions
7
votes
1 answer

Standards or Best Practices for Error Handling in SSRS

I have encountered a recurring issue with SSRS where "bad" reports go out to clients. The issue is that we have reports with a number of subreports, and one or more subreports will fail to process. When the subreport fails to process, the report…
JNK
  • 18,064
  • 6
  • 63
  • 98
6
votes
2 answers

How (not) to manage SSRS report-execution history retention

SQL Server 2008 R2 Reporting Services keeps a log of who runs what report, stored in the ExecutionLogStorage table of the ReportServer database. The default retention period for that history data is 60 days. A few months back, I wanted to…
Bob C
  • 179
  • 2
  • 8
5
votes
1 answer

SQL Server Report Manager 404 using HTTPS

OK. I have scoured the Internet for information on trying to fix this and found nothing that deals with my situation. I started here, that lead me to here, that lead me to looking at netsh commands for HTTP. Understand: I have no problem…
user507
5
votes
3 answers

Report Builder does not connect for a remote reporting Server

Current Environment I am in a bit of trouble here, I have a Reporting Services installed on one server and SQL Server database engine installed on another server. The users are connecting to Reports Manager which obviously points to the server…
M.Ali
  • 1,970
  • 10
  • 27
  • 38
4
votes
0 answers

User can create in SSRS, but can't manage objects

We have a user who can create, but is unable to manage objects in SSRS, even though he has content manager permissions and another user who has same permissions who is able to. It is SSRS 2008 R2, the folder is nested, but permissions have been…
AngieRudduck
  • 41
  • 3
4
votes
1 answer

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 Excel, all the cell borders are gone and the spread…
Sky
  • 3,744
  • 18
  • 53
  • 68
4
votes
1 answer

Can non-domain-connected users use Report Builder

I'm dealing with a scenario where SSRS is being provided to remote clients on a different domain. We've discovered that they can launch Report Builder (a ClickOnce application) from their Report Manager browser session, but RB then uses their local…
sasfrog
  • 141
  • 1
  • 3
4
votes
2 answers

SSRS using external images through tls 1.2 leaves src(unknown)

One of our SSRS reports loads images from external sources and one of these sources has been locked down to tls 1.2 (which is fair and we're expecting more of our clients to be doing this in the future) The tls 1.2 update has been applied to the…
Ste Bov
  • 2,101
  • 1
  • 14
  • 19
3
votes
1 answer

Migrating SSRS 2008 to 2016 - ReportSync cannot see Data Sources

I am trying to migrate our SSRS 2008R2 server to a fresh install of SSRS 2016. I am using ReportSync and have managed to get connect to both servers OK. I created a test folder with a test report on the 2008 server and have migrated that fine to the…
SE1986
  • 2,142
  • 4
  • 30
  • 61
2
votes
1 answer

How to specify a display name in emails from SSRS subscriptions?

How can I specify a display name (e.g. "Reporting Server" ) in the emails sent from SSRS subscriptions?
Darren Griffith
  • 121
  • 3
2
votes
1 answer

Conversion failed when converting from a character string to uniqueidentifier

I am creating a Dynamic CRM 2011 Report in SSRS. I use several joins, And use GUID in joins. For ex : Quote.OpportunityId=Opprtunity.OpportunityId The problem comes from parameters. I have a parameter which its label is a name and the value is GUID…
alireza azadi
  • 25
  • 1
  • 2
  • 6
2
votes
2 answers

Converting date stored as a varchar

I'm creating a query that has a column of dates stored as a VARCHAR in the format DD-MMM-YYYY. Could you tell me how I can convert this into date format please? I don't want to alter the original table in any way, as it's not mine to tinker!
Colin
  • 21
  • 2
2
votes
1 answer

SSRS 2016 Datasource - SQL Server 2000 database

Looking to upgrade SSRS from 2008R2 to 2016. Can SQL Server 2000 databases be used as data source in SSRS 2016? And are there any other known issues that could come up with the migration?
Halt_And_Catch_Fire
  • 161
  • 1
  • 15
2
votes
1 answer

Migrating log files - should I copy file/directory permissions?

I'm planning to move the log files for the databases ReportServer, ReportServerTempDB, tempDB, and msdb to a new drive. But it seems that permissions aren´t copied with the directories and files; should I bother to move them over? (Or is that…
Peter
  • 287
  • 1
  • 3
  • 14
1
vote
2 answers

01/01/1753 date is corrupt in Excel after export from SSRS

The date 01/01/1753 appears fine in the SSRS 208R2 report preview, but when the report is exported to Excel 2010, it appears as ########### and the value in the cell is -53689. All other dates come across just fine. Apparently Excel accepts…
ajeh
  • 911
  • 5
  • 14
  • 31
1
2 3 4