I have made a report using cr 8.5 to display the information in an MS Access qry. Its index is text field, goes like 001,002,003 and soon and i have used the charactor "'" single quote to have it in the query('0001' '0002' and so)
the problem is when i open the report it shows some random numbers that changes every time i refresh the data, but the actual data didnt.this occurs only in the index field and other fields are fine.
I do not understand why you are getting random numbers or where they are coming from.
If you create a new Crystal Report using the Wizard and with no formulae or parameters or formatting or anything and no linking to anything other than your one query, and then just display the index field and a couple of other fields that are obvious to you (or maybe all fields?) - I wonder if this will bring back what you expect? If you choose ALL fields then it can be unreadable because the columns are too narrow - I use Export to Excel to be able to look at such results in more detail.
It is hard without more information to understand your problem - it sounds unexpected and very odd and I currently have no theory as to why, unless you have mistakenly picked the wrong field from your query.