Post reply

Debugging Dynamic Query SSRS

  • February 4, 2008 at 4:41 pm

    #181627

    I have an SSRS report I am developing. I am using a dynamic query and when I execute the query from Data tab in Visual Studio, I give the parameters and it works great. Output comes back as expected. However, in preview mode, I man not getting the correct result set.

    My guess is clearly that some value I am passing is making the query come back null.

    Is there a way that I can debug this. I need to see what I am passing or at least be able to add 'print' to my sql and see the exact sql it that I am running after I pass the values.

    Does anyone know of a way I could do this? Was thinking I could do a trace on the SQL side, but not ideal.

    Thanks

    Greg

  • February 12, 2008 at 11:46 am

    #777469

    you need to create parameters, its located under report menu. Once you create the parameters you will be asked for value within the report viewer.. and few the correct result set as the data section.

  • February 12, 2008 at 11:52 am

    #777472

    You can use Profiler, get the event "RPC: Completed"

    Sérgio C Fonseca

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

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