Crystal Reports from Excel??

AJW · Mar 24th 2004

WillR + Others,

Has anyone ever used the CRViewer9 control to generate reports from Excel?

I've seen Crystal Reports out put from another application and was fairly impressed. Wondered if it could be done in Excel?

Have placed a control on a user form but have no idea what to do next?

Any Ideas / Help would be great.

Thanks

AJW

XL-Dennis · Mar 24th 2004

AJW,

In my limit experience with CR I believe You first must save the Excel-file to a CSV-file.

Kind regards,
Dennis

Will Riley · Mar 24th 2004

AJW,

I do not think you can create crystal reports from data stored in Excel using just the viewer control.

You need the full version of Crystal Reports. When version 7 onwards gets installed, an add-in is installed at the same time (for both Excel & Access) which enables you to create Crystal Reports from either application. The option should be added to the Tools menu in Excel (called Crystal report Wizard).

If it's not there & you have Crystal Installed, the default directory is
\\Program Files\Seagate Software\Report Designer Component\crexcel9.xla

Then you will be able to create your reports directly from Excel. It is worthnoting that crystal in effect creates a database(.mdb) file from the excel data. This file, the .xls file & the resulting crystal (.rpt) file cannot then be moved or the datalink will be broken & the crystal report cannot be refreshed...

Once you have created your report you can view it using the ActiveX Viewer if needs be, but I'm fairly sure you need the add-in or the report designer component installed to be able to create the actual report,

Hope this helps,

Will

AJW · Mar 25th 2004

WillR / XL-Dennis,

Thanks guys, appreciate the feedback. it gives me a bit more insight as to how Crystal works.