Same report different result using Crystal Reports & BO Enterprise

[porsche2k7]

Hi All,

I have scheduled a crystal report to generate counts on BO Enterprise. The scheduled report results in less number of counts than the report from crystal reports designer. I am using the same report to schedule using BO enterprise. Is it possible that BO enterprise can time out the report.

Thanks

 

[synapsevampire]

Timing out would result in an error.

More likely you're connecting to the wrong database/table.

-k

 

[IdoMillet]

What data source and connection method?

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[porsche2k7]

I am using oracle database and oracle driver to connect.

 

[IdoMillet]

Perhaps this is related to the option of replacing Null values with default values. Is the number of records the same?

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[porsche2k7]

Do you mean the number of records from crystal reports designer and enterprise. If so its not the same. Its not extracting the same number of records.

 

[IdoMillet]

Show record selection formula and SQL statement.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[porsche2k7]

SELECT
COUNT(*)
DCA,
DCB
FROM
TABLE_NAME WHERE RECORD_ID = 'AC' AND TO_CHAR(DATE_OF_SERVICE,'YYYY') = '2006'
GROUP BY DCA, DCB

 

[MJRBIM]

What happens if you run the RPT locally from Crystal Reports installed on the BOE server(s)...?

 

[porsche2k7]

Locally i have about 1.5 million as the count. While on the server i have about 32,000 as the count.

 

[Turkbear]

Hi,
Please show the actual count output:

DCA ###
DCB ###

for each version...

Are you using the same database credentials for the BOE version as your local one?

Is this a Table or View?

Owned by the same Schema?





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