Duplicates showing in a SSRS report but not in SQL

I have a report that uses a stored procedure in SQL.  When I run the query in SQL I get the correct results, one set.  When I run the report, it keeps repeating the results.  What should be one page is 32 pages.  I have no grouping and tried to set one, it didn't help.  The only rows set to repeat on the following pages is the header rows.   I tried hiding duplicates and then nothing showed.  Does anyone have ideas on what else to check?
SherryDeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike EghtebasDatabase and Application DeveloperCommented:
Could you make snapshot of the report in design mode (view) and upload here?

Mike
0
SherryDeveloperAuthor Commented:
Here's a copy of the screen
Report.docx
0
Mike EghtebasDatabase and Application DeveloperCommented:
I do not see anything unusual in it. Would you consider starting the report again but adding features incrementally to it? Start with very simple tablix with all default settings and preview the report before adding more settings to it. There are two possibilities, either it is going to work perfectly or you will come across the setting that messes up your report.

Above won't be necessary if someone provides you with a better solution.

Mike
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

SherryDeveloperAuthor Commented:
Well, did that.  Even added just one field and still get 30 pages.  No matter which column I add.  I even get the multiple when I just run the query in SSRS.
0
Mike EghtebasDatabase and Application DeveloperCommented:
Can you post the query, store proc, or whatever you have.

Mike
0
SherryDeveloperAuthor Commented:
I tried creating a new report and used a matrix instead of a table.  That works.  So am trying it on the original report.  Remove the table and add a new matrix.  Attached it the query
spTASDebtsNObligations.sql
0
Mike EghtebasDatabase and Application DeveloperCommented:
Upfront, I have to tell you I am new to T-SQL; I see that you have the last 3 fields included in the Group By clause. I think the may have to be removed.
	SELECT DISTINCT
		TD.OFFENDER_ID
	,	TD.OFFENDER_NAME
	,	TD.LOCATION
	,	TD.DEDUCTION
	,	TD.PAYABLE
	,	TD.INFORMATION_NUMBER
	,	COALESCE(SUM(TD.AMOUNT_OWING),0)AS AMOUNT_OWING
	,	COALESCE(SUM(TD.AMOUNT_PAID),0) AS AMOUNT_PAID
	,	COALESCE(SUM(TD.WRITE_OFF_AMT),0) AS WRITE_OFF_AMT
			
	FROM #TEMP_DEDUCTIONS TD
		
	GROUP BY TD.DEDUCTION,TD.OFFENDER_ID,TD.OFFENDER_NAME,TD.LOCATION,TD.PAYABLE,		TD.INFORMATION_NUMBER
-- ,TD.AMOUNT_OWING,TD.AMOUNT_PAID,TD.WRITE_OFF_AMT	
DROP TABLE #TEMP_DEDUCTIONS	

Open in new window

0
Mike EghtebasDatabase and Application DeveloperCommented:
At this point you are a bit more clear about the nature of the problem. I will suggest, if there is no answer yet, close this question with no points awarded and then post a fresh question to get some new experts involved with your debugging.

Thx,

Mike
0
SherryDeveloperAuthor Commented:
The grouping had to be there because of the aggregation.  I removed the table and replaced it with a matrix.  That worked with the query as it is.  Thanks for you ideas.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SherryDeveloperAuthor Commented:
Found my own solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.