davidgagne.net

For two days now I’ve been trying to get a report to run from my Visual Basic application. The report calls a stored procedure on the SQL Server from a Crystal Reports ocx in the app. I needed to pass two simple parameters through the ocx, from the app, to the storedproc so the report file that the ocx calls would have the right dates in its query. The Seagate Software Knowledge Base Article c2003724 finally showed me what I was doing incorrectly. Silly me! I wasn’t correctly formatting the milliseconds in the date! The milliseconds.
<mumble>milliseconds</grumble>