Questions tagged [ssrs-2008-r2]
SQL Server Reporting Services 2008 R2, a web based reporting tool produced by Microsoft and bundled with SQL Server 2008 R2.
52
questions
0
votes
0
answers
30
views
SSRS - Cannot deploy a report (timeout, fixed by renaming the file from 37 to 28 characters long)
Edit: I have discovered I can deploy the file if I rename it to be shorter. The file name is 37 characters long. The path is 47 characters long, including the http prefix, server name and folder ...
- 421
0
votes
1
answer
459
views
How do I use "Not Equal to" in SSRS?
How do I show a message if none of the rows returned have a specific value?
If all of the results in a report have a status of "OK", I want to return a message indicating that there were no ...
0
votes
1
answer
20
views
Encrypt backup in 2008 R2
Is it possible to encrypt 2008 R2 backups like TDE for instance?
What I've read is encrypting the whole database and that way the backups will be encrypted. But can you have TDE encrypted backups ...
- 113
0
votes
1
answer
773
views
How to use OR in IIF statement in row visibility?
How to use OR in IIF statement in SSRS
=IIF((Fields!txtCurrentSubjectReportName.Value="",
Fields!txtSubjectArchivedName.Value,
Fields!txtCurrentSubjectReportName.Value) = "School Life"
...
0
votes
0
answers
58
views
SSRS - Install Reporting Server (incl IIS) separate from SQL Server
We have to migrate our existing SSRS database from an old SQL server to our new SQL cluster.
With this opportunity we would like to install de the reporting server on separate machine from the ...
- 33
0
votes
0
answers
48
views
How to export the SSRS report in excel
I have 7 pages in my SSRS report and also I'm used page break option. Is there any way available to export all the pages in single excel sheet. Please provide me solutions
1
vote
1
answer
10k
views
Conversion failed when converting from a character string to uniqueidentifier
I am creating a Dynamic CRM 2011 Report in SSRS.
I use several joins, And use GUID in joins.
For ex :
Quote.OpportunityId=Opprtunity.OpportunityId
The problem comes from parameters.
I have a ...
0
votes
1
answer
2k
views
SSRS Rectangle visibility based on Parameter Value
I am creating a Report in SSRS.
Its a Dynamic 2011 CRM Report.
I have created some Tables.
And some Rectangles.
Each Rectangle contains some Tables.
Also there is a Parameter that contains value from ...
0
votes
1
answer
507
views
How can I get the last second of the last month as a default parameter value?
I am trying to get the last second of the last month as a default value for a parameter. I can get the last day of the last month from this query on social.msdn.microsoft.com
last month last day ...
- 343
1
vote
1
answer
412
views
SSRS Auto refresh stops working
I've got a SSRS report which is used for a wallboard to display basic stats and information to the department via a Raspberry Pi attached to a creen
This has the AutoRefresh Option set to 60s however ...
- 1,951
0
votes
1
answer
1k
views
Executing a SQL Stored procedure from a SSRS text box item - Is it possible
I know the we can use custom code in SSRS and I know you have actions on Textbox items in a SSRS report.
Is it possible to "combine" this functionality for the following, which I appreciate is quite ...
- 227
1
vote
1
answer
218
views
Two Inner join on the same field to get same data
I'm developing a Report in SSRS for MS CRM 2011.
There is a table named StringMapBase which contains Option Set we have declared in different entities.
This table has Value and AttributeValue column.
...
- 13
0
votes
1
answer
140
views
Making Switches Work in SSRS
I'm trying to get my report to display different color cells, depending on the condition. This is my current code:
=Switch(Fields!DaysToExpiration.Value > 31, "Green",
Fields!...
1
vote
1
answer
536
views
SSRS bulk permission update 2008R2 to 2014
I'm moving SSRS reports from a 2008R2 server to a 2014 server. I've moved all the RDLs with a 3rd party tool only to find none of the permissions exist on the target. I'm attempting to copy the ...
- 21
2
votes
1
answer
3k
views
SSRS using external images through tls 1.2 leaves src(unknown)
One of our SSRS reports loads images from external sources and one of these sources has been locked down to tls 1.2 (which is fair and we're expecting more of our clients to be doing this in the ...
- 1,951
3
votes
1
answer
2k
views
Migrating SSRS 2008 to 2016 - ReportSync cannot see Data Sources
I am trying to migrate our SSRS 2008R2 server to a fresh install of SSRS 2016.
I am using ReportSync and have managed to get connect to both servers OK. I created a test folder with a test report on ...
- 1,450
1
vote
0
answers
46
views
ssrs report does not show range stock graph in preview
Hi I'm working on my ssrs range stock with line graph. The graph was worked properly. But now the graph display all data except the stock line.
I deployed the current graph, it working properly. Web ...
- 21
1
vote
0
answers
81
views
ssrs Horizontal range chart label
I'm working in ssrs 2008 R2. I need to plot the series label on the top of horizontal range bar.
But the label is displayed on the left side of the bar.
I tried CustomAttribute Property Label ...
- 21
0
votes
0
answers
1k
views
Why did the "Bypass Traverse Checking" permission fix my issue?
I was having an issue getting SQL Server Reporting Services 2008R2 SP3 working under a domain service account on Windows Server 2008R2. It started with this What am I missing for my SSRS Service ...
- 343
1
vote
2
answers
6k
views
What am I missing for my SSRS Service account local server permissions?
I have a relatively new instance on SSRS 2008R2 SP3 running on Windows Server 2008 R2. I am trying to set up separate domain service accounts for the separate SQL Services i.e. agent, engine, ...
- 343
2
votes
2
answers
2k
views
Converting date stored as a varchar
I'm creating a query that has a column of dates stored as a VARCHAR in the format DD-MMM-YYYY.
Could you tell me how I can convert this into date format please?
I don't want to alter the original ...
- 21
0
votes
2
answers
271
views
SSRS: textbox format hide complete row (group header)
I get a weird behavior formating a textbox in a group header. If the textbox is set to default shows the data, but so soon how set the format to percentage (or anything else) the complete row (group ...
- 159
2
votes
1
answer
208
views
SSRS 2016 Datasource - SQL Server 2000 database
Looking to upgrade SSRS from 2008R2 to 2016.
Can SQL Server 2000 databases be used as data source in SSRS 2016? And are there any other known issues that could come up with the migration?
7
votes
1
answer
1k
views
Standards or Best Practices for Error Handling in SSRS
I have encountered a recurring issue with SSRS where "bad" reports go out to clients. The issue is that we have reports with a number of subreports, and one or more subreports will fail to process. ...
- 17.7k
0
votes
1
answer
3k
views
Migrate ssrs 2008 r2 to ssrs 2016
The current setup of the server is Windows Server 2008 sp1, with SQL Server Reporting Services 2008 r2 installed. The databases are on a separate server which is using SQL Server 2008 r2.
I have a ...
- 101
4
votes
3
answers
9k
views
Report Builder does not connect for a remote reporting Server
Current Environment
I am in a bit of trouble here, I have a Reporting Services installed on one server and SQL Server database engine installed on another server.
The users are connecting to ...
- 1,800
1
vote
1
answer
271
views
How to collapse cell borders in ssrs
I have been creating some reports in SSRS 2008 R2. When I need to make borders that show up for all rows, both on the top and bottom of the report, as well as all the rows in between I can tell that ...
- 797
6
votes
2
answers
7k
views
How (not) to manage SSRS report-execution history retention
SQL Server 2008 R2 Reporting Services keeps a log of who runs what report, stored in the ExecutionLogStorage table of the ReportServer database. The default retention period for that history data is ...
- 179
2
votes
1
answer
48
views
Migrating log files - should I copy file/directory permissions?
I'm planning to move the log files for the databases ReportServer, ReportServerTempDB, tempDB, and msdb to a new drive.
But it seems that permissions aren´t copied with the directories and files; ...
- 277
0
votes
1
answer
362
views
How to Set up SSRS Web Services to run under another port than 80?
What steps do I have to pace to run Web Service URL and, Report Manager URL, under another port rather than 80? (DBMS is SQL Server 2008R2 and OS is WIn Server 2008R2).
1
vote
1
answer
608
views
SQL Server 2008 R2 copy Schema with all user security permissions
I have a prod support request from a high value user to adjust the settings on a company-wide dashboard so that he can manage a section of his workflow currently being excluded from these reports. ...
- 4,134
0
votes
1
answer
2k
views
SSRS email Subscription Not Working but local smtp is working
SQL SERVER EDITION- 2008 ENTERPRISE EVALUATION EDITION
Operating System- Window Server 2008 R2
I've Created Local Smtp to use gmail id for Subscription of SSRS Report by Email as we don't have an ...
0
votes
0
answers
223
views
SSRS 2008R2 SQL Service Account Connection Issue
In our SSRS report manager page we get the below error on the Datasources. This all worked fine previously and seems to suddenly have stopped working. I have no idea what the issue could be.
All SPN ...
- 1,344
1
vote
2
answers
2k
views
01/01/1753 date is corrupt in Excel after export from SSRS
The date 01/01/1753 appears fine in the SSRS 208R2 report preview, but when the report is exported to Excel 2010, it appears as ########### and the value in the cell is -53689. All other dates come ...
- 911
1
vote
1
answer
2k
views
SSRS pivot dynamic columns
I've tried to port this from a similar post, Return a column per date in a range
however I haven't been able to quite get it to do what I need... Please find some example code below :
What i'm after ...
- 281
2
votes
1
answer
770
views
How to specify a display name in emails from SSRS subscriptions?
How can I specify a display name (e.g. "Reporting Server" <noreply@domain.com>) in the emails sent from SSRS subscriptions?
- 121
1
vote
0
answers
257
views
How to draw series line in SSRS chart
Does anyone know how to add the series line between these columns in SSRS chart? Thanks!
- 11
1
vote
1
answer
137
views
Conditional formatting in SSRS 2008r2
I am new to report writing and am trying to suppress rows that have zero data. I need to know how to write the conditional iif statement when I have multiple columns of data. Example
account number ...
- 11
0
votes
2
answers
417
views
SSRS Report Server Database Locations
I've recently inherited management of a large number of SSRS environments. I'm attempting to generate a list of all the database server/instance/names for each of the SSRS databases (not the data ...
- 1
4
votes
0
answers
735
views
User can create in SSRS, but can't manage objects
We have a user who can create, but is unable to manage objects in SSRS, even though he has content manager permissions and another user who has same permissions who is able to.
It is SSRS 2008 R2, ...
- 41
1
vote
1
answer
3k
views
Impact on SSRS of migration of SQL Server from 2008 to 2012
As part of my project, we are upgrading SQL Server 2008 R2 to SQL Server 2012. We have a separate SSRS 2008 instance running on a separate machine which interact with these existing 2008 database ...
- 13
4
votes
1
answer
1k
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 ...
- 3,634
1
vote
0
answers
64
views
How to keep the structure of the Tablix and Field names when there is no data to show [duplicate]
When the data set returns no data, the tablix column headers display, but I also need the detail rows to display with a blank or zero for all fields. Adding an additional row to the tablix is not an ...
- 11
0
votes
0
answers
2k
views
SSRS - Report using Stored Procedures, Cascading Parameters and Views
I am looking for a non-trivial Microsoft SQL Server Reporting Services example that shows the efficient use of the following for calculated columns such as:
Profit = Revenue - Expense
Margin = Profit ...
- 1
0
votes
1
answer
2k
views
How can i deploy ssrs report one server to another server [closed]
When I create a sample ssrs report and I deploy it, I get the following error:
The specified report server URL http://localhost/reports could not be
found. verify the syntax of the URL and that ...
- 1
1
vote
0
answers
990
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,344
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,800
1
vote
1
answer
1k
views
SSRS Line Graph formatting
Environment: Windows 8.1, SQL Server 2008 R2 Express database, SQL Server 2008 R2 BIDS
Database: Performance counter data collected on client servers. The particular values involved in this question ...
user507
4
votes
1
answer
3k
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 ...
- 141
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 ...
- 11