How to run a crystal report from a website?

Posted on 2015-01-29
Medium Priority
Last Modified: 2015-02-03
I have a crystal report that I like to add to a web site, can I run the report by creating a link on the website?  or what is the best practice here?
The website in a internal web site and the database reside on the web server that would run the crystal report.  The crystal report uses a MYSQL database.
Question by:Scott Johnston
  • 2
  • 2
LVL 101

Assisted Solution

mlmcc earned 2000 total points
ID: 40578050
Is this an internal only website?
I ask because an externally available website creates licensing issues.

If so, what version of Crystal is it?

Do you have Visual Studio 20xx available?
If so you can create an ASP.Net application that can be run from the website.


Assisted Solution

by:Scott Johnston
Scott Johnston earned 0 total points
ID: 40578248
Intranet, internal website.  We do not have Visual Studio.
I guess I could create a PHP script to access the MYSQL data and then send the data to our Intranet?
Crystral version is 11.5.8
I also have Crystal 2011
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 40578317
How about using a 3rd-party viewer application
Here is a link to a list of Crystal viewers

LVL 23

Expert Comment

by:Ido Millet
ID: 40579768
If you don't need ad-hoc interaction with the user (e.g. parameter values), you can use a 3rd-party scheduler (see list at http://kenhamady.com/bookmarks.html ) to export to HTML and refresh the content of a web page.  
At least one of these tools has special features for turning Crystal reports into auto-refreshing web dashboards.

Here is an example of one such web dashboard: http://academicweb.psu-erie.bd.psu.edu/laboccupancy/Labuse.html
Note that the content will auto-refresh in your browser every few minutes without needing to hit refresh.

Author Closing Comment

by:Scott Johnston
ID: 40585828
The suggested solution cost more money that I need to spend.  Thank you.
I ended up creating a form to lookup data using a PHP script.

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Strategic internal linking is often considered an SEO power technique, especially for content marketing. Do you need to hire an SEO agency to optimize you internal linking? No, this article will help you understand the basics of internal linking and…
This article is about the challenges faced by Android app developers.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses

624 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