Data not showing

  • tmmutsetse

    Hall of Fame

    Points: 3489

    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: 98022

    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply