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

Background color is not working if no data in database in ssrs matrix report

I have built matrix report with 2 parameters one individual and other one is cascading parameter when we have values than background color is working but, if no data background color is not working Is there any solution to apply even though no…
Kalleshi KS
  • 9
  • 7
0
votes
3 answers

Split comma separated values in a particular comma postion using SQL or SSRS report

I have a field in SSRS that is concatenated values like 1234,1456,3456,7890,3457,3245,4345 I need to break/split after 8th comma or in a particular position in next row like: 1234,1456,3456, 7890,3457,3245, 4345 Here values are dynamic but, we…
Kalleshi KS
  • 9
  • 7
0
votes
1 answer

How to Setup Default SSRS Report Variables

I have many reports which use a set of the same report variables: Is there any possibility not to insert them each time manually when creating a new report? Or may be there is a possibility to share these variables between reports as , for…
Natalie
  • 1
  • 2
0
votes
2 answers

SSRS - Cannot read the next row for dataset DataSet1

with TotCFS as (select count(*)*1.0 as TotalCFS, 'Total CFS' as RowTitle from PrivilegeData.TABLENAMEC c where cast(CallCreatedDateTime as date) between @StartDate and @EndDate and CallPriority in ('1', '2', '3', '4', '5') and AreaCommand in…
SQL.Life
  • 27
  • 6
0
votes
2 answers

SSRS REST API Embedded Data Source Credential Settings

I have a working solution that will deploy rdl report definitions to a report server using a POST request. These reports utilize embedded XML data sources that will include a request token for the target endpoint(s) (via https) and thusly don't…
tphuoc
  • 113
  • 1
  • 10
0
votes
0 answers

SSRS Dataset for KPI, multiple calculations

I am trying to setup a KPI that indicates the total of something in the data set used for the trend data. In this case the KPI can't seem to display a Sum'ed or Max'ed value, you have to do that action in the dataset query. I already have the data…
Whistler
  • 174
  • 6
0
votes
1 answer

SSRS query on remote linked server

I have configured SSRS on Server1. Server2 is linked to Server1 in sys.servers. All queries/reports link runs fine if I run Server1 objects I want to run report on a Server2 objects Try 1 I created a Shared Data Source to Server2, built query in a…
Eric Klaus
  • 923
  • 1
  • 9
  • 24
0
votes
1 answer

SSRS lookup missing dataset

I have a dataset which looks like this Name Spend "First Aid" 2 "Healing Arts" 0 "Surgeon" NULL I then have three separate textboxes which will be filled with the value of the column which matches the name. Example:…
Michael Tot Korsgaard
  • 3,892
  • 11
  • 53
  • 89
0
votes
1 answer

Unpivot in SSRS/Matrix

I am trying to unpivot some data in SSRS but am struggling to get the format I want. My current table and data is shown below :- CREATE TABLE [dbo].sampledata( [DDMMMYY] [date] NULL, [DayN] [nvarchar](4000) NULL, [CArticle] [int] NULL, [TU] [int]…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
0 answers

Predict future Data trends with current Data using sql script and them plot them over SSRS

I have been asked to create a trendline in SSRS, this trendline will the predicted future value based on current year data. Here I have data of year 2018 and I needed to predict the trends of ClaimVolume for year 2019. Please find the data Month …
user3726197
  • 1
0
votes
0 answers

http://localhost/ReportServer/ no setting to add role - permissions granted to user are insufficient for performing this operation. (rsAccessDenied)

Installed Report Server 2017. Running native mode with credentails: NT Service\SQLServerReportingServices account. My user is in the local admin group adn still get the below error. Problem is there is no settings icon for me to add roles. Where can…
Bill
  • 915
  • 2
  • 13
  • 23
0
votes
0 answers

SSRS 2017- Data Source option has disappeared from web portal

We have an SSRS server, and in the past, we would use the web portal to change the datasource and dataset in the sidebar menu. However, when we logged in recently, we noticed that this functionality had disappeared from the menu (see image below).…
Daryl1976
  • 675
  • 2
  • 8
  • 20
0
votes
2 answers

SSRS rounding to 2 when decimals

I am currently working on a report in SSRS 2017 and what I am trying to do is rounding to 2 decimal places when I have a number with decimals and do not show those decimals when I get a INT like 12.132 - 12.13 13 - 13 however when I add "0.00"…
Pablo Gûereca
  • 725
  • 1
  • 9
  • 23
0
votes
2 answers

Converting SAP nVARCHAR to a date

I am using SSRS 2017 to query a SAP hana database using an ODBC connection. I return a date column BUDAT as 20190101. I am trying to convert this to a date, but in the Sataset screen won't let me use the CONVERT or FORMAT command : Attempt…
Tony K
  • 1
  • 1
  • 4
0
votes
2 answers

Calling an Oracle Stored Procedures in SSRS via ODBC connection

I am trying to connect SSRS 2017 to an Oracle database to call a stored procedure via ODBC connection. I am able to connect SSRS to Oracle DB and run simple SQL queries. Every time I try to use a Stored Procedure name instead of a SQL query, I get…
Priyanka2304
  • 200
  • 3
  • 16
1 2 3
…
11 12