Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Excel tables are lost Post Reply Post New Topic
Author Message
carstowal
Groupie
Groupie


Joined: 31 Jul 2008
Online Status: Offline
Posts: 80
Quote carstowal Replybullet Topic: Excel tables are lost
    Posted: 12 Jan 2010 at 12:02pm
Apparently there was a bug in CR9 where if you used a table in Excel CR would forget where that table was.  When trying to Set Datasource Location, you can't "map" anything because the Fields in the Original Table are all gone, it's as if the table is blank.

Supposedly there was a CR9 "fix" but it only fixed future reports, not preexisting.

I just upgraded to 2008 hoping it would solve the problem.  Other than recreating all my reports, does anyone know of a way to re-assign the table and map the lost fields?


IP IP Logged
carstowal
Groupie
Groupie


Joined: 31 Jul 2008
Online Status: Offline
Posts: 80
Quote carstowal Replybullet Posted: 24 Feb 2011 at 6:01am
bump with new problems

I have a CR 2008 that has been working fine for a long time until today.
It seems to know where the Excel table is but there are no fields.  I've tried to Set Datasource Location and remap but there are no fields to map to.

The Excel file & it's sheets are not password protected, nor are the sheets hidden.  The tables do not contain any blank rows to disrupt the table.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.