Excel to Crystal Report

[shersu]

I wish to create a crystal report from an Excel workbook that contains many sheets. Each sheet contains data regarding a one project each. All sheets are of the same format in displaying data. How do I create a crystal report from this workbook, so that the data in the crystal report is displayed as treeview of which the project data itself can be expanded and minimised? Finally this has to be installed in the client's computer. Should I create an addin? You experts out there, please suggest and help me.

Thanks

[Hack]

Do you want an individual report for each sheet, or one report for the entire workbook?

Why not just use Excel itself as the report generator?

[shersu]

I wish to have one report for the entire workbook. But each sheet should be inside a node that can be expanded and minimized.
Thanks

[RobDog888]

Just create a DSN file connection to your Excel file. Use the Database > Set Location > Set Location > More Data Sources > Active Data > Active Data (ADO). Then create a DSN to your Excel workbook and specify the rows to select etc.

[RobDog888]

Additionally, if you want to have the users view this report in the CR Viewer control on a VB6 form, it will give you the tree nodes and other options including exporting back to an Excel file.

[shersu]

Just create a DSN file connection to your Excel file. Use the Database > Set Location > Set Location > More Data Sources > Active Data > Active Data (ADO). Then create a DSN to your Excel workbook and specify the rows to select etc.

How do I do this? Please help. Will the user be able to view the report in tree view? If not, I will go for the second option. Please help.

Thanks