SSRS table populating data into a field that should be blank

by Bill Hughes   Last Updated September 14, 2018 16:06 PM

I am having trouble resolving an issue. I have a table on an SSRS report. The query for the table gets the definition, the total count of that definition and calculates the percentage of all the counts. However, as you can see in the image, one field is being populated with another fields data when it should be blank. Are there any SSRS experts out there who can lend a hand?

Here is the query:

SELECT fundingyear
    , loan_type
    , COUNT() AS total_lntype
    , COUNT() * 1.0 / SUM(COUNT(*)) OVER (PARTITION BY fundingyear) as lntype_perc 
FROM vw_LoanRpt 
WHERE loan_type not in ('Line of Credit') 
GROUP by fundingyear, loan_type 

SSRS Table

Tags : ssrs ssrs-2016

Answers 1

Disregard. I found using a Matrix instead of a table resolves the issue.

Bill Hughes
Bill Hughes
September 14, 2018 15:51 PM

Related Questions

SSRS 2016 Datasource - SQL Server 2000 database

Updated February 27, 2017 22:06 PM

Reporting Services 2016 Multiple Email Accounts

Updated June 05, 2017 16:06 PM