Solved

Crystal Reports Server 2016 Installation, setup and use

Posted on 2016-11-30
5
7 Views
Last Modified: 2016-12-01
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you for your help!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

763 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

11 Experts available now in Live!

Get 1:1 Help Now