Publishing Reports to the Web Server 
Author Message
 Publishing Reports to the Web Server

Hello

1. I have created a report that connects to an Access Database
2. I have "converted to UNC" the path to the database.
3. I have saved the report to my web publishing directory.
4. I have "shared" the directory on my PC (NT4) where the Access database
is.

But, when i try to access the report thru my web browser - the report starts
to generate and then comes up with an error "creating data source failed"

anyone see what i am doing wrong ?

Dan



Sat, 14 Oct 2000 03:00:00 GMT  
 Publishing Reports to the Web Server

Trevor,

We have been using Crystal 6.0 Professional since Oct '97 and have been
distributing our reports to our user community via the web. Our software
configuration is : WinNT 4.0, IIS 3.0, MS-SQL Server 6.5.  

Running Crystal Reports via IIS, Crystal Web Server works fine for
"primary" data sources (tables, views).  However, if you want to run a
report which uses "secondary" data sources (query, sub-reports) you will
need to use Active Server Pages and the Crystal Reports Automation
Server.  The Seagate support staff have some excellent examples of using
ASP and the Crystal Automation Server.

One word of caution, if you are using the Automation server without a
VBScript or javascript frontend you would be wise to remove all prompts
from your report.

The "CREATING DATA SOURCE ERROR" typically results under any of the
following circumstances:
1. using Crystal Web Server to run a "secondary" data source report
(query, sub-reports),
2. the crystal web server (crpgsvr.exe) is hung,
3. the web server (inetinfo.exe) is hung.

If your error results from crpgsvr.exe or inetinfo.exe you will have to
shut them down.  You will probably be unsuccessful in your attempts to
"End Task" the crpgsvr.exe and your attempts to stop the WWW service
will sometimes fail.  Look around the web for a neat utility called
KILL.EXE which is the WinNT equivalent to the UNIX "kill -9" command;
this will permit you to kill both inetinfo.exe and crpgsvr.exe then
restart them.  With the WWW service stopped, find the crpgsvr.exe file,
double click it to re-activate the crystal web server, then re-start the
WWW service.  

Hope this helps.

Cheers,
        ... Chris.

Quote:

> Hello

> 1. I have created a report that connects to an Access Database
> 2. I have "converted to UNC" the path to the database.
> 3. I have saved the report to my web publishing directory.
> 4. I have "shared" the directory on my PC (NT4) where the Access database
> is.

> But, when i try to access the report thru my web browser - the report starts
> to generate and then comes up with an error "creating data source failed"

> anyone see what i am doing wrong ?

> Dan



Sat, 14 Oct 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Web Publishing API : WpPost Sending files on a server

2. Publishing report to web problems

3. Web publishing of Crystal Report

4. Running Crystal Report Web Component Server and SQL Server on different machines

5. Crystal Web Reports Server 7 string parameters arent being passed to SQL Server StoredProc

6. server time reported on .asp web pages, how do I report client side time correctly

7. Crystal report 6, Web Report Server, inetInfo (IIS) 100% CPU-usage problem

8. script for changing server publishing rules on ISA Server

9. Publish to the web

10. Access to web publishing

11. Automating Publish to the Web Wizard

12. Publish Calender to web

 

 
Powered by phpBB® Forum Software