Solved

Crystal Reports Server 2016 Installation, setup and use

Posted on 2016-11-30
5
962 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 101

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 101

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
In previous parts of this Nano Server deployment series, we learned how to create, deploy and configure Nano Server as a Hyper-V host. In this part, we will look for a clustering option. We will create a Hyper-V cluster of 3 Nano Server host nodes w…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

726 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