Create Crystal Report from Excel

[Harshini]

Hi friends,

I am have store many data in Excel workbook and now i want to create a crystal report from it.Over here every sheet contains data regarding a one project. All sheets are of the same format.Can anyone help me out with this issue.

[opaper]

Sure i will help you out with this for Creating Crystal Report from Excel file you need to follow the below steps:-

1. Create a new Report.
2. When you are selecting Datasource over here choose Access/Excel
3. Now choose Database type as Excel
4. Then select the name of the Excel file
5. Afterwards follow the normally procedure which you used to follow early.

[Ameya]

I am also facing similar type of issue but over here i am not able to convert my Crystal reports to Excel file.Can anyone solve this issue.

[Katty]

Try to use the following code i am sure it will work for you.

With mreport
.txtAmount.Left = .txtAmount.Left + 1000

With .ExportOptions

.UseReportNumberFormat = True

.FormatType = crEFTExcel80 'crEFTCommaSeparatedValues
.DestinationType = crEDTDiskFile
.ExcelAreaType = crDetail


End With
CDExport.InitDir = "C:"
CDExport.FileName = "C:\ReconciliationOfActualCostAndProfit" + Format(Date, "MMM") + Format(Date, "DD") + ".xls"
CDExport.ShowSave

.ExportOptions.DiskFileName = CDExport.FileName + ".xls" '"C:\ReconciliationOfActualCostAndProfit" + Format(Date, "MMM") + Format(Date, "DD") + ".xls"
.Export False


End With