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.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.