reports on the web
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1722
Printed Date: 06 Apr 2025 at 7:34pm
Topic: reports on the web
Posted By: stevbren
Subject: reports on the web
Date Posted: 20 Nov 2007 at 9:14am
|
I am new to crystal reports. I am very impressed at what i have seen this do thus far. My boss has asked me if reports can be written so that can be accessed over the internet, and / or editeed over the internet.
Idea, if we want to publish all jobs ready to invoice by sales person and leave a space for them to type in the amount they want to sell the job for with the quote, material cost and labor already filled in, and give a warning if they attempt to sell for less than twice the materials. I have the report written, just not sure how to proceed or if it can be done. |
Replies:
Posted By: BrianBischof
Date Posted: 20 Nov 2007 at 11:29am
|
This is a bit tricky. Yes, you deploy reports over the web, but you really need to use VB.NET or C# application to do so seamlessly. The other way is to export to HTML and deploy the HTML file on your web server. The problem is that CR has no way to let you do data entry within a report. It's is output only. One way to do what you want is to use parameters./ This is where the user is asked to enter their info (amount, material cost, etc.) and then you can display that on the report. This is a very easy task to do and will most likely meet your needs. (I cover everything related to creating and using parameters in Chapter 4 of my CR Encyclopedia book) ------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |
Posted By: stevbren
Date Posted: 21 Nov 2007 at 8:17am
|
Brian,
I have your book and it has been very helpful. I would encourage anyone using this to buy it.
That said, I am not very literate in what is needed to connect to the web.
I am not understanding the parameter part. How would a salesperson not in the building have access to the report to enter their information?
Wouldn't that require the web?
------------- |
Posted By: BrianBischof
Date Posted: 21 Nov 2007 at 10:23am
|
Hi Steve, Yes, for remote access you need to use the web. If you do the export to HTML, then a limitation is that you won't be able to use parameters (HTML is static content). This requires writing an application in Java or ASP.NET. Another option is to install the new and free CR XI Viewer application that BOBJ has released on their website. I haven't used it much and I forget what functionality it has, but if installing it on the remote computers is possible, then they should be able to open reports and enter parameters with needing the web. And I'm glad you like the book! If more people supported the forum with a book purchase, then I could spend more time creating content for the site.  ------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |
Posted By: stevbren
Date Posted: 23 Nov 2007 at 2:03am
|
Thanks Brian. I am going to try the viewer.
------------- |