Excel and Crystal 8.5 and numbers not appearing in the report 1

[splshfn]

We are pulling data from Mercury TestDirector into Excel as I am no longer allowed an ODBC Connection straight into Test Director.

I have configured Crystal 8.5 to pull data from my excel spreadsheet, however, some of the fields the data is not pulling into the report.

They are numbers in Excel and when I browse the field in Crystal nothing is showing (but yet I see them in the Excel file) and Crystal shows the field as a string. I have created the formula tonumber({BUG.BG_USER_14}) and still no numbers return.

Any thoughts?

Debbie

 

[synapsevampire]

Age old nuisance with Excel and ALL other datasources, Excel incorrectly reports it's data types as it bases it on the first row.

Here's the old trick I used, insert a dummy row at the beginning of the spreadsheet and insert valid values into each cell. If Excel has the first row as blank, it will tell Crystal that it is a string. Then you can use a record selection to filter out that dummy row based on some unique value you placed in that row.

Also if you are updating an already linked in spreadsheet, amke sure that you issue a Database->Verify Database after the changes.

-k

 

[splshfn]

THANKS..that worked.

Now I just have to update the original database so that when I hand over the reports to the end users I don't have to worry about them having to update the Excel file.

Debbie