Re: Excel to Crystal Report
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?
Re: Excel to Crystal Report
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
Re: Excel to Crystal Report
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.
Re: Excel to Crystal Report
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. :D
Re: Excel to Crystal Report
Quote:
Originally Posted by 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.
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