Custom hist. reports do no work with scheduler

[n.clark]

I have developed some custom reports using Crystal 8.5 and they work fine in the Cisco Historical reports viewer. But when I try to schedule the reports the export of the acrobat file fails.

The CiscoSch.log gives the following error:

JobInvokerThread::RunJob to Export\Print report gave an error.Pls check CiscoSchPrintExport.log for more details.

The CiscoSchPrintExport.log file gives the following error ("ICD_Queue_Statistics_Summary_Chart_en_US" is my report):

51 ERROR Jan 19 2005|13:01:29 1208: Exception while exporting report ICD_Queue_Statistics_Summary_Chart_en_US

52 ERROR Jan 19 2005|13:01:29 1208:LogComError: the error is = Code= 80047cb2, Code Meaning = IDispatch error #31410

53 ERROR Jan 19 2005|13:01:29 1208:Source=(null)

54 ERROR Jan 19 2005|13:01:29 1208:Description=(null)

Any ideas?

[sferland]

I'm currently trying to develop a custom report using Crystal 8.5. I'm totally lost !!!

If you don't mind, I have a few questions for you.

1- Did you start your new report from scratch or you started with an existing one ?

2- If you start from scratch, how did you manage to create the ADO connection ? I'm looking at a Cisco's report and the connection string is:Provider=MSDASQL.1;Data Source=gt;Extended Properties="DSN=gt;APP=Crystal Reports;WSID=GLORIA-CCM;DATABASE=GT;Trusted_Connection=Yes"

If I tried to insert this connection string into a new ADO connection against a brand new report, Crystal gives me an error.

3- For your new report, did you create a new Stored Procedures ?

4- If so, how to create an ADO table in order to use a temporary table in a Stored Proc.?

I'm really lost right now, I don't know where to start for my report.

Thanks in advance

[sferland]

Hey Nathan,

Did you solve this problem ?

Right now, I'm getting the same error as you.

36 ERROR Mar 21 2005|15:15:19 1604: Exception while exporting report ICD_Contact_Service_Queue_Activity_by_Hour_Table_fr_FR

37 ERROR Mar 21 2005|15:15:19 1604:LogComError: the error is = Code= 80047cb2, Code Meaning = IDispatch error #31410

38 ERROR Mar 21 2005|15:15:19 1604:Source=Crystal Reports ActiveX Designer

39 ERROR Mar 21 2005|15:15:19 1604:Description=Nom invalide.

[nlolive]

Hi,

We have a similar error message :

"14 ERROR Jul 19 2006|17:03:15 1444: Exception while exporting report ICD_Agent_Login_Logout_Activity_Chart_fr_FR

15 ERROR Jul 19 2006|17:03:15 1444:LogComError: the error is = Code= 80043ac2, Code Meaning = IDispatch error #14530

16 ERROR Jul 19 2006|17:03:15 1444:Source=Crystal Reports ActiveX Designer

17 ERROR Jul 19 2006|17:03:15 1444:Description=Dos error.

18 ERROR Jul 19 2006|17:03:15 1444: thread in Export method:Exception occurred for report I "

Did you solve this problem ?

Thanks for your help.

[chris-luzi]

Hi,

We have solved a part of our problem.

The CRS Historical Report Client must be installed to the target PC, because the CiscoHistRptrUsr user must be present.

But, how can we install it to a server ?

Thanks for your help.

[acorbett]

I need to do the same thing, get it installed on a server. Anyone know a way to get this done?