Home Forums Reporting Services Reporting Services SQL Trace on a specific report RE: SQL Trace on a specific report

  • July 23, 2013 at 1:50 pm

    #1635120

    you should be able to fix it without a trace at all; the error is in the report itself.

    somewhere in that' reports definition,you've got something like

    ...WHERE ClientID = (SELECT ID From AnotherTable)

    for that one client, that table has more than one row, and causes the error.

    grab the definition of the report, and find it.

    simply changing it to an IN would fix it immediately.

    ...WHERE ClientID IN (SELECT ID From AnotherTable)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!