report processing error

  • hi

    i am getting error while running report, "report processing failed for the dataset, error converting nvarchar to date time"

    any suggestion?

  • you will need to fix the RDL that generate the report and fix a missing CONVERT issue.

  • but i dont know what is the conversation that i m doing wrong,its in parameter or what.

    how to see that

  • it could be a parameter OR it could be in your stored procedure or SQL text.

    you can fix / look for problems by using SQL Server Business Inteligence Develpment Studio tool. (BIDS)

    open the rdl in BIDS and verify what it is doing.

  • the same data set is running in different report,so its not in my sp.now in my report there are so many dataset,how to see which parameter?

  • open the Parameters box in BIDS.

  • i did,there are so many parameter, how to see which one is causing problem

Viewing 7 posts - 1 through 6 (of 6 total)

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