Stack Overflow
Stack Overflow

Questions tagged [ssrs-2019]

76 questions
36
votes
8 answers

Download all SSRS reports

I want to get a copy of all .rdl files in one server. I can do the download manually one report at the time, but this is time consuming especially that this server has around 1500 reports. Is there any way or any tool that allows me to download all…
asmgx
  • 7,328
  • 15
  • 82
  • 143
2
votes
2 answers

SSRS String to Date conversion (mmddyyyy)

I have a String field in a Dataset in (mmddyyyy) format. I am trying to convert it into a Date field in SSRS. I already tried using the below command but I am getting error. CDate(Fields!LocalTXNDate.Value) Can anyone please suggest.
ASharma7
  • 726
  • 3
  • 8
  • 27
2
votes
1 answer

In Ssrs 2019, how does one interpret Subscriptions.InactiveFlags?

In the Ssrs database catalog, how are you supposed to interpret the InactiveFlags column of the Subscriptions table?
Granger
  • 3,639
  • 4
  • 36
  • 34
1
vote
1 answer

Report fails if length exceeds a few pages

I have an SSRS 2019 report which runs via a URL, generating a PDF document, in a web application. It has come to my attention that the report will fail - either the URL will fail with an "Err_Invalid_Response", or the PDF will download, but it will…
bmurrell30
  • 565
  • 8
  • 23
1
vote
2 answers

Connect TO Online SQL Azure DB FROM On-Premise SQL Server SSRS

I try to connect FROM my ON-PREMISE SQL Server SSRS 2019 TO an Online Microsoft Azure SQL DB. It works fine, when I connect locally from my DBMS to the online DB. Yet everything is secured with MFA though. Unfortunately I cannot get the connection…
Bender.
  • 71
  • 6
1
vote
2 answers

SSRS 2019 DNS Entries Give 404 when trying to run reports

I have set up a new SSRS 2019 site with HTTPS & DNS. When I am connecting to the site through the https://ComputerFQDN/Reports then everything works just fine. When I try to connect through DNS to https://DNSName/Reports then the main page comes…
CPickler
  • 83
  • 1
  • 14
1
vote
0 answers

How to display SSRS Reports in Web Application using .Net 6.0?

I am creating a web based application which will be displaying pre-developed reports on SSRS server. This application to be developed in .Net 6.0 with C#. Please do share sample source on how can I do it without using any third party tools.
Kasim Husaini
  • 392
  • 3
  • 14
1
vote
1 answer

SSRS 2019 -- subscription email fails ONLY when attaching the report

I have SSRS 2019 in native-mode with SQL Server 2019 standard behind it. To be very clear, email functionality works and outgoing emails from SSRS is being sent and received. The issue is when the option to attached the report (Include Report) is…
Doua
  • 183
  • 8
1
vote
0 answers

Broken Image Box in SSRS report

I have a few lines breaking up my report. When I run the report from the server or development I get a "broken image" box directly under my lines. I have tried to make the line a box or list box. The only way I can seem to get to work is to…
kguthrie
  • 11
  • 4
0
votes
1 answer

How to display a progress bar with multiple colors in a table cell in SSRS report?

I would like to change the presentation style of the Usage Rate column from a simple percentage with single background color to a bar, or a progress bar, with multiple colors based on the percentage value in a SSRS report. For example, when it is…
Shiraineko
  • 5
  • 1
0
votes
0 answers

Download SSRS report to a custom shared path

Is possible to open a report and save it to a custom shared path without using the default save as button? Like basically create a text box or similar and use it to define the shared path and when clicked it downloads the report to that path. I…
Jithin
  • 31
  • 6
0
votes
2 answers

SSRS 2019- Users in Browser Role cannot edit their own SSRS subscriptions

I am using SSRS 2019 version and noticed the issue that users in the Browser role cannot edit their own created subscription. However, they can create and delete their subscription. is there any workaround to allow users to edit their subscription…
Gajendra Singh
  • 61
  • 1
  • 9
0
votes
0 answers

SSRS 2019 not able to setup URL Reservations with port 443

here is the setup i have - Windows Server 2022 and SSRS 2019 i setup IIS and setup a test site using the SSL cert and that is working fine and since have disabled it i am trying to setup SSRS 2019 to work with HTTPS and it doesn't want to work for…
Hpatel
  • 1
0
votes
0 answers

ShowParameterPrompt property not working in SSRS ReportViewer API

I'm trying to enable ShowParametersPrompt in the SSRS ReportViewer API - Microsoft.Reporting.WebForms API. Help would be appreciated as it's not showing the parameters in my report. Only the toolbar is enabled. …
user3167162
  • 445
  • 1
  • 6
  • 23
0
votes
0 answers

Android Browser Render Chart of SSRS Report as a Broken Image

When I view a SSRS report in Android mobile browser, the chart within the SSRS report is rendered as a broken image, while other details, such as table data, can be rendered as usual. There is no issue when I view the same SSRS report in PC…
Shiraineko
  • 5
  • 1
1
2 3 4 5 6