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

SSRS expression to calculate total based on daily counts that have conditions

In a totals row (location is row group, date is the column group), I'm not sure how to calculate a total based on the below expression that I've been using to calculate "overcapacity" daily totals. I'm trying to total up the daily overcap…
tomorrowgrl
  • 3
  • 3
0
votes
0 answers

Why is the SSRS Barcode breaks up with a space in between?

I have a SSRS report which I've initially created with SQL Server 2014 Report Builder (12.0.6024.0) using Code128 according to this post. It has been working great until we wanted to upgrade our SQL Server to 2016 and then I made the same report…
Glenn94
  • 179
  • 1
  • 9
0
votes
1 answer

SSRS (Report Builder / MS SQL 2016) - SSRS expression to combine results of two rows that are part of a group

Summary of report: I have created an SSRS report where the user selects a range of dates, and the report calculates Visitor Count and Visitor Over Capacity Counts for different Locations for each day in a range selected by users (each day displays…
tomorrowgrl
  • 3
  • 3
0
votes
0 answers

Generate SSRS report in PDF from WebService throws error

Im trying to generate SSRS report and export it to PDF using webservice(asmx) but getting the following error when try to set datasource credentials. Previously I have done it in WebApi and it works fine. Value does not fall within the expected…
FullStack
  • 198
  • 7
  • 16
0
votes
0 answers

Cannot Add data sources in SSRS

I cannot add/manage Data Sources within the SSRS when HTTPS is enabled & HTTP disabled. Everything else within the SSRS works without error. Steps- I open the SSRS URL and select a data source. Before data source properties page can load I receive…
Patrick
  • 1
  • 1
0
votes
1 answer

Can I create folder on SQL Server Reporting Services using store procedure

i possible create new folder using gui method. Is it possible create new folder using mssql stored procedure?
santhiran shan
  • 15
  • 3
0
votes
0 answers

Transition SSRS Reports From Sharepoint Integrated Mode in SP 2013 to Using A Web Part in SharePoint 2019

Let me start off by saying how confused I am. I have a significant number of SSRS reports running in SharePoint Integrated mode on a SharePoint 2013 site. We are now switching to SharePoint 2019, which did away with integrated mode. I need to switch…
FlyFish
  • 491
  • 5
  • 22
0
votes
0 answers

SSRS-2016 Redirect for Specific Traffic

Is there a way to redirect SSRS - 2016 to a specific folder depending on the origin URL? For example, if the origin were: http://originsite.com/Reports.aspsx I would want the report viewer to land on folder: /SpecificFolder and NOT on the Home…
NoobCoder
  • 1
  • 2
0
votes
0 answers

SSRS 2016 - ReportViewer Not Landing on Proper Folder

I am using an IFrame to render the SSRS Report Viewer. It keeps landing on the Home folder instead of the specific folder for my reports. I tried setting the folder in the URL but it did not make a difference. I would appreciate any help. HTML…
NoobCoder
  • 1
  • 2
0
votes
1 answer

How to show large ssrs reports on the browser

We wanted to show data on browser from reporting server, but sometime it's failing to load and taking more than 3 mins. Is there any better approach to get the data faster.
Srikanth
  • 21
  • 3
0
votes
2 answers

I have a SSRS calculation but i do not know how to get it to work in SSRS

the equation TotalDebits = result.CreditsAndDeposits + result.Refund - result.RentTax - result.SalesTax - result.Insurance How can I get the calculation in SSRS? My data table results Any ideas would be great.
Jeannie Ramirez
  • 3
  • 3
0
votes
0 answers

In SSRS how to make a net Revenue out two total columns in table

I have a table in SSRS that show all sources I have revenue from but I need to have net revenue based on a total column and the concessions column. I am fairly new to SSRS and not good at expressions calculations. Revenue screenshot:
Jeannie Ramirez
  • 3
  • 3
0
votes
2 answers

Getting totals in SSRS today(), Month, Quarterly and year to date

Data from main table i have the following SQL query: SELECT ISNULL(SUM(intIntrosHot), 0) Hot, ISNULL(SUM(intIntrosCold), 0) Cold, ISNULL(ISNULL(SUM(intIntrosHot), 0) + ISNULL(SUM(intIntrosCold), 0),0) Total FROM tblUBMReport WHERE…
Jeannie Ramirez
  • 3
  • 3
0
votes
1 answer

SSRS - AccessDeniedException when running reports via Report Builder

I recently cloned an SSRS native installation from one set of application and db servers to another. The keys from the old installation were backed up and successfully re-applied in the new installation restoring access to all encrypted…
pmn
  • 187
  • 1
  • 1
  • 10
0
votes
1 answer

SSRS Using an expression to specify values for parameters

I am trying to have a parameter that either filters out interns or includes interns and every other job title using a column that holds 'Yes' or 'No' whether that job title is an intern. The basics of my code are like…
scorbin
  • 9
  • 5
1 2 3
…
30 31