Not getting data when report is run from BOE sched
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15506
Printed Date: 21 Apr 2025 at 8:05pm
Topic: Not getting data when report is run from BOE sched
Posted By: dbodell
Subject: Not getting data when report is run from BOE sched
Date Posted: 01 Feb 2012 at 3:20am
I have a set of reports that are set up on a schedule to run from BOE. However, although I have the parameters set properly and the database connection is fine, and the reports run successfully, they don't have any data in them. When I export to an rpt from BOE and then open the report in Crystal and run it, using the same parameters, I get data. What am I doing wrong? All my other reports run just fine off of BOE. One of the differences is that I have a subreport in these reports.
-------------
Thanks,
D. Bodell
|
Replies:
Posted By: sgtjim
Date Posted: 01 Feb 2012 at 5:14am
Make sure that the sub-reports are connected to the correct data source.
One time I was developing a report with a sub-report. I was developing on the test server. Then I moved the report to production, but forgot to change the data source on the sub-report and the same thing happened to me.
Also, double check the Database Configuration in the CMS,
most of the time I use;
"Use custom database logon information specified here".
But sometimes and I don't know the reason I have to use;
"Use original database logon information from the report".
Also make sure that
"Use same database logon as when report is run" is checked under "When viewing report:"
I hope this helps.
|
|