SSRS report export error

0
votes

I have a SSRS report which pulls data from a stored procedure. The report works perfectly fine on the web when im running it with different parameters. However, I get a duplicate row when im trying to export the ssrs report to excel.

1
reporting-servicesssrs-2008
what data does your stored procedure return in (SSMS) with the same parameters? Does it show duplicate rows in SQL? – Harry
The SQL doesn't return any duplicates. It's just when i export the report to excel, it gives me duplicate – Shahbaz Hussain
Are all the rows duplicated? – Harry
No only one row is duplicating – Shahbaz Hussain
Could you please show the output in excel and the report design layout (images) – Harry

1 Answers

0
votes

The actual reason why the row was duplicating was because of the stored procedure. Instead of distincting the selected values it was picking up duplicates. 

Select DISTINCT

There fore using a simple sql fixed it.