Solved

Crystal Reports Server 2016 Installation, setup and use

Posted on 2016-11-30
5
71 Views
Last Modified: 2016-12-09
Let me start by stating that I have never used Crystal Reports in the past.  I was recently asked to purchase and install Crystal Reports 2016 Server so that we can connect to a SQL database that houses some data we want to report on.  I have downloaded and installed Crystal Reports Server 2016 and created a couple users. I can successfully log into the CMC and the BI Launch Pad but I am struggling with what is next. The SAP help files are not great or I am just not finding the right one.

Do I install Crystal Reports 2016 just on the client machine so that the client can create reports and upload the reports to the CR Server or do I also need to install Crystal Reports 2016 client on the the same server as the Crystal Reports server? If I install CR on the client only, create the ODBC connection on the client machine to the database housing the data, develop the reports and then upload the report to the server, how does the report that was uploaded onto the server connect to the database housing the data to report new data?  Do I just duplicate the ODBC connection the CR 2016 Server as well?

As you can see I am lost.  Any help, direction to help files, videos would be appreciated.

Thanks!
0
Comment
Question by:preshomes
  • 3
  • 2
5 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 41908905
Crystal Reports 2016 is a client application.  It gets installed on the client's machine.

Create system ODBC connections on the server for the database.
Create the same connections on the client machine.

When a report is uploaded you will have to go in the CMC and set the database connection for the report.  As long as the ODBC is named the same, Crystal will find it.  You will have to enter the user name and password for the connection in the CMC.

mlmcc
0
 
LVL 1

Author Comment

by:preshomes
ID: 41908920
Thank you mlmcc...thats great info!  One last question...  you stated  "You will have to enter the user name and password for the connection in the CMC."  

What user name and password are you talking about here.  Is this different than the user and pwd of the ODBC connection setup with the OS?
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 500 total points
ID: 41909065
The login you need to add will be the database login.  Again most of my clients setup a separate database login for use when the reports run through the server.  You can use the same login you created the ODBC with.

Crystal doesn't save the user/password for security reasons.

mlmcc
0
 
LVL 1

Author Comment

by:preshomes
ID: 41909080
Thank you very helpful.  Excellent, I will just use the same user and pwd as it's a read only user.
0
 
LVL 1

Author Closing Comment

by:preshomes
ID: 41909082
Thank you for your help!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now