Conversion failed when converting the nvarchar value '%' to data type int?

[Former Member]

I have a crystal report designed in 2008.  This report does not contains any groups or subreports.  I need to Verify Database so I can pick up 2 new parameters in our stored procedure that this RPT pulls data from.  The second I click Verify Database I get the error "Conversion failed when converting the nvarchar value '%' to data type int".  The ONLY spot we are handling a percent symbol is in the formatting options for a couple of fields.  We have looked extensively at the SQL and the data being pulled and nowhere are we using a % symbol.  This has happened to several of our reports and in order to get around it we simply created a new RPT because the formatting was rather simple.  Yes, a new RPT will connect to the stored procedure just fine.

After I click OK on the error I am prompt as usual with filling in our parameters.  After I fill them in I then get another error "Invalid object name 'LBI_Reporting.dbo.sp_PLN_StyleDemandRanking;1'.  I believe this is a result of my initial error but I included it anyway.

The conversion error I mentioned above also happens when I try to set a new data source location so that is not an option either.

Now that I have run into this problem all over again with another RPT that will take an incredibly long time to recreate, and this issue has cost us a lot of time and money, I need a solution.  

[Former Member · Accepted solution]

I think it's becoming more clear to me why my question can't be answered.  My stored procedure is not the issue because as I initially said, the report has been working.  If the stored procedure was the problem, the report never would have worked.  The two additional parameters we added were reviewed extensively and do not affect any data and are not relevant to the problem since I can't even get the parameter window to verify the database before seeing the error.

I was able to fix the problem with the report.  I was able to pull the report into CR2011, with many issues.  I HAD to set a new data source in order for this to work and then verify database, again, we ran into a lot of strange behavior from crystal.  Since our business does not yet operate with a version of crystal later than 2008, I had to again pull the RPT into CR2008 to make sure we could manipulate it if a support issue came up.

When all is said and done I had to report the cause of our issue to management.  Our VP said in order to remove problems you have to remove the source of those problems.  I don't think we will be using crystal reports any longer.