Joined: 08 Nov 2011
Location: United States
Online Status: Offline
Posts: 53
Topic: Not getting data when report is run from BOE sched 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.
Joined: 23 Aug 2011
Online Status: Offline
Posts: 32
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:"
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
