Stack Overflow
Stack Overflow

Questions tagged [ssrs-2016]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2016.

463 questions
0
votes
1 answer

repord builder does not display data when in run mode

I have the following report result when "run" from the designer (report builder). Please note that even the header strings are empy!!! If I save the report on the SSRS server (same query, same sql server) I get: An even more weird, if I export to…
tschmit007
  • 7,559
  • 2
  • 35
  • 43
0
votes
3 answers

How to display records in blocks in ssrs

I am working on a report. The report needs not to be in tabular form. We have a school which has sub branches. Now I need to display the record in the form of blocks using Visual Studio Data Tools i.e. SSRS. Each block will contains School branch…
Muhammad Nasir Khan
  • 49
  • 2
  • 10
0
votes
0 answers

MDX (how to have various Date Dimensions in a single X Axis?)

I have a cube containing facts each containing at least one Date Dimension : Fact : Fact_Sales , Fact_Leads , Fact_Budget Dimension Column : FactorDateID , LeadIssueDateID , BudgetDateID Now I need a Bar-chart with dates…
mana
  • 1
  • 1
0
votes
0 answers

SQL Server 2016 REPORT SERVER REPORTS ARE NOT VIEIWING PROPERLY IN VS 2008 9.0 REPORT VIEWER

We have migrated from SQL Server 2008 R2 to 2016, and now reports are not displaying properly in VS 2008 9.0 version of report viewer. Can anyone tell if we can view reports of SQL Server 2016 in VS 2008 report viewer? As it is not displaying…
Adnan Latif
  • 77
  • 1
  • 12
0
votes
0 answers

How can we edit RDL made on Visual Studio 2015 to the lower version of Visual Studio

I have made a SSRS Report on Visual Studio 2015, So is there is some way that I can open it on Visual Studio 2012 or else. I tried to change the year on URL path of SSRS code but that too didn't worked for me. Thanks in Advance.
user2728106
  • 185
  • 2
  • 5
  • 15
0
votes
0 answers

SSRS Matrix Variance Calculation - Columns

I am trying to calculate the variance between two dataset grouping. My datasets are my fiscal years. The fiscal years have month. On the left, the report will only show current month data. To the right, there will be a year-to-date comparison. I…
Sagar S
  • 41
  • 1
  • 6
0
votes
0 answers

SSRS 12.0.0.0 upgrade to SSRS 13.0.0.0

i am having application which is already working with SSRS 12.0.0.0 version i want to upgrade it now to 13.0.0.0 for that i have added new Microsoft.ReportViewer.WebForms version reference which is 13.0.0.0 in the application and done all required…
Liquid
  • 648
  • 1
  • 7
  • 20
0
votes
1 answer

SSRS: Create custom error message when an external web-service is down

I'm fixing the last bugs on my SQL Server Reporting Services 2016 application. I've just realised that when one of my external web-services is down, the application crashes: 'An error ocurred during local data processing'. How can I check if the…
Luis Gouveia
  • 8,334
  • 9
  • 46
  • 68
0
votes
1 answer

SSAS and SSRS data not tally

Can someone enlighten me why this is happening? I am doing a SSAS tabular model with one of the table (refer image in the link below) where the calculated cols as follow: location_rank =COUNTROWS(FILTER('f_p_txn', EARLIER([fk_p_key])=[fk_p_key]…
jcy
  • 1
  • 1
  • 8
0
votes
2 answers

How to move SSRS mobile report (Mobile Report Publisher) from one server to another?

I have created a mobile report with a dataset from Server A (dev). I know want to move that report to Server B (prod). Is there a way to do this? When I open the report in Report Publisher and do Save As -> Server I am unable to select a different…
Venezuelan
  • 13
  • 4
0
votes
1 answer

SSRS 2016 IIF statement for font color not working in header

I have a couple reports that allow the user to change font colors with a parameter selection, this is the expression in the font color attribute: =IIF(Parameters!Display.Value = true, "#000000", "#ffffff") We just moved reports to a new 2016…
BattlFrog
  • 3,370
  • 8
  • 56
  • 86
0
votes
1 answer

Reporting services 2016 (ssrs) prompts with username/password

Authentications Prompt When I open SQL Reporting Services 2016 it's prompt above windows authentications. I need to bypass prompt and allow direct login to service. Please help.
Sudu
  • 51
  • 1
  • 2
  • 9
0
votes
1 answer

SSRS plot value of DataSet multiple times

I have a table of data like so. I would like to plot it on the same graph. I managed to get it to plot when putting it in a table that sorts on category "GreenTemp1", but what I would like is to plot it together on the same chart. Can anyone help…
PreciousRoy
  • 83
  • 2
  • 6
0
votes
1 answer

SSRS 2016 - data bar chart with repeating color states over time

I use MS SSRS 2016 Enterprise. I have measured values over time that I want to show on one bar chart. Values consists of time and status that was measured in that time, e.g.: time | status 05:01 | G (green) 05:15 | R (red) 06:08 | G 11:41 | Y…
user3867873
  • 47
  • 3
  • 12
0
votes
1 answer

SSRS 2016 : Moving the position of the entire parameter box from top to left

I want to move the entire parameter panel that defaults to the top in SSRS 2016 to the left of the report. Has anyone done this in the past? I can reorder the individual parameters in the panel but I want to move all these parameters to the left…
CarbonD1225
  • 851
  • 6
  • 24
  • 39
1 2 3
…
30 31