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

SSRS 2016 Role Assignments

I have recently installed Reporting Services 2016 on a server. When I try to add a user it only allows me to assign 2 roles to the user. System Administrator and System User. I should be able to add them to Browser, Content Manager and…
Cornflake2068
  • 533
  • 1
  • 5
  • 17
0
votes
1 answer

Colored Tiles in SSRS / Mobile Reports

i want a really simple report: A square tile and it should display a number for values > 0. The color of the tile should be managed no matter what numeric value is being displayed. I tried to do it with mobile reports in sql server 2016 but there i…
tuxmania
  • 906
  • 2
  • 9
  • 28
0
votes
1 answer

Highlight top and bottom 10% in SSRS table

I want to highlight the Top and Bottom 10% of values in my SSRS Table. The sample table should look like this - I have prepared below in Excel Sheet, Is it possible in SSRS-2016?
Rameshwar Pawale
  • 632
  • 3
  • 17
  • 35
0
votes
1 answer

sql ssrs returning multiple selected @parameter

I have a multi value parameter which is a combined string of two fields with a space separating them i.e productID productName. I want to pass just the parameter with just the id portion only. I tried the expression: =join (left…
Trang Le
  • 87
  • 1
  • 9
0
votes
2 answers

Filter in TextBox Expression SSRS

I have 5 visualizations in my rdl file. After each visualization I have a ABOUT Textbox which should be filled from a database table and it has html content to render. Consider a table with 5 rows having visualization name and ABOUT…
Rameshwar Pawale
  • 632
  • 3
  • 17
  • 35
0
votes
1 answer

SSRS 2016 (web portal) authorization issue

I am having a lot of trouble getting a user (other than my own user account) set up to use the web portal on SSRS 2016. With my user account I can view and manage all the reports, data sources, and other objects but now that I am trying to grant…
David
  • 194
  • 1
  • 13
0
votes
1 answer

Why doesn't my Selection List filter my Category Comparison Chart?

I am using the new SQL Server Reporting Services Mobile Reports in 2016. I have added a Selection List to a report that's based on a dataset. I have checked the option to filter my dataset when a selection is made, but when I save the report and…
Camron B
  • 1,650
  • 2
  • 14
  • 30
0
votes
1 answer

In SSRS 2016, how do I specify a MDX unique name as a report parameter default?

In SSRS 2016, I'm writing some reports against a Tabular instance. We're using MDX as the query language. I'm having issues specifying a default unique name by hand in the report. Any ideas? Is it a bug? An escaping issue? We've got a number of…
Steve Cardella
  • 57
  • 10
0
votes
1 answer

SSRS 2016 Web protal in IE8

We have recently installed SQL 2016 at one of our client. We encounter error while accessing SSRS 2016 from a machine having IE8. We know that SSRS 2016 is compatible with MS Edge, IE 10 or 11, Google Chrome and Mozilla Firefox The best option is to…
Aleks
  • 13
  • 3
0
votes
1 answer

SSRS BIDS 2005 to 2015 Data Tools migration: Filters with IN operator migrating improperly

I am migrating an SSRS 2005 BIDS project to Visual Studio 2015 Data Tools and I am seeing issues with migrating DataSet filters that use the IN operator. The reports seem to work correctly, but when I view the Filter expression in the designer only…
KyleLib
  • 774
  • 3
  • 9
  • 26
0
votes
1 answer

How to make a simple Totals Chart in SQL Server Mobile Report Publisher?

I am trying to make a bar graph that displays the total units a sales person made and display it in Mobile Report Publisher; EX: Tim ----- Blake --- Chad - Greg -------- My query is simple: SELECT t.Sales_rep, COUNT(t.Sales_rep) as counted FROM…
Michael Gulik
  • 141
  • 11
0
votes
1 answer

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 new server with Windows Server 2012 r2, I have…
DafyddNZ
  • 234
  • 2
  • 12
0
votes
1 answer

SSRS Parameters Hidden and Unhidden

I have a report that requires a branch name as parameter. There are also other parameters like business year, quarter etc. This report will be accessed via two methods. 1. Via the SQL Server Reporting Portal. Users at head office will access this…
LordRofticus
  • 181
  • 1
  • 2
  • 13
0
votes
1 answer

Two SQL Server Instances

I have a server running SQL Server 2014, Enterprise Edition, with many large databases. I am currently using SSRS 2014 to create on-premises reports from this data. I really like the new features of SSRS 2016. My question is: can I install SQL…
controller
  • 185
  • 1
  • 2
  • 11
0
votes
2 answers

SSRS 2016 - Change CSS of Report Server

I want to change the css file of my reports. How can I do it with reporting services 2016? The old methods didn't work for me (add style sheet file or make changes at the HtmlViewer file).
שמוליק והדס סתיו
  • 11
  • 4
1 2 3
…
30
31