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.
53
questions
0
votes
1answer
26 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
0answers
11 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 ...
0
votes
0answers
47 views
Disabling SSRS Scale out feature during migration to non-enterprise edition
Server A is SQL Server 2008 R2 Enterprise which has SSRS installed. I have migrated across the reporting database, reporting tempdb, etc.
On Server B is SQL Server 2017 standard edition with SSRS. I ...
0
votes
0answers
27 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
0
votes
0answers
10 views
how to set the page break in SSRS report
I achieved the page break for every 8 rows but I have 33 rows in my SSRS report, if 33 rows is divisible by 8 i get 5 pages and I could see there is only one row in 5th page I don't to display in 5th ...
0
votes
0answers
38 views
I am migrating SSRS from SQL server 2008 r2 to sql server 2016 on another server. Finding and backing up the right web.config and machine.config
I am following "https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-native-mode?view=sql-server-2017#bkmk_backup".
Under "Backup Files and ...
1
vote
1answer
2k 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
1answer
378 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
0answers
243 views
SQL Server 2008 R2 SSRS Failure sending mail: At least one of the From or Sender fields is required, and neither was found
I am trying to set up a subscription for a SSRS report in SQL Server 2008 R2 and I am getting the following message:
Failure sending mail: At least one of the From or Sender fields is required, and ...
0
votes
1answer
42 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 ...
1
vote
1answer
178 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 ...
0
votes
1answer
363 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 ...
1
vote
1answer
110 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.
...
0
votes
1answer
63 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
1answer
315 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 ...
1
vote
1answer
1k 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 ...
2
votes
1answer
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
vote
0answers
44 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 ...
1
vote
0answers
72 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 ...
0
votes
0answers
564 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 ...
1
vote
2answers
2k 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, ...
2
votes
2answers
1k 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 ...
0
votes
2answers
207 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 ...
2
votes
1answer
179 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
1answer
547 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. ...
0
votes
1answer
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 ...
3
votes
3answers
3k 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
vote
1answer
172 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 ...
4
votes
2answers
4k 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 ...
2
votes
1answer
44 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; ...
0
votes
1answer
331 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
1answer
410 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. ...
0
votes
1answer
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
0answers
217 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
vote
2answers
1k 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 ...
1
vote
1answer
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 ...
2
votes
1answer
649 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?
1
vote
0answers
255 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!
1
vote
1answer
136 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 ...
0
votes
2answers
345 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 ...
3
votes
0answers
694 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, ...
1
vote
1answer
2k 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 ...
4
votes
1answer
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 ...
1
vote
0answers
48 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 ...
0
votes
0answers
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 ...
0
votes
1answer
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
vote
0answers
901 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
3answers
12k 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
1answer
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 ...
4
votes
1answer
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 ...
