Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
592
questions
2
votes
3
answers
13k
views
Date format in SSRS
I'm wondering if there is a setting in SSRS to indicate the date format. We need to show the dates in dd/mm/yyyy format on the reports and from what I can see in database the value has been stored ...
1
vote
0
answers
1k
views
SSRS Remote Database Connection Issue
I have installed SSRS 2008 R2 on Windows 2012 server. It is up and running. In the Configuration Manager, I have set it to point to remote Database on same network.
Then on my own PC (also on network)...
1
vote
1
answer
3k
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 ...
1
vote
0
answers
137
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
3
answers
13k
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 ...
1
vote
1
answer
2k
views
Active directory automatic login to SSRS
I have a server running SSRS 2012 at address server1.olddomain.com. This is working fine.
My users will be accessing this server from another address (the server is not physically moving). The new ...
1
vote
1
answer
3k
views
SQL Server 2012 Express Report Services report builder button not visible
I am trying to run SQL Server 2012 Express Report Services on Windows 7. I finally have it configured, but I'm not sure the missing steps that is preventing the Report Builder button from being ...
0
votes
2
answers
2k
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 ...
2
votes
1
answer
58
views
Order results from query to have a certain result at the top
I'm not sure there is even a way to do this, but thought I would ask anyway.
I have the following example output from a query:
Name Country Number
--------------------------
Harry Germany ...
2
votes
0
answers
312
views
Is it possible to configure Reporting Services to emit browser compatibility headers?
We have a dashboard that hosts some Reporting Services (2008) reports within frames. The dashboard runs in the browser's standards compliance mode, but this is causing some of the reporting services ...
3
votes
2
answers
3k
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 ...
1
vote
0
answers
978
views
SSRS switch statement
I have a report with a variable number of columns. I can hide columns with the ismissing function based on an expression like Iif(Fields!Site.ismissing, true, false). However, the hidden columns still ...
6
votes
2
answers
22k
views
Possible to run multiple Reporting Services (SSRS) instances on different machines with databases on same machine?
With SQL Server 2012, can SSRS instances be setup on two different machines, with both instances using the same machine for their SQL Server databases?
Machine 1
SQL Server 2012 Database Server
SSRS ...
3
votes
1
answer
331
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
1
answer
6k
views
Reporting Services TempDB keeps going into restoring mode
I am looking into an issue with SQL Server 2008 Reporting Services. It has been working fine until yesterday morning. Now I notice that ReportServerTempDB keeps on going into Restoring... mode. I ...
3
votes
3
answers
458
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 ...
5
votes
1
answer
585
views
Where and how to store my weird datamart
I could really use some help here.
Here's my situation.
I'm building a datamart in SQL Server 2005, which will furnish a single report (for now). We have 26 clients (medical organizations) that ...
3
votes
1
answer
555
views
SSRS Reports on WUXGA Displays
We use WUXGA displays (1920 x 1200), and have lots of SSRS reports. Since these reports need to be printed once in a while the layout is adjusted to A4. However when the users look at the reports on ...
3
votes
2
answers
15k
views
Page Break is splitting in the middle of a single row in SSRS
I have an SSRS report for an Invoice and it generally works perfectly but occasionally it will page break in the middle of a row in the main Tablix. The row will split and leave part of the text on ...
-5
votes
2
answers
2k
views
Performance Improvement in SSRS' Reports [closed]
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 ...
2
votes
1
answer
3k
views
encryption of SSRS subscription emails and attachments
Is it possible to set up an SSRS e-mail subscription, with an attachment, that is encrypted?
POST ANSWER-ACCEPT UPDATE: Does the SMTPUseSSL switch in the RSReportServer.config file help me at all?
...
1
vote
1
answer
1k
views
how to rebuild / reinstall ssrs (reportserver, reportservertempdb) databases?
Our server crashed. We got it back up and running however, the mentioned databases have been corrupted.
Is there a programmatic / automatic way of rebuilding or reinstalling the SSRS databases?
If ...
1
vote
0
answers
3k
views
How to change x-axis labels in a report
I am creating a trend report, in which the x-axis labels are first laywr as year (2014), second quarter (1,2), third period (month) (3,1), fourth week (3,4,5,1,2).
I need to change these labels as ...
1
vote
0
answers
1k
views
Problem with sorting matrix groups in SSRS
I've hit the following issue in SQL Server 2005 Reporting Services
This is a slightly odd and complicated situation: I have a table containing various groups and within each group is also embedded a ...
1
vote
1
answer
154
views
SSRS Deployment
I have developed and deploy my reports on report server in LAN. but I want to deploy my reports on report server which is not in LAN. means I need a setup or package which can run at client end ...
0
votes
1
answer
507
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 ...
2
votes
0
answers
146
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 ...
2
votes
1
answer
2k
views
Issue With SSRS Emailing Reports As PDFs
I have a strange issue that I'm unable to find the answer to online or by looking at it myself.
Basically when I set up an email subscription for a report I've created in SSRS Report Builder (2008); ...
1
vote
0
answers
2k
views
SSRS Timeline Chart for each day / minute
I'm asked to make a Timeline Bar Chart with SSRS 2012.
There should be 1 chart per day/employee, and this chart should have a x-axis of 1440 minutes (or 24 hours).
The bar should have 2 different ...
5
votes
2
answers
11k
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 ...
25
votes
1
answer
754
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 ...
3
votes
2
answers
1k
views
Can I programmatically generate reports that are emailed as Excel docs from SSRS?
I've searched already and don't see (or can't decipher) a solution for my issue. I have SSRS emailing a report for 1 district (with 12 retail stores). However, each Region has over 8 Districts, and I ...
1
vote
1
answer
331
views
Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance? [closed]
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 ...
4
votes
1
answer
2k
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
2
answers
2k
views
can I add a custom SSRS e-mail subscription that forces the "TO" address
I would like to know if it is possible to add a custom delivery extension(?) in SSRS that will enable me to force a value into the "TO" address for particular subscriptions?
Big picture: I am ...
1
vote
1
answer
2k
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
...
4
votes
1
answer
5k
views
Real Time SQL Server Analysis Services Cube Processing Report
I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services cubes are processing using SQL Server Reporting Services? I would like to be able to run ...
4
votes
2
answers
1k
views
How to create a summary report that contains other reports?
I have 4 reports that I run for 8 different environments. Each report creates a graph from some usage tables. It's very simple SQL that creates a very simple graph.
The guy who used to do these ...
1
vote
0
answers
5k
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 ...
1
vote
1
answer
2k
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 ...
2
votes
1
answer
2k
views
An unknown error occurred while processing the request on the server [closed]
I have an asp.net 4.0 application with a button that opens a SSRS report. This works fine on my development machine and I can open the report directly with report manager but when I try to access the ...
3
votes
3
answers
3k
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 ...
3
votes
1
answer
3k
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 ...
7
votes
2
answers
3k
views
Options for setting NOLOCK hint in dataset queries
Some context:
At first we wrote reports just "straight up", without any locking hints in the queries. With the larger reports this would sometimes cause locking problems. At first we remedied this by ...
2
votes
2
answers
2k
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 ...
1
vote
1
answer
2k
views
Installing 32bit SSRS on 64bit Windows/IIS
I've inherited a situation where I have SQL Server 2005 Standard 32bit running on Windows Server 2008 R2 64bit.
When I come to install SSRS components I'm warned that "Failed to find the ASP.Net ...
2
votes
2
answers
3k
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 ...
0
votes
1
answer
11k
views
Tablix cells width issue in SSRS
I have a weird issue in the reports that I have created in SSRS 2008.
On the report I have got a number of tablixes defined, that should be displayed attached together vertically. Imagine they form a ...
2
votes
1
answer
2k
views
Can't connect to Analysis Services or Reporting Services on localhost
I'm able to connect to my SQL Server 2008R2 localhost Database Engine and Integration Services.
However, when I try to connect to Analysis Services, it fails with the message: "A connection attempt ...
4
votes
1
answer
2k
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 ...