Tagged Questions

3
votes
1answer
86 views

SQL Server 2008 with SP1 Updating to SP3

I am considering applying this Service Pack 3 in a SQL Server 2008 with SP1, however I was not able to find if there are any drawbacks in this process, specially regarding to Replication Services and ...
1
vote
1answer
296 views

rsExecutionNotFound when directly accessing an SSRS report

I have an SSRS report that can I access from the Web Portal but once I try to access it directly through the URL, I get the following error: Execution 'xxx' cannot be found (rsExecutionNotFound). I ...
3
votes
1answer
136 views

Table values being cut-off by table lines

Is there a way in the SSRS table component to avoid that the values get cut-off by the lines of the table.
-3
votes
1answer
288 views

Performance Improvement in SSRS' Reports

There are reports build in SSRS 2008 by some user. I need to improve the performance of the already-build reports. The reports fetches a lot of data and run very very slow. I googled and found ...
0
votes
1answer
158 views

Stored Procedure is not returning complete result

I am using the query as mentioned in the answer accepted in the question located at Stored Procedure doesn't show result in SQL Server Now when I run this SP with the values provided in the ...
0
votes
1answer
46 views

how to pull data source information on data-driven subscriptions

I would like to know more about the data-driven subscriptions on our ReportServer. I am specifically looking for what shared data sources are being used, but the connection string would also suffice. ...
5
votes
1answer
434 views

SSRS Merge Data Across 2 Group Values

I have created a report for SSRS 2008 which produces the results below. What I am looking to achieve is for those results in pink, AD, to be under both AM and PM with the text centered i.e. merged ...
3
votes
1answer
321 views

How to query EndDate value from ReportServer..Subscriptions.MatchData

In SQL 2008 R2, I'm putting together some administrative queries on SSRS metadata to check proper configuration, and other sorts of proactive things. While querying the ReportServer db, I've been ...
4
votes
2answers
224 views

Splitting a column in two and returning a summary of results

Lets take a very simple table Department | Staff Name ---------------------|--------------- Web - Electronics | Matthew Store - Electronics | Mark Web - Home | Luke Store - ...
3
votes
1answer
245 views

Can you set up mirroring for sql server reporting services?

I have mirroring set up for our SQL Server 2008 R2 Standard database server. Questions How do I ensure high availability for reporting services if the server goes down? Is there a kind of mirroring ...
3
votes
1answer
2k views

Recommended hardware configuration Analysis and Reporting Services

What would be a good way to calculate the recommended minimum hardware configuration for a Windows 2008 R2 64bit that will be running SQL Server 2008 R2 Analysis and Reporting Services? The database ...
0
votes
1answer
154 views

SQL logs filling up with “Setting database option Compatibility_Level” messages

On several of my servers, I have "Setting database option Compatibility_Level" messages filling up the SQL log and application event log to the tune of twice every 5 seconds. This makes finding ...
1
vote
0answers
620 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 ...