Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
salmonraju
Yak Posting Veteran
54 Posts |
 Posted - 2006-11-26 : 05:24:10
|
| hi, my project Database is in SQL SERVER . i don't know how to connect database to crystalreport. i knew how to connect MS Access.plz suggest me how to connect sql server database to crystal reports. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-26 : 06:04:08
|
| www.connectionstrings.comPeter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-26 : 07:26:02
|
| Which version of Crystal Reports you are using?See if following steps can help you:1. Start Crystal Reports2. Select the As a Blank Report option, and then click the OK button. 3. The Database Expert dialog box appears. In the Available Data Sources pane, click the plus sign to the left of the Create New Connection folder to expand it.4. Double-click the database type that you want (in this case SQL Server)5. Select the database name.6. Expand the Tables node, and then double-click the table on which you want to base your report.7. Select desired number of tables8. Click the OK button to close Database Expert.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-26 : 19:56:29
|
quote:
Originally posted by harsh_athalye
Which version of Crystal Reports you are using?See if following steps can help you:1. Start Crystal Reports2. Select the As a Blank Report option, and then click the OK button. 3. The Database Expert dialog box appears. In the Available Data Sources pane, click the plus sign to the left of the Create New Connection folder to expand it.4. Double-click the database type that you want (in this case SQL Server)5. Select the database name.6. Expand the Tables node, and then double-click the table on which you want to base your report.7. Select desired number of tables8 Make sure the tables are properly related9. Select only required columns10. Click the OK button to close Database Expert.Harsh AthalyeIndia."Nothing is Impossible"
MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
how to connect sqlserver DB to crystal report