Solved

Crystal Reports Server 2016 Installation, setup and use

Posted on 2016-11-30
5
180 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

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.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

777 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