New data, same source, same formulae in CR - no effect

[dscheste]

Hello,

I have created a report, which involves a great deal of time calculations and is using a lot of different formulae, quering the database.

The report seems to work just fine.

Now I have to run the report on the renewed data.

I have just pasted the values into the old excel file I was using as database for Crystal.

Everything is absolutely the same, - formatiing, fields, everything.

I open Crystal and just refresh the database.....


And here this happens, Crystal tells me that the some fields are not matched et cetera. A sresult I lose everything.

How is it possible to relink the Crystal with al the formulae to a new excel file I am using, where the fields are the same, just the values are new.

Thank you in advace

Source file - 1 sheet in excel saved as Excel 5.
Crystal 9.

Thank you


dscheste

 

[IdoMillet]

Use the menu option of
Database, Verify Database...

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dscheste]

Database, Verify Database...

This is what I have been using.

Cryustal just wants to re-map the field. Why?

P.S. The column in the old file contained 1 record, in the updated version the column is empty, but I still need it.

 

[IdoMillet]

Please clarify. Did you change the structure of the columns included in the excel range? If so, the Verify Database process allows Crystal to recognize the new column names, data types, etc.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dscheste]

No, I did not modify anything.

Just changed the values, this is it.

No additional comumns.

Couple of additional rows, which I re-defined then as the name in excel I was using last time.

 

[IdoMillet]

Did you redefine just those added rows as the range name? You should redefine the whole range.

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com