[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal Reports Server 2016 Installation, setup and use

Posted on 2016-11-30
5
Medium Priority
?
2,408 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 101

Accepted Solution

by:
mlmcc earned 2000 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 101

Assisted Solution

by:mlmcc
mlmcc earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

872 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