INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Missing Data in BOE 4.0

Missing Data in BOE 4.0

(OP)
I've got this really simple report that is grouped by customer code and, when run from crystal reports (locally on my machine) works perfectly and shows me 10 groups of data. If I save this report into Business Object Enterprise, add the database password and then schedule it to run straight away I only get 9 groups of data. I've check the 'Database Records Read' property on the Crystal Reports Processing Server and it is set to 0 (unlimited) and the connections to the datasources are the same for my machine and the business objects server.

I know the report is fine cause it works in crystal but I can't understand why 1 group of data is missing in BOE.

Any thoughts on where I might look for a solution would be greatly appreciated.

Thanks

Stuart.

RE: Missing Data in BOE 4.0

Which version of Crystal and which version of BO?

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

RE: Missing Data in BOE 4.0

(OP)
Hi
I've got CR 2011 and BO 4.0 SP5

RE: Missing Data in BOE 4.0

Is it connecting to the same physical database in both Crystal and in BO? What type of database and what type of connection (native, ODBC, OleDB) are you using?

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

RE: Missing Data in BOE 4.0

(OP)
They are both connecting to the same SQL database using an ODBC connection. I've checked the odbc connections on my machine which has crystal reports and on the business objects server and they are exactly the same.

RE: Missing Data in BOE 4.0

Are they using the same driver for SQL Server? They need to be using the SQL Server Native Client either version 10 or 11. The driver that is automatically installed with Windows Server doesn't always work correctly for this.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

RE: Missing Data in BOE 4.0

(OP)
Ahh. My machine has only got the SQL server driver where the business object server has the SQL Server Native Client 10.0. I'll update my machine's driver and see if that makes a difference.

RE: Missing Data in BOE 4.0

(OP)
Both my machine and the BO server have the same Native Client 10.0 odbc and I'm still getting less data from BO.banghead

RE: Missing Data in BOE 4.0

Are you using an OleDB connection or ODBC? If it's ODBC, try OleDB or if it's OleDB try ODBC.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close