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

learn more… | top users | synonyms (1)

4
votes
1answer
962 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 ...
3
votes
1answer
264 views

Views - Indexes/Keys/Execution Plans

I am working with a SQL 2005 database server that contains multiple databases and tables that are replicated from various sources. No one but administrators have access to this server. There is a ...
4
votes
2answers
923 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 - ...
2
votes
1answer
325 views

Execute Queries Against CMS within SSRS Reports?

Is it possible to execute queries against a Central Management Server (CMS) using SSRS? For example, I know of no way to tell a stored procedure that it is inherently supposed to call the CMS, so it ...
1
vote
1answer
1k views

Send SSRS Report Many Times Based on Sql Query

I have a user who is requesting that a legacy report (email subscription) that runs with multiple categories be modified to run based on which categories exist in the given date range. Thus instead of ...
3
votes
3answers
3k views

Historical reporting from the database with Reporting Services?

We run a job tracking service as part of the company software. Reports are generated by SQL Server (Standard) Reporting Services usually daily but often as and when needed before meetings etc. As ...
1
vote
1answer
55 views

Copy scheduling information form local system to remote system SSRS

I am scheduling some reports locally in my system. How can I copy this schedule information to remote system to avoid re-doing of scheduling at remote system?
2
votes
2answers
241 views

SSRS schedule failure intimation

I am scheduling a report using SQL Server Reporting Services Subscription option. Suppose my rdl file is corrupted or my stored procedure has got some problem. Then the report won’t generate in its ...
3
votes
1answer
670 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
4k 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
380 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
2k views

Problems with cross forest authentication in SQL Reporting [closed]

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

Is there any way to turn off the “loading” message when a page refreshes in Reporting Services?

I have a report that auto-refreshes every 30 seconds. Usually this happens fast enough that you don't even notice. Sometimes, however, the load takes a bit longer. When this happens, the existing ...
2
votes
3answers
1k views

SQL Reporting Services - T2Embed.dll missing

When generating a report in SSRS, I receive the following error: There was an error generating your report. Please refer to item 673778174106859 for additional diagnostic information. There was an ...
4
votes
1answer
342 views

What load does SQL Server Reporting Services (SSRS) have on the server?

Does SQL Server Reporting Services use a lot of server resources? Is it okay to install SSRS on the same server as the SQL Server instance? What should I take into consideration? Is the SQL Server ...
5
votes
1answer
3k views

How to deploy SSRS reports build through Report Builder?

I would be building or correcting the already build SSRS reports through report builder. Once the change is done in Development side, then how to publish the reports on test server/UAT or on ...
2
votes
1answer
1k views

How to apply filter at runtime in SSRS 2008 R2

In my report in SSRS 2008 I have created a expression for the CasesShipped column like this: =IIF(Fields!Current_Product.Value= "Match"," ",Sum(Fields!Cases_Shipped.Value)) It sums the ...
8
votes
1answer
14k views

How can I tell which data sources are being used in SSRS?

We have a bunch of SSRS (2008) reports deployed to our web portal. We have edited some of the reports to use a shared data source different than the one with which it was originally deployed. I am ...
6
votes
3answers
309 views

Things to consider with a bigger table

I have a table that has around 12 billion rows (row size 32 B) which grows each month by 300 million rows. I have setup partitions for each month and each month has 8 data files (since I currently ...
22
votes
1answer
624 views

Reporting Service and Application Role

First poster, long time lurker here. What is the best way to activate application role in a report ? I've tried different things and so far the only method that works is to embed the call to the ...
0
votes
1answer
268 views

Using SSAS for retrieval data instead of using SSRS to make a report?

If you work with Reporting service in order to create a report and you need to retrieve data from the relational database. The datamodel of the relational database can be structured in a certain way ...
6
votes
3answers
245 views

Find material for improvement in Microsoft BI

Which websites, books etc. can you recommend me to improve my basic knowledge in Microsoft Business Intelligence 2008, SSAS, SSIS and SSRS? Please remember that I'm a newbie in technical BI tool. If ...
3
votes
2answers
286 views

Report model data source

Does anybody know how i could use a linked server as a data source for a report model in SQL server 2008 r2? or how i could make this linked server a data source on a report model? Please help. Thank ...
7
votes
1answer
3k views

Is it safe to change the Recovery Model of SSRS database ReportServer to SIMPLE?

I'm changing the recovery model of ReportServer database from FULL to SIMPLE. Is there any reason why i would not want to do this? Besides the obvious answer of losing point-in-time recovery? (i am ...
2
votes
2answers
2k views

Connect a linked server to MS Reporting Service?

I've got a MYSQL server setup as a linked server in MS SQL server 2008. Can someone tell me if it is possible to generate reports from this server? How do I connect it to Reporting Services?
5
votes
3answers
6k views

Problem Connecting Report Server to Report Server Database in SSRS

I have configured Reporting Services on one Server and have the ReportServerDb & ReportServerTempDb on other server (Future requirement of scale out deployment). I am connecting to these servers ...