problem in scheduling report

[bubu2006]

I am using CR10 & CE10 & Oracle 10g. I have one report which has 16 subreport. It's running fine when I am using CR10 but as soon as I am trying to schedule this into CE10 it's failing. Though I can preview them.
Do you have any clue?

Thanks,
bubu

 

[kskid]

Did you verify the database?

Click on Database -> Verify Database.

-lw

 

[groggle]

What error does it fail with?

 

[bubu2006]

why do I have to do "verify database"? I can preview the report no issue with that.

 

[bubu2006]

Failed to open the connection. I am getting this message.

 

[kskid]

I have BO XI so it might be a little different than what I recommend

Click on the Process tab and then Database. Fill in the password and scroll to the bottom and check on "Use same database logon as when report is run" and click update

 

[bubu2006]

I can preview the report that means dabase connection is fine.

 

[kskid]

Hmmmm.... I have run into situations where I incorporated a new report but did not have the same ODBC connection on the CE machine as on my PC. Might want to check the TNSNAMES.ora

 

[bubu2006]

I guess you don't understand my problem. I have one report which is running fine in Crystal report. Now I have saved that into enterprise and setup all parameters. Now I preview the report and I can see data. Now I want to schedule the report into enterprise and its failing. So the report is running in CE10. I guess you understand that we have no issue with ODBC or any connection related thing. Else I could not able to preview the report.

 

[groggle]

Failed to open the connection indicates a database logon problem.

When you schedule a report to run, check that the database tab does indeed have a password entered into it.(under the Process tab) Does each subreport use the same database connection?

When you Preview a report in CE10, the Page Server is processing the report. When you preview the report, can you page through each page of the report successfully until you reach the last page?

When you schedule the report, it is the Job Server that processes the report.

Ensure that these two services are running and that they are using the same Windows service account.

 

[MJRBIM]

When you schedule the report it is using the "ReportJob Server" - you need to ensure that service is running under an account that can access you DB and ODBC connections.