Post reply

Report Rendering Error

  • November 1, 2010 at 3:08 pm

    #228469

    I have created a report with a few filters based on a Report Model. It should return about 900K Records. But it gives the below error:

    The processing of SortExpression for the table ‘table’ cannot be performed. The comparison failed. Please check the data type returned by the SortExpression.

    When I run the query from the sql profiler for this report, it runs fine.

    Is the error because the no of rows returned is too much for reporting services to sort.

    Is there any way I could avoid this error?

    Thanks and Regards,

    Praveena.

  • November 2, 2010 at 7:55 am

    #1245373

    This is really an urgent requirement.. Could any body suggest a work around..

    Thanks in advance!

  • November 3, 2010 at 2:33 pm

    #1246286

    First I can't imagine that many rows (unsummarized) having any useful value, it is simply too much data to look through.

    Second, what is the sort expression you are using?

  • November 4, 2010 at 7:55 am

    #1246545

    Daniel,

    Thank you for the response. It is resolved. It was the way I created the report. The report was built to show summarized data, but I had a calculation in the reports for one of the columns which was causing it to return huge number of rows instead of grouped ones.

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

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