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.
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.
Sure i will help you out with this for Creating Crystal Report from Excel file you need to follow the below steps:-
- Create a new Report.
- When you are selecting Datasource over here choose Access/Excel
- Now choose Database type as Excel
- Then select the name of the Excel file
- Afterwards follow the normally procedure which you used to follow early.
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.
Try to use the following code i am sure it will work for you.
Code: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
Bookmarks