Topic: getting started Posted: 07 Apr 2008 at 6:57am
Hello guys,
I am new to crystal reports so never used it, I am trying to get started, what im trying to do is connect to a excel. I have excel 2007 and crystal reports version 7. I have created an ODBC data source for excel, what is the next step i have to do? Do i have to send data to access and create a database. i have been trying things out for ages can someone please help me!!
Joined: 12 Nov 2007
Location: United States
Online Status: Offline
Posts: 93
Posted: 07 Apr 2008 at 9:38am
I have not used version 7.0 but you might have the same options.
If you are not using ODBC Datasource,
After you launch crystal reports, you will be prompted to enter the database info.
So select the new connection. Select Database fiels or Access/Excel (DAO). Both options work. Then choose your file. Then you just have to drag and drop fileld from your excel file to the report.
I have not created a report out of excel using ODBC. Someone with the expertise might provide you a solution.
thanks for your infomation, i have entered the Active data (DAO), then selected excel and file name and clicked next. Im am then stuck as i am prompted for a user anme and password??
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
