Crystal Reports How to connect sql server to crystal reports 9

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: How to connect sql server to crystal reports 9

Author	Message
Anup Newbie Joined: 22 Aug 2007 Location: United States Online Status: Offline Posts: 1	Topic: How to connect sql server to crystal reports 9 Posted: 22 Aug 2007 at 6:29am
	Hi, i'm new user of crystal report. i want to know that how to connect crystal report9.0 to Sql SERVER using DSN . Pls let me know the steps... i'm trying to get rid of this probs sine last 2 days but not succeded. i hope you will help me............... waiting for quick reply....
	IP Logged

jkwrpc Senior Member Joined: 19 Jun 2007 Location: United States Online Status: Offline Posts: 432	Posted: 22 Aug 2007 at 9:25am
	I use CR XI. In it you can use the Database Expert to create a new connection for the report. Just follow the wizard steps to use ODBC and then pick the DSN name for the connection to SQL Server. This assumes that you have created the ODBC connection first. That is done in Windows under Control Panel->Computer Management->ODBC Connections. I would guess that CR 9 has a similar functionality if not being identical. Hope this is of some help. Regards, John W. www.CustomReportWriters.net
	IP Logged

rsoby Newbie Joined: 23 Aug 2007 Location: United States Online Status: Offline Posts: 11	Posted: 23 Aug 2007 at 1:28pm
	This assumes you have built the Connection. If you have not done that yet (ie you do not see your Database in the list from above) Goto the Windows Admin tool Data Sources and either set it up as a user DSn or a system DSN You'll need the system name, a logon and PW
	rich_soby@yahoo.com
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

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

This page was generated in 0.016 seconds.