Post Author: Shalee
CA Forum: Data Connectivity and SQL
Hi,
I need to build some reports using Crystal Report version 10.0 developper full version and Sql Server 2005. Could anyone please help me with the following:
1. how to do the database connection with CR10 and sql server 2005? Which type of connection is best use, ODBC or OLEDB?
2. Is it possible to export to multiple text file from a single .rpt file? For instance, I have a report that should generate four text file. If this is not possible then I will have to create four .rpt. Is there other solution for it?
3. Is it possible to export your crystal report data to a single excel file with multiple tabs and each tab named as per the subreport name? For example, I have report name as REPORT.rpt. This report when exported should create an excel file with 8 tabs, each having a different name.
I hope someone can help me with this.
I urgently need some help on this. Thanks in advance.