Running reports from Web Crystal Enterprise

[vasu2005]

Hello all,

I have designed one report (CR 10) which is using
1. A command object of crystal accessing data from MS Access database connecting using ODBC (created a data source on local machine using ODBC driver )
2. A stored procedure accessing data from MS SQL 2000 connecting using OLE DB.

The report works perfect in crystal development environment. But It can't run on Crystal Enterprise.

Can anyone tell me the reason and how could I make it run on web enterprise so that the users can run it.

Any reply would be greatly appreciated

Thanks,

V

 

[MJRBIM]

Have you created the same ODBC connections on the CE machines that have Page and ReportJob servers installed?

If you had to map a network-drive to the MS-ACCESS DB, did you map it using the same account that the Page and ReportJob services run under?

Is anyone else accessing the MS-ACCESS DB when you are trying to execute the reports for CE? If so, the ACCESS DB may be unavailable at run-time.

 

[Turkbear]

Hi,
Not without much more information:
1:What error do you get when trying to run the published version?

2: Do the CE servers have sufficient rights to access the 2 data sources?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[midearth]

One other thing that might be worth checking is the ODBC datasource. If you developed the reports using a datasource configured in the UserDSN i/o the SystemDSN on your local PC and published to CE; they might not work.