Search code examples
reporting-servicesssrs-2008

SSRS report export error

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.

Solution

  • 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.