Stack Overflow
Stack Overflow

Questions tagged [ssrs-2017]

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

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2017 in October 2017. More info in the tag.

169 questions
0
votes
1 answer

ssrs - embed html id, name or otherwise identify a table or element

I have a ssrs report server which generates reports, which I would like to embed into other pages. I have found that I can embed the entire report in an iframe quite easily, but I would like to hide everything inside of this iframe except for the…
Daniel Paczuski Bak
  • 3,720
  • 8
  • 32
  • 78
0
votes
2 answers

Configuring SSRS 2017 to use LDAP for user authentication

I have an SSRS environment currently configured to use active directory to authenticate users but now have a requirement to use LDAP for authentication. I have never worked on this kind of configuration and my google searches are not returning any…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
0
votes
0 answers

How to access the containing TextBox in SSRS Custom Code

I would like to build some SSRS custom code that when called, accesses the textbox (the control) containing the expression and modifying it. Is this possible? If so, how? I would like to use FindControl, but it requires access to the page object,…
Daniel Paczuski Bak
  • 3,720
  • 8
  • 32
  • 78
0
votes
0 answers

SSRS: Consume input from user and pass it to subreport

I understand that this is not what SSRS is for, but I don't have the option of picking a tool. Ideally, nothing other than SSRS would be used. We would like to implement commenting on our test reporting. What this means is that the user will click a…
Daniel Paczuski Bak
  • 3,720
  • 8
  • 32
  • 78
0
votes
1 answer

SSRS How to calculate Moving Range

Year Sales Moving Range 2000 6461 2001 3459 -3002 2002 4595 1136 2003 9726 5131 2004 7109 -2617 2005 8576 1467 2006 2962 -5614 2007 7203 4241 I have a dataset similar to the above and need to…
DataMan
  • 139
  • 1
  • 2
  • 14
0
votes
1 answer

SSRS 2017 weird behavior with Column Chart for Custom Label Text on Horizontal Axis

I am experiencing weird behavior with SSRS 2017 column charts. Please see below scenario and sql script provided for the same. SSRS Chart Type - Column Category Group - Group on ReportType, Label - ReportCustomText Horizontal Axis Option Axis Type -…
Sandesh
  • 1,036
  • 5
  • 13
0
votes
1 answer

Incorrect Parameters population in SSRS

My report has multiple parameters where the data populated in the dropdown does not show proper data. My parameter is suppose to populate 3 values(Say A, B, All). My parameters are populating just the ALL value in the drop down. I have checked the…
Priyanka2304
  • 200
  • 3
  • 16
0
votes
1 answer

Opening a SSRS report in PDF format on an image click

I am new to SSRS and having hard time rendering a report in PDF format. I have a master report which within has a PDF icon. My requirement is to get a report that uses the parameters from SSRS master report and open the report in PDF format in new…
Priyanka2304
  • 200
  • 3
  • 16
0
votes
0 answers

Deploying an SSRS report to a Power BI Server

I'm new to Power BI but I developed reports from SSRS. I'm trying to deploy a report from SSRS (SSDT 17) to a Power BI report server. I see that it created my report and my data source, but I'm getting an error that it connect/find the server: A…
Dustine Tolete
  • 461
  • 1
  • 7
  • 19
0
votes
1 answer

making specific value as default in a parameter ssrs(rdl)

iam using visual studio 2017 and make an rdl report and i have a parameter (drop down)that takes it's values from the query select column1 from table1 suppose that there are five elements A,B,C,D,E in column1 of table1 how to set first value…
oula alshiekh
  • 843
  • 5
  • 14
  • 40
0
votes
1 answer

SSRS 2017 - Can't Go to Next Page

I am viewing a report deployed to my SSRS 2017 report server. When the report runs, it show 0/0 pages and clicking on the next page button does nothing. When I export the report to PDF I get 129 pages. If I use the search box to look for text within…
Neil
  • 911
  • 7
  • 25
0
votes
1 answer

`Login failed for user ''` when executing report with dynamic data source and unattended execution account

For version 14.0.600.689 I've setup unattended account, data source based on parameter and Credentials option "Do not use credentials". It works fine. Than on another server we've upgraded to latest 14.0.600.744. And same configuration gives an…
Igor Golodnitsky
  • 4,456
  • 7
  • 44
  • 67
0
votes
0 answers

SQL Reporting Service 2017 in Virtual Server

I am trying to set up Reporting Service 2017 in a VPS. The problem comes when I finish the installation of SQL Reporting Service 2017 and try to access to the Web Service URL. Any of the options possible (by IP, LocalHost, domain name...) give any…
JCdV
  • 1
  • 1
0
votes
2 answers

SSRS 2017 edit htmlViewer.css

As I want to change the layout of the report viewer, I edit the htmlviewer.css which is saved under :\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\Styles. But After i modified it, nothing was changed in the…
Tisa
  • 31
  • 7
0
votes
1 answer

Are SQL Reporting Services Hidden Parameters Secure?

If a make a @UserID hidden parameter in my SSRS report and set that server side in a ReportViewer control is that parameter then secure or could it be altered by the end user? I am using SSRS 2017.
LarsHJ
  • 205
  • 1
  • 11
1 2 3
…
11
12