0
votes
0answers
14 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
99 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 ...
1
vote
0answers
155 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 ...
0
votes
1answer
112 views

SQL Server Reporting Services: How to check who accessed certain report?

I am in process of eliminating who should have access to SQL Server Reporting Services reports that I have created. Is there a way to find out who has accessed certain reports during past month? My ...
0
votes
0answers
52 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 ...
1
vote
3answers
2k views

SSRS Reports Manager Security Configuration

I happen to be setting up a reporting server at work from scrach. Having very little almost no experience of sql server administration I am finding it really difficult to configure the security ...
0
votes
0answers
76 views

SSRS Reports Manager Authentication does not work

I have managed to work with groups in domain account but now I have come across another problem, No matter on which folder or which report a domain group has permission they can navigate anywhere on ...
0
votes
1answer
1k views

Best Possible Solution for Reporting Mirroring or Replication?

Hi I have SQL SERVER 2008R2 Data Centre Edition and I use SSRS and a Vendor application for reporting. I have a Reporting Server where we backup and restore everyday from Live Server to have Data ...
2
votes
2answers
457 views

Where to put ReportServer and ReportServerTempDB databases?

I have a SQL Server 2008 R2 database server that hosts a data warehouse database. On this server is also installed SQL Server Reporting Services, and its two databases ReportServer and ...
4
votes
1answer
474 views

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 ...
2
votes
1answer
2k views

How to keep the structure of the Tablix when there is no data to show

We have a SSRS report which shows the result of a dataset in a tablix. If the query in the dataset returns no data, the header of the Tablix gets displayed but not the tablix cells below the header. I ...
2
votes
2answers
469 views

SSRS Report dependencies

Is there an automatic way to track reports and their dependencies for SSRS? What I want is a map/tree where I can see whether a report depends on a other report or subreport. So far we did this by ...
1
vote
1answer
359 views

Microsoft SQL Server 2008 R2 Subscriptions

I have an installation of SQL Server 2008 R2. In the subscriptions section I do not see an icon or button to create data driven subscriptions; in the previous installation of SQL Server 2008, I do ...
1
vote
0answers
65 views

Drill down report links fall outside cell [closed]

Apologies for the vague title, not sure how to summarise the problem... I'm creating a dashboard report showing server state for a group of SQL servers, the problem is that the links for the drill ...
1
vote
0answers
397 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) ...