Crystal Rpt 4.0 problem printing just 1 record if rpt contains a memo field

[DexterRose]

I am using crystal rpt 4.0 with a vb 5 program on a win xp computer.

I have a data file with 7 records.

For the first time(for me) I added a memo data field (located on another database) to a new rpt.

When I run my crystal rpt in "design mode" the rpt with the Memo data field prints all 7 records.

When I run the same crystal rpt in my vb 5 program only the 1st record shows and prints.

WHAT COULD CAUSE THIS? Do I need to set a reference or change my crystal control in Some way?

Please help!!

Thanks

[DexterRose]

False Alarm - In fact, Ding Bat comes to mind.

My problem was caused because in the "format section" comand, I forgot to check "Keep section together". I am creating Letters for each record on the database so this solved the problem.

Hope this helps someone else.

[wes4dbt]

please mark the thread resolved.

[DexterRose]

Back Again. This has me baffled!!

I made some changes to my VB5 program and now the crystal report is back to the same old problem!!

My report is a letter from all customers in a database. It uses 2 databases, one DB contains 7 Customers and the other DB contains a Memo field for the "Text Body" of a letter.

I have a VB form with a textbox for my customer to type the letter text they desire.
I have this textbox tied to a Memo field in the 2nd database, (I am using a datacontrol here).

Using Visdata, I can see that the Memo field is updated correctly with correct line spacing, etc.

If I remove the Memo field from the Crystal report, the report prints all records fine, but when the memo field is added to the report only the first record prints.

What on earth could cause this?
It works correctly in report designer mode, but when I run the report from the VB5 program the problem occurs!!

[DexterRose]

Well, it is working now.

What should have been a simple change turned to be a nightmare.

I fixed the problem by adding a Memo field to an "existing database". The best I can determine, the new database I was using was a different version of Access(mdb) and Crystal reports did not like using data from databases if they different versions of Access.

Hope this helps someone.