Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: reports on the web Post Reply Post New Topic
Author Message
stevbren
Newbie
Newbie
Avatar

Joined: 20 Nov 2007
Online Status: Offline
Posts: 33
Quote stevbren Replybullet Topic: reports on the web
    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.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
stevbren
Newbie
Newbie
Avatar

Joined: 20 Nov 2007
Online Status: Offline
Posts: 33
Quote stevbren Replybullet 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?
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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. 


Edited by BrianBischof - 21 Nov 2007 at 10:23am
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>
IP IP Logged
stevbren
Newbie
Newbie
Avatar

Joined: 20 Nov 2007
Online Status: Offline
Posts: 33
Quote stevbren Replybullet Posted: 23 Nov 2007 at 2:03am
Thanks Brian. I am going to try the viewer.
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.