Missing Records in CR8.5 Report

[Jazz1963]

Help!

Have a report where I want to pull data from SQL2000 DB into a simple CR. I can get my SQL query to work in SQL2000 by accessing the database directly can also get all the correct data thru Crystal SQL designer and can get all my data using SQLCon32.exe but not all the data shows up in my CR report.
Currently setting my location by using an ADO connection to the DB. (Maybe my problem?). Also under the verify DB I have the SQL selected with the query.

Can anyone give me any ideas on where or what to look for?

Thanks in advance!!!
Jazz

 

[synapsevampire]

What does this mean?:

"but not all the data shows up in my CR report."

Are you missing rows, fields, part of the fields???

Some field types may get truncated/altered, share a few details, including the version of Crystal, it's probably relatively easy to resolve.

This lost me too:

"Also under the verify DB I have the SQL selected with the query."

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Jazz1963]

I wasn't very clear was I?

"but not all the data shows up in my CR report". I meant that complete rows do not show up in CR, they do in SQL, Crystal SQL Designer, etc.

"Also under the verify DB I have the SQL selected with the query." was just for info purposes. This is under the pulldown 'Database' -> select 'Verify Database'. That's where I have the SQL query located.

I don't know if that helps or not. If more info is required let me know. It seems like this shouldn't be this difficult.

Thanks
Jazz

 

[Jazz1963]

I don't understand why but I changed my ADO DB connection to a OLE DB connnection and all the necassary rows (data) shows like it should. Had to rework the report to include the proper fields for this new connection but it all works. Yea!

Thanks again for your help!
Jazz

 

[financeapps]

Similar situation with Crystal 6.0 over a VPN!!!
thread463-400332
I used 'synapsevampire' suggestion and problem was solved.
Why, I don't know?
If any one has an idea please share.

 

[techies]

Hi all,

When you use ADO Recordsets as your datasourse, CR requires it to be a clientside cursor, or else you will not get all the rows back.
So use AdoConnection.CursorLocation = adUseClient;
I didn't find any documentation in this regard, just found out while working on my app here. This will solve your problem.

Cheers,
Techi

 

[synapsevampire]

Yeah, I use OLE DB exclusively now, seems fairly solid and reliable.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com