Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data from query corrupt

Status
Not open for further replies.

suecobb

Programmer
Sep 18, 2001
32
0
0
US
I have a report in Crystal 8.0, based on a query. At seemingly random intervals, the report comes up with "odd" data. The 1st 4 characters of most of the string data fields are truncated and the numeric fields are many times their actual value. It doesn't happen every time I run the report. I am not saving the data with the query or with the report. When I go into the query the data looks fine. The report seems to consistently run fine just after I have viewed the query. However, the end users will not have access to Crystal SQL Designer. Any suggestions?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top