Data not showing

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  May 27, 2016 at 6:41 am

  #327321

  Good day experts,

  I build a report and to my surprise the tsql query inside the report doesn't return any data but when i run the same query in management studio the data is returned.I checked my datasource its correct.

  How can i get around this problem?

  Thank you in advance

• Thom A

  SSC Guru

  Points: 99137

  More actions

  May 27, 2016 at 6:59 am

  #1881780

  Have you tried running a trace to see what SQL SSRS is actually running? If you have parameters involved, it may be it's passing a value you're not expecting and returns no results.

  Hopefully running a trace will show quite easily where it's going "wrong".

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk