Skip to Content
Former Member
Jun 30, 2007 at 02:18 AM

Crystal Xcelsius and Live Office - Data update sequence


I am new to Xcelsius and Live Office (I am running the Professional version of Crystal Vision) and am trying to determine the sequence of how things work. We currently have our accounting information in an SQL database. This is the database that the majority of the Crystal Reports we have are generated from; this is also the data I see using Xcelsius to report from. As I it the process is to create a Crystal Report from the SQL data; use Crystal Live Office within Excel to create a new report view based off the Crystal Report and then use Xcelsius to access the information from the Excel spreadsheet.

My question is, when the data changes in the SQL database will the Xcelsius information be updated accordingly by running the "Import Model" option again or do you have to go into the Excel spreadsheet and refresh the data there prior to reimporting the spreadsheet in Xcelsius?

Thanks for the help.