Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Changed field types breaking reports? (CR8.5 / VB6)

Changed field types breaking reports? (CR8.5 / VB6)

Changed field types breaking reports? (CR8.5 / VB6)

I have a VB6 application that runs multiple CR8.5 reports connecting to SQL Server.

The SQL DBA recently changed several key fields in the database from "datetime" to "smalldatetime", and now about half of my users are unable to run any reports that use those fields. (The other half appear to be completely unaffected.) Users are getting a generic "707" error and the report fails to open. If the user opens the same report directly in CR8.5, though, it runs fine.

The Crystal versions are the same between a "good" and "bad" machines, and I'm stumped on where else to look for an explanation for why only some users are affected (and thus, stumped in getting them fixed.)

Any suggestions on places to look would be most appreciated.

RE: Changed field types breaking reports? (CR8.5 / VB6)

When field types change, the database needs to be verified in the report in order to pick up the changes.  If this is not done, then Crystal will throw an error.  In the Report Options, you can turn on "Verify on Refresh" for a given report so that it verifies every time it runs.  You can also set this as a default in the Crystal application options so that new reports automatically have it set.

Are the users on the "good" machines running the same reports as those on the "bad" machine?  Do some of them have the full version of Crystal installed or are they all just the runtime?  

How do your users log into the database for the reports?  Are they all using the same user ID or does each user log in with their own ID to run reports?  If they run reports under their own ID's, the user may or may not have rights to get the schema info to validate the database in the report.


A computer only does what you actually told it to do - not what you thought you told it to do.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close