Crystal Report Control problem

[Joffies]

Good day to All!

I use the the crystal Report 8 control in my application to produce reports needed. I first write the records i need to a temporary table and then store their record Id's in a Array called IRecNo.

Dim iRecNo(1 to 1000) as Long
Dim icounter as long ' Each time i write a new record icounter + 1

'This is where where the array gets its values.
iRecNo(icounter) = rsUpdate.fields("Cert_Number") ' AutoNUmber


After all the records have been written to the temp tables i do the following.
For i = 1 to iCounter
Call PrintCMForm ("ReportName.rpt". IrecNo(i))
Next i

The problem is the following. Sometimes when I need to print more than one copy of the same report to the screen "crptToWindow" and then the report displays blank on some record. But if i pass it right through to the printer it prints the record. What could be the reason????? No matter what i try I cant get it right.

[oh1mie]

Do You Have any NULL fields on same record ?

[Joffies]

Yes I do!

I have three records that i call through ADO. The first two records shows!!! although they have null fields aswell. Only the last record wont show anything at all using the Crystl32.ocx.

Do you think it would make a diffrence if i write values to all the fields before i call the record through the ocx.???

Thanks for the input!!!

[oh1mie]

I'm not sure, I got same kind of problem with one report, Code is on my home, i'll check it later. I don't remember how i did solve it.

I gome back later.

[Joffies]

I took another closer look at things! It seems even though the recordset dont have any null values the report still shows blank. Please note that I am working on a Access 2000 database. Dont you think it the problem could lie within the array ??????

I am burning inside to find a solution. It should all be crystal clear!!

[Joffies]

OK I have rubbed my head a couple of times now!! What i have tried now is this. Instead of printing to the window. crptToWindow i have used crptToPrinter and now it prints out the record that is blank when I print to the window!!!!

Any suggestions???????