Hi all, I am seeing an intermittent problem between a Visual Studio 2005 program pulling a report from CR 11, using a report I built in CR 11, and in the VS code using Report viewer. The query is as such:
SELECT * FROM BillingDetails, BillingReport, BillingTrunkDetails
WHERE BillingDetails.ReportID = {?REPORT_ID}
AND BillingReport.ReportID = {?REPORT_ID}
AND BillingTrunkDetails.ReportID = {?REPORT_ID}
Simple enough I think...
But on occasion the results give me an erroneous error:
Failed to retrieve from the database.
Details 22003: [Microsoft][ODBC SQL Server Driver][SQL Server] The conversion of Varchar '1234568' overflowed an int column. Maximum Interger value exceeded. [Vendor Database code: 248]
Now, I cannot recreate this problem unless I do the query in Crystal Reports and put the parameter in as an integer. The column themselves are all varchar in the tables. And changing the number in the table (report_id) seems to let it run okay. It is not consistent, it seems there is no particular number that it fails on. IS this a known bug? Will upgrading to studio 10 fix this? It really doesn't seem to be a Crystal report problem.