none
error occurred during report processing

    Question

  • An error has occurred during report processing. (rsProcessingAborted)
    Query execution failed for dataset 'dsResultParam'. (rsErrorExecutingCommand)
    Incorrect syntax near ')'.

    Hi all,

    i heard that the above mentioned  error is caused due to migration from SQL 2005 to 2008. Kindly guide how to resolve it

    Thursday, March 03, 2011 10:57 AM

All replies

  • Can you just check the dataset query? Looks more like a syntax error in the dataset query of dsResultParam. If you are not able to fix it, please paste the dataset query here.
    Cheers,
    Jason
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

    Thursday, March 03, 2011 11:15 AM
    Moderator
  • this is the query used

    BEGIN
    DECLARE @TEMP TABLE
    (
    col1 VARCHAR(10),
    col2 VARCHAR(10))
    INSERT INTO @TEMP
    SELECT distinct col1,col2 FROM DB.table_name
    
    UPDATE @TEMP SET col1='NULL' WHERE col1 IS NULL
    UPDATE @TEMP SET col2 ='NULL' WHERE col2 is NULL
    SELECT DISTINCT * FROM @TEMP WHERE col1 IN (@P_param_name)
    END
    
    
    Friday, March 04, 2011 4:39 AM
  • The error was because of lack of data availability in the table on which the query was based. Now thw report works fine.:)
    Friday, March 04, 2011 9:06 AM