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

Sharing SSRS reports with my organization

We are currently trying to make use of SSRS within my organization and I want to know how other organizations share these reports with the broader organization without having to give every individual rights to the SQL databases on the SQL server. We…
IamJOR
  • 1
0
votes
2 answers

SSRS - Report Builder: Show Items from groups in a column chart using tooltip

I think that it might be easy, but I cant figure out how to make it work. I have a column chart with tickets grouped by time (rounded to 15 minutes) X Axis - Time Group (Rounded to 15 minutes) Y Axis - Count(Tickets) I'd like to show "ticket…
Dmytro
  • 372
  • 2
  • 12
0
votes
0 answers

Grouping a set of revolving years (Reporting Services 2016)

Long time Stackoverflow user, but never actually asked questions. I'm currently stumped on a report request. What I need to do with Report Builder is displaying data on pages grouped by three years, but here's the catch: I need it to be revolving. I…
CharliesChocolate
  • 1
  • 1
0
votes
1 answer

SQL Server Report Builder - Expression

My condition is that industry who has paying highest time amount and total receivable amount of that industry My expected result is ABC industry is highest number of count and total receive amount for that is 3584 I am trying find SSRS expression…
Mitesh Patil
  • 1
0
votes
0 answers

Two rectangles next to each other

UPDATE: I managed to work around the issue: Using Subreports content stays on the first page, but I get an empty second page. Is there any logic to SSRS-behaviour? Hi I have report which needs to export to PowerPoint and I need two rectangles to…
5th
  • 2,097
  • 3
  • 22
  • 41
0
votes
1 answer

SSRS Multi Value Parameter Count Expression

I am trying to count the number of records through a count expression in a text box based on the multi value parameters that are chosen. My table: WSVLWOs WO_NUMBER WO_ACTN_TY 18-003759 Adjust to Grade 18-005909 Repair / Replace…
klavoie226
  • 31
  • 5
0
votes
1 answer

Microsoft dynamics Mediaset Datatype and SSRS

I have a table called Item in Microsot Dynamics (NAV). One of the requirement is to display a picture that is attached to the item. The SQL datatype of this field is "uniqueidentifier". However, when looking at the development environment for…
Harry
  • 2,636
  • 1
  • 17
  • 29
0
votes
1 answer

Search XML of SSRS Reports to find custom code

I have an unknown number of reports that use a specific piece of custom code and I would like to be able to identify all reports that call this code. The code looks like: dim Counter as integer=0 Public function getCounter() as…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
1 answer

SSRS The Report Server has Encountered a Configuration Error

I'm running SSRS 2016 on a local machine for development purposes. I've been running into this error quite frequently and spontaneously, as in I will run a report, then 3 minutes later try running the same report with the same parameters and all of…
jprice92
  • 387
  • 4
  • 18
0
votes
0 answers

We have modified the DataSource but when pulling the datasource information from TSQL script we find the 1st connection string only

We have modified the DataSource in the web, but when pulling the datasource information from TSQL script we find the 1st connection string not the new modified connection string. I have researched and found others that have this issue, where are…
Elizabeth
  • 11
  • 2
0
votes
1 answer

SSRS Report not correctly suppressing white space

I have seen some mind-binding situations with SSRS reports in my few years of using it, and I've been able to design around most issues and get it to do everything I've been asked to do. But apparently, not something extremely simple! I'm using…
VorTechS
  • 473
  • 5
  • 12
0
votes
0 answers

Azure Load Balancer - SSRS Scale Out

I have deployed SSRS-Scale out along with Azure Load balancer. Seems it is working but I see the below error for some executions. Seems Report viewer cache the session along with the user name of local instances in the database and if the successive…
alex
  • 51
  • 4
  • 10
0
votes
2 answers

SSRS How to change export Excel Tab Name (2) when ther is no group name

I am using "Break to new page" for every Group value in my report. And I set the TAB names of the excel export to be the Group-Value itself. This works fine for the data within a group. But on the last TAB there is the overall "TOTAL" which is in no…
Johnny Spindler
  • 358
  • 4
  • 14
0
votes
1 answer

SSRS ReportExecutionServce.LoadReport gets stuck

Consider the following example code: using System.Data.SqlClient; namespace ReportLoadTest { class Program { static void Main(string[] args) { using (var con = new SqlConnection("...your connection string here...")) { …
CarlDaniel
  • 333
  • 3
  • 16
0
votes
2 answers

SSRS "Could not create folder" "Something went wrong. Please try again later."

I'm brand new to SSRS. I'm trying to create a new folder in our SSRS portal, and I'm getting this error. I googled the title of this post and literally got no results with the quotes. I can't be the first person ever to have this issue (or ask…
rory.ap
  • 34,009
  • 10
  • 83
  • 174
1 2 3
…
30 31