Step- by- Step on How to Load Excel data into Crystal Reports?

Advertisement

Hi Friends,
                  Can anyone send me a Step- by- Step on How to Load Excel data into Crystal Reports? Pls help me. Thanks in Advance.
Vijay

Advertisement

It's also important to 'prep' the excel file prior to connecting to it.
Give the data tab a meaningful name
Make sure the column headers are unique and that every column has a header
Delete any blank tabs
If you have trouble with Excel changing the data type of a field (say, a social security number you want to be a string value rather than a number so you don't lose leading zero) an alternative would be to save the spreadsheet file as a CSV, create a schema.ini to specify the data types for each column (example below) and use the same steps to connect except instead of choosing Excel 8.0, scroll to the bottom and choose Text.  You have to make sure the CSV file is in the same folder as the schema.ini file that defines the columns.
Schema.ini example:
200912PUSD.csv
ColNameHeader=True
Format=CSVDelimited
MaxScanRows=25
CharacterSet=OEM
Col1=SSN Char Width 9
Col2=LAST_NM Char Width 25
Col3=FIRST_NM Char Width 25
Col4=DOB Date
Col5=STDNT_ID Char Width 10
Col6=SORTKEY Char Width 10
Col7=SCHOOL_NM Char Width 30
Col8=OTHER_ID Integer
Col9=GRADE Char Width 2
The filename in the first line needs to have the []  brackets around it, but I couldn't get it to display in this forum correctly.
Edited by: Eric Petersen on Jan 27, 2010 9:40 AM

October 11, 2015

Step- by- Step on How to Load Excel data into Crystal Reports?

Hi Friends,                   Can anyone send me a Step- by- Step on How to Load Excel data into Crystal Reports? Pls help me. Thanks in Advance. VijayIt's also important to 'prep' the excel file prior to connecting to it. Give the data tab a meaning

How to load image data into cube?? Is it possible??

How to load image data into cube?? Is it possible?? Any sugession??Hi Andre, Document will be of ASCII characters right?? but image data will be in binary format. as per database concept it is stored as binary large object. But in datawarehousing the

How to load text data into internal table

I have a text file to load txt data into internal table. So how to read text data with validation and to load all text data into the internal table? Say this is the text file: IO_NAME, IO_TYPE, IO_SHTXT, IO_LONGTEXT, DATATYPE, DATA LENGTH ZIO_TEST1,

How to load excel-csv file into oracle database

Hi I wanted to load excel file with csv extension(named as trial.csv) into oracle database table(named as dept),I have given below my experiment here. I am getting the following error,how should I rectify this? For ID column I have defined as number(

How to Load the data from excel file(Extension is .CSV) into the temp.table

Hi How to Load the data from excel file(Extension is .CSV) into the temporary table of oracle in Forms11g. My Forms Version is - Forms [64 Bit] Version 11.1.2.0.0 (Production) Kindly Suggest the Solution. Regards, SachinHello Sachin, You can use the

How to write a procedure to load the data into a table using xml file as input to the procedure?

Hi, Iam new to the xml, can u please anyone help me how to write procedure to load the data into a table using xml as input parameter to a procedure and xml file is as shown below which is input to me. <?xml version="1.0"?> <DiseaseCode

How to import MS Excel data into an exisiting SharePoint List?

Hi Guys, Is it possible to import an excel list or excel data into a SharePoint List that has already been created? Not create a new list. I know you can import a spreadsheet which will create a new list, but I don't want that because I have created

How to load the data in DSO

Hello,          In my BI system ,i have the DSO and InfoCube ,haveing the infopackage Delta and Init..can any one tell me how to load the data from R/3 in to DSO ,when we have two infopackage(one is delta nad other is Init).Please define brifly.Hello

How to load transaction data

Hi, Can anyone share how to load transaction data from BI Cube to BPC Cube. How do i map key figures in BI to BPC in NW version. Pls share any document that explains. Thanks VeeruFor example, I've a BI Actual Cube with two key figures quantity and am

How to load text data in BI 7

How to load text data in BI 7Hi Mark. You can load text like you load the data to Master data attributes. The flat file format foe text  is like 'EN', 'MAT001', 'MATERIAL1'. Cheers SunilRead other 2 answers

Help needed in Loading excel data to staging table from OAF Page

Hi All, We have a requirement from the client on loading of a excel sheet data into staging table using OAF page. We were able to load a CSV file into staging table via OAF. The approach we used is we created a item of style 'messageFileUpload', whic

How to convert  PLD Report into Crystal Report

Hello Experts,                          I want to convert my  PLD Report into Crystal Report, but  i am not able to find the solution ,                          so how can i do this and what are the  steps have to taken. Kindly give me the solution .

To load master data into infoobject 0mat_unit

Hi Experts, Cud you pls give me any idea to load master data into infoject 0mat_unit from R/3. We need more than 10,000 master data into 0mat_unit. How can I collect data from R/3 for different attributes of infoobject 0mat_unit? I will assign full p

Load Multiple Images in Crystal Report using Paths

Hi Guys, I am currently in need of developing a new requirement for our company's client. We have to load multiple images using just link in Crystal Report. Let's say that the images are stored in a folder (e.g., C:\Datafolder\Images\) and i have to

Option to load XML data into BI 70

Hi All, I have read some postings on forums and also have read the "HOW TO load XML data in BW" guide. I am confused when I read the SAP online help documentation for loading XML data . Question : Out of the 3 options listed below which option i

Upload excel data into Internal table

Hi, I'm trying to upload excel data into internal table, well the excel file layout will be different on each run of the report. Excel file will have 60 columns and 500 record limit. I can upload the excel data using 'ALSM_EXCEL_TO_INTERNAL_TABLE' an

This is related to UCS-D : How to populate inventory data into lovs

This is related to UCS-D : How to populate inventory data into lovs I think you need to update the database from the applet. Then refresh the page to sync with values in the database. --Prasanna                                                        

How to write the data into EEPROM using Labview?

How to write the data into EEPROM using Labview?You would need some sort of EEPROM programmer. Typically might communicate with it via serial. I don't know how you would do this in LV. You would need to have the command protocol for the programming d

How to load the data from flat file ( ex excel ) to Planning area directly

Hi all , How can i load thedata fro m flat file directly to Planning area . PLease help me in this. Regards, Chandu .download one key figure data from planning book ( interactive damand plan) and made some changes and need to upload the data back to

How to load .dmp file into oracle 11gR2 data base schema ?

hello experts, i have a .dmp file and i wnat to use the data in this file for my further practices. so, i need to dump the data in the .dmp file to the any schema exiists in data base. Please give me step by step procedure to execute my requirement..