A commonly used name for Microsoft SQL Server Reporting Services (SSRS), a web based reporting tool bundled with Microsoft SQL Server.
25
votes
2answers
2k views
Are SQL Server in-place upgrades as ill advised as they used to be?
I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade.
I'm currently upgrading my 2008 R2 DEV and TEST ...
20
votes
1answer
426 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 ...
7
votes
2answers
391 views
Advantage of using a database snapshot for reporting purposes
What is the performance advantage of using a snapshot of a database for reporting purposes?
The way I see it, it would probably downgrade performance since for every write in the original database, ...
5
votes
2answers
353 views
RSExecRole missing
I have multiple servers and 4 of them have reporting services installed with the ReportServer & ReportServerTempDB databases.
A few days ago I was setting up security for a new login and I found ...
5
votes
1answer
430 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 ...
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 - ...
4
votes
2answers
174 views
SSRS: how to handle unavailability of service when datawarehouse is being rebuilt
We use SSIS to build datawarehouse (full Microsoft environment). This is legacy SSIS package that starts by truncating all tables in datawarehouse, run nightly.
During this time, we restrict access ...
4
votes
1answer
357 views
Does Reporting Services lock tables? [duplicate]
Possible Duplicate:
Does SSRS lock the table when querying?
I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated ...
3
votes
3answers
770 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 ...
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
133 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
318 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
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 ...
3
votes
1answer
329 views
Store SSRS Report export directly to database
As a requirement, I have to check for a certain condition on some data in the database, if the condition is true, then I have to create a pdf report and store it on a table.
I have everything set up ...
3
votes
1answer
193 views
SSRS set datasource of report model
I created a Report Model which will be consumed by the End users to create ad hoc reports using Report builder tool. The Report Model can be created using the Report Model Project in Business ...
3
votes
2answers
108 views
why would command text not execute at all?
in my report i have::
<CommandText>SELECT
column1,
column2,
'poop'
from mytable
</CommandText>
i am using sql server profiler to see exactly what statement is ...
2
votes
2answers
268 views
Executing query is too slow when accessing SQL Server located in an other country
I'am doing an investigation about a slow running query (see below info) when accessing our production SQL Server located in an other country. Now I'm looking for tweaks on how to solve this and make ...
2
votes
2answers
189 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 ...
2
votes
1answer
84 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 ...
2
votes
1answer
155 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 ...
2
votes
1answer
132 views
Does installing SQL Server Database Engine and Reporting Services in Azure require two virtual machines?
We are evaluating moving a large-ish web application comprising ASP.NET, Classic ASP and SQL Server Reporting Services into Azure, and we want to know the "best practice" for installing the Database ...
2
votes
1answer
224 views
SSRS max upload size limitations
We are working on a WiX project for deploying our large application (the server side of the application, that is.) The customer has the choice to have the application server, the SQL Server and the ...
2
votes
1answer
844 views
How to do Row Level Security in SSRS 2008 R2 (or 2012) with Active Directory Groups?
I would like to create a single report that filters data based on what Active Directory group the user is in.
Through various searches I see that Row Level Security is possible in SSRS in the Report
...
2
votes
1answer
128 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 ...
2
votes
0answers
18 views
Troubleshoot Microsoft SQL Server Reporting Services unexpected error
I have an error implementing reports on reporting services from Visual Studio 2005 but I can do it from the Reports Manager
Microsoft SQL Server Reporting Services Versión 10.0.5500.0.
The ...
1
vote
2answers
308 views
Use domain username on SQL server reporting services installed in a server which is part of a Workgroup
I have installed SQL Server 2012 on Windows Server 2008. This system is configured to be part of a Workgroup and all the users in our organisation are part of a domain. I am trying to use the ...
1
vote
1answer
216 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
1answer
58 views
Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance?
Our setup:
City A - Primary server for logshipping
City B - Secondary server for logshipping
Now there is a lot of data being updated from A - B.
And the server in City B is underutilized, and it ...
1
vote
1answer
214 views
Time Out issue, can I set the Ping Property?
I have some reports which I access through the Report Manager interface and view using a Report Viewer. If I leave a report open in the viewer then my session never times out. I believe this is ...
1
vote
1answer
192 views
How do you authenticate the database connection when using Reporting Services Forms authentication?
I'm looking into using Forms authenticaiton for SSRS. I got it working using Microsoft's sample found here: http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008!Security%20Extension%20Sample
...
1
vote
1answer
3k views
Page setup and print layout in SSRS Report
I'm creating a SSRS report using BID 2008 and have a couple of questions, your help would be much appreciated.
Why the page layout on the report is different from print set up? For example I have ...
1
vote
1answer
282 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 ...
1
vote
0answers
45 views
Drill down report links fall outside cell
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
236 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) ...
1
vote
0answers
613 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 ...
0
votes
2answers
907 views
SSRS calculated field strange behavior
I have a dataset with a calculated field:
= IIF(String.IsNullOrEmpty(Fields!Event.Value), "\t", Fields!Event.Value) & ", " &
IIF(String.IsNullOrEmpty(Fields!Action.Value), "\t", ...
0
votes
2answers
368 views
Date and time parameter In msrs report
Hi I am looking to set up my report so the start date will always be say '14-09-2011 00:00:00'
And the end date will always be '14-09-2011 23:59:59' Or in other words Start date will be 00:00 and end ...
0
votes
1answer
152 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 ...
0
votes
1answer
301 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 ...
0
votes
1answer
25 views
How to add rows/columns to the table in runtime in SSRS 2008
Usually we design the table to have x number of rows and y number of columns in a report. But how can we create a report which adds the rows and columns dynamically at run time based on the result of ...
0
votes
0answers
25 views
Displaying Hexadecimal Characters in Reporting Services Report
How do I properly display hexadecimal characters in an SSRS report?
These characters: http://www.htmlhelp.com/reference/html40/entities/special.html
E.g., “ should display as left double ...
0
votes
1answer
31 views
Image fades on the SSRS report
We have a SSRS report built using Report Builder 3. There is a coloured logo on top of this report which is displayed correctly when see the report on screen, print it or export it to Word. However ...
0
votes
0answers
257 views
SSRS report viewer - log on failed (rsLogonFailed)
I was redirected here from StackOverflow...
I have set up a web based report viewer using the SSRS reportviewer control (sql server 2008 r2) including the ability to specify credentials.
When I ...
0
votes
0answers
226 views
looking up a value in a table using ranges in SSRS
I have a fairly smple use case that I can never seem to figure out in SSRS. It has caused me great pain so I figured I would see if anyone knows the answer. In SSRS i have a query that returns a set ...
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
43 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. ...
0
votes
0answers
399 views
Sys.WebForms.PageRequestManager Error in SSRS
When i am executing on SSRS report i am getting below error
Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code ...
-2
votes
1answer
164 views
Difference function in SSRS
I have a a column of dollar amounts that I want to calculate the running difference (opposite of sum() ? ) of. Does Reporting services have a diff function or something way that I can do a running ...
-3
votes
1answer
282 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 ...
