The tag has no usage guidance.

learn more… | top users | synonyms

5
votes
1answer
5k views

SQL Server Report Manager 404 using HTTPS

OK. I have scoured the Internet for information on trying to fix this and found nothing that deals with my situation. I started here, that lead me to here, that lead me to looking at netsh commands ...
4
votes
1answer
2k 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 ...
3
votes
1answer
628 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
votes
0answers
334 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, ...
2
votes
1answer
27 views

Migrating log files should i copy file/directory permissions?

Im planning to move the logfiles for the following databases ReportServer, ReportServerTempDB, tempDB, msdb to a new drive. But it seems that permissions arenĀ“t copied with the directories and files, ...
2
votes
1answer
36 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
170 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
3answers
8k 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
2answers
553 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
90 views

How to create column

I am new to ssrs report designing can any one help me in this I have two question 1) How to create a column to input user data and after that I need to perform some operations on data enter by ...
1
vote
1answer
81 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. ...
1
vote
1answer
952 views

SSRS pivot dynamic columns

I've tried to port this from a similar post, SQL query to return a column per date in date range? however I haven't been able to quite get it to do what I need... Please find some example code below : ...
1
vote
1answer
122 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 ...
1
vote
1answer
898 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 ...
1
vote
0answers
10 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 ...
1
vote
0answers
161 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
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 ...
1
vote
0answers
19 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 ...
1
vote
0answers
469 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
0answers
1k 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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
53 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).
0
votes
0answers
11 views

Convert spatial points data to line data for use in Line Layer in SSRS Map

I want to create a SSRS Line map report by creating a line between my booking country and delivery country and vary the line width based on the number of orders. I've added my shape file using ESRI ...
0
votes
0answers
17 views

Temporary migration to a new server for firmware upgrade

I need to temporarily migrate an SSRS deployment to a new server so that I can perform a firmware upgrade on the server. Once the firmware upgrade has been completed, I will move SSRS back to its ...
0
votes
0answers
8 views

Select on Matrix Rows Data

I want to perform a select query statement on Matrix rows data and wants to show in a spare column. Please verify picture: months data is being changed and employee number will remain same. Is there ...
0
votes
1answer
754 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
124 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 ...
0
votes
2answers
146 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 ...
0
votes
0answers
432 views

How to convert Excel into Star-schema Model?

My end user gave an Excel spreadsheet with 15 columns and 50K rows out of which 5 columns are calculated and 10 are not. My data modeler has converted Excel into a single TABLE on Microsoft SQL ...
0
votes
0answers
1k 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 ...