Stack Overflow
Stack Overflow

Questions tagged [ssrs-2019]

76 questions
0
votes
0 answers

Shared Schedules & Always On Availability

We are running a report server on a SQL 2019 Always on AG in MS Azure. When you go to see the Shared Schedules in Reporting Services and SQL Server is on the secondary replica, RS cannot see these shared schedules, you receive the error: An error…
SleepingSidewinder
  • 9
  • 2
0
votes
2 answers

Get count of specific values in a single field for a given group of records

I have a set of records in SSRS (SQL Server 2019) with a "code" field that has a value from a list (M, S, W). I'm grouping on another field and need to get counts of this field's value within the group (i.e., how many rows in the group have S, how…
inkswamp
  • 5
  • 1
0
votes
0 answers

Can user permission to SSRS 2019 be changed or overruled without admin access?

I tried to download documents in bulk from a SSRS 2019 server by following this stackoverflow thread. Unfortunately I do not have sufficient permissions as can be seen from the prompt below: Failed to retrieve item definition of '/directory' from…
Rivered
  • 741
  • 7
  • 27
0
votes
0 answers

Is there a workaround for sending large payloads to API clients?

According to this StackOverflow question, circa 2012, the Win32 API HTTP server HttpSendResponseEntityBody() data structure that is utilized by SSRS has a hard limit on the EntityChunkCount of 9999. That appears to be the max size for an array of…
Ross Bush
  • 14,648
  • 2
  • 32
  • 55
0
votes
0 answers

SSRS Downgrade from 2019 to 2017

We are currently running SQL Server 2017 and I installed SSRS 2019 evaluation by an accident, only realizing after users had been working on it. What would be the best procedure to downgrade from SSRS 2019 to 2017 without affecting the reports…
DimitriTRG
  • 1
  • 1
0
votes
0 answers

SSRS Report not rendering automatically unless View Report button is pressed (All parameters set to valid values)

SSRS Report not rendering automatically unless View Report button is pressed (All parameters set to valid values). As soon as user clicks on View Report, the report is rendered. Actual requirement is to hide the parameters. However, since the report…
Kasim Husaini
  • 392
  • 3
  • 14
0
votes
2 answers

SSRS 2019 not show recently installed font type when export to pdf in WIndows Server 2019

Currently I have facing font type is not display correctly when export template/report to PDF in server. I have SSRS 2019 installed in Windows Server 2019 and also install the new font in Server. But when export the template/report in SSRS 2019 the…
Yogie Sanjaya
  • 1
  • 1
0
votes
1 answer

How to pass parameters to HIVE LLAP via ODBC in an SSRS report query

I am creating an SSRS report in VS 2019 and have an ODBC datasource using the Cloudera ODBC Driver for Apache Hive and am unable to get parameters to work so far. I have created a dataset, query type text and everything works fine if I have static…
Scott Szretter
  • 3,938
  • 11
  • 57
  • 76
0
votes
1 answer

Combining Remove and Replace Function in MS SQL Report Builder

A field gives me the following string: #$TEXTA#$TEXTB#$TEXTC I want to remove the #$-chars and seperate the values by a new line. In addition I want to replace special characters (&). In the end it should look like this: TEXTA TEXTB TEXTC So I use…
knollo
  • 9
  • 4
0
votes
1 answer

Switch statement as a color expression in SSRS

I´m stuck on a color expression using a switch command. I want to be able to set the color green if the following is true. =Switch( Fields!direction.Value = "North" and (Fields!transport.Value = "Car" and Fields!units.Value >= 1) and…
Kiwie
  • 1
  • 1
0
votes
0 answers

SSRS Date Parameter Formatting Issue

I am using SSRS 2019 and have an issue with date formats. I have a report that takes 2 date parameters using the report date picker, when I run the report through visual studio 2019 the report date picker dates are in the right format. When I…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
1 answer

I want to be able to to pull through the previous school in which a pupil left to start a new school? (Lookup function)

In our database, there is a list of schools which a pupil attends over their lifespan. I have attached a photo below to show how it structured whilst cropping out the confidentiality bits. I have already got a main dataset where specific…
EducationSRSS
  • 1
  • 1
0
votes
1 answer

Configuring SSRS 2019 Database Fails

We are trying to install SSRS 2019 on Windows Server 2016. For the SSRS Database the SQL Server 2016 is on another Windows Server 2016. Both the server are on the same domain and are both pingable to each other. While configuring the database, get…
MATTA
  • 55
  • 8
0
votes
2 answers

SSRS 2019 does not render images on https url in html5 format

Hy everyone, i have some ssrs-server on version 2017 and some ssrs-server on version 2019. All server provides the same ssrs-reports, just for different customers. On the ssrs 2017 all works fine. But on the ssrs-server 2019 i have the problem, the…
Thomas
  • 21
  • 4
0
votes
0 answers

SSRS How to limit the number of group rows per page

I have a SSRS report with dataset as follows: Record 1 Item 001 Qty 10 Category A Record 2 Item 002 Qty 10 Category A Record 3 Item 003 Qty 10 Category B Record 4 Item 004 Qty 10 Category B Record 5 Item 005 Qty 10 Category B I Add Group by Category…
Thianto Andayana
  • 1
1 2 3
4
5 6