basic help on using crystal reports

[Former Member]

I successfully downloaded and installed Crystal Reports trial.

I want to write a report for a SQL database. Since I cannot do this on my production machine at work, I thought I would bring the database home to my win10 pro machine here to experiment.

I successfully installed SQL server on a win10 PRO box at home.
I connected to a SQL server instance on my home machine.
I can create a database and work on it as described here:
https://docs.microsoft.com/en-us/sql/ssms/quickstarts/ssms-connect-query-sql-server?view=sql-server-...

However, I want to investigate an already created database from the machine at my office.
I want to be able to create custom reports from that data.
This other database is from an application that creates and manages a schedule and runs a SQL server.
It runs on a winPro box as well.

I have copied the DATA folder from that other machine running SQL server to the desktop of my home machine.

I need to create an ODBC data source using this data but my SQL server at home is running an empty database.

How do I connect the office database to the new SQL server I have at home?

[moshenaveh]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.
Should you wish, you can revise your question by selecting Actions, then Edit.
Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

[DellSC]

Also, I don't think you can just copy the files for SQL Server - you need to do a backup from the server in your office, copy the backup files, and then restore to the SQL Server instance at home.

-Dell

[Former Member]

yeah, i figured that out. thank you.

[former_member11696]

That's a question for your IT department.

Ask Microsoft how to make the connection.

CR just assumes your Client is configured and working.

Try Googling this question...

And use the MS SQL Native 11 Client, it works the best. It's from SQL 2012 and available for download from MS.