Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR 9 Report to company intranet

Status
Not open for further replies.

confuseddddd

Programmer
May 22, 2003
53
US
Hello,
I am new to using Crystal Reports but was able to create a report using CR 9, basic version. The report is generated weekly and the users do not run the report, they just need to see the output. Now a request has come along that the report is to be put to the company's intranet for the users to look at the report in their leisure, (based on user list being updated quite often, its very cumbersome to constantly be changing the email user list) Currently we were sending the report results in an email.

Can anyone provide any feedback on the best way to accomplish the report to the company intranet??? I do not know .net but if that's an option, I would like to know that also.

Thanks....
 
The main question is do you want to run the report and put the OUTPUT on the net, or do you want the users to RUN the report themselves on the net.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
A bit more info on the intention would be great.

The report sounds like it is static in nature and thus my take on how you have described this would be to simply run the report and export the report in say PDF format and post this PDF file on the Intranet for the user base to go to. I suspect that Acrobat Reader is common place internally and would suffice as a viewer if no refreshing or updating of the report is required.

You could even export the report in PDF format directly into the folder on the server (provided the proper rights).




Cheers,

SurfingGecko
Home of Crystal Ease
 
We are going to use one of the 3rd party tools to auto schedule the report to run on a scheduled basis, the users only need to see the output and not run the report.

If go to the PDF route, using Acrobat Reader, (which I already have run the report this way) to post on the Intranet for the user base to go to, how does the report get to the intranet then...by using a folder on the server???

Excuse the elementary questions but putting things into an intranet page, is something new for me also.

Thanks for your input...
 
If you already have the PDF, and you just want people to download it from a web page, you really aren't asking a Crystal Question, since the technique is the same for any PDF or any other file.

You put the PDF in a public folder on your web site, and then create a page that hyperlinks to it. I am sure your web site admin knows how to do this.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
One last note. If you get the scheduler to post directly to the web site with no human intervention, and more than 50 people can see it, you are probably required to get a broadcast license from Crystal. That used to cost $100,000 but I hear that they have just announced a change to the licensing seems to give away a Broadcaset License with every purchase of the $2,000 Advanced Edition of V9.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
Yes. Essentially, you would have a folder that resides somewhere (more than likely on the server) that will house this file.

On whatever web page you have the users hitting, simply add a link or something for this report, that is hyperlinked ot the PDF file. When a user clicks it the pdf should open in AR.

With the scheduler, you should be able to sechedule the report in PDF format and set the destination to the desired folder.

That should be all there is to it.





Cheers,

SurfingGecko
Home of Crystal Ease
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top