2022 Developer Survey is open! Take survey.

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.

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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" ...
user avatar
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 ...
user avatar
  • 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
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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. ...
user avatar
  • 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!...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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, ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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?
user avatar
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. ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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; ...
user avatar
  • 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).
user avatar
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. ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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?
user avatar
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!
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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)...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar