Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 04-05-2009
Member
 
Join Date: Mar 2009
Posts: 89
Create Crystal Report from Excel

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.
Reply With Quote
  #2  
Old 04-05-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: Create Crystal Report from Excel

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.
Reply With Quote
  #3  
Old 04-05-2009
Member
 
Join Date: Dec 2007
Posts: 93
Re: Create Crystal Report from Excel

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.
Reply With Quote
  #4  
Old 04-05-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: Create Crystal Report from Excel

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
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Create Crystal Report from Excel"
Thread Thread Starter Forum Replies Last Post
How to create Weekly Sales Report in Excel spreadsheet Lanka Boy MS Office Support 1 08-01-2012 03:57 PM
Which is best, Data report or Crystal report? Smita.bendal Software Development 5 11-03-2010 02:42 AM
How to create reports using Crystal Report 10? Chandraa Windows Software 4 07-01-2010 08:14 PM
Crystal Report does not work in Windows 7 Filiberto Operating Systems 5 24-12-2009 03:03 AM
help needed for crystal report techfreakpeyx Software Development 3 10-12-2008 02:01 PM


All times are GMT +5.5. The time now is 02:36 AM.