Post reply

Data not showing

  • 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

  • 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

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

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