Error occuring in report processing

• sweta_jamale

  SSC Veteran

  Points: 221

  More actions

  November 12, 2010 at 10:56 pm

  #388221

  I have certain rdls created in SSRS 2008 and deployed on a Share point server.Some of these reports fail on the server side with the following error:

  An error has occurred during report processing. (rsProcessingAborted)

  Query execution failed for dataset 'DataSet2'. (rsErrorExecutingCommand)

  For more information about this error navigate to the report server on the local server machine, or enable remote errors

  But when i download the same and preview them in VS the output is displayed.Sometimes when i redploy them the report start working at the server side as well.

  Can someone help me on this?

• rktn_odin

  SSChasing Mays

  Points: 636

  More actions

  November 14, 2010 at 8:42 pm

  #1250507

  Use SQL Profiler to trace your query.