Problem In getting correct data from Access Table

[asimasm]

Hi
I have designed a report based on a MS.Access query. The query takes abut 15 to 20 sec to execute in Access bcz it gets some summaries from some other tables. Now the problem is that when i get my report based on this query displayed then the crystal report misses some rows randomly. I mean that on each refresh of data that i call from from Crystal Report there is a different data each time. I have placed a GrandTotal field in report footer and i get different result on each refresh. I don't know what's going on. I have also turned save data property off as well. but still it does not work.
Is this a Crystal Report Bug.

Plz reply.
Thanks In Advance

 

[kenhamady]

Posssibly a bug, but more likely it has to do with the query or the interaction between the query results and the report. If you create an MS Access report from this query, does it behave OK?

Give a brief description of what the query is doing, since that may affect it. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.