Dear Mr. Babu

I am working on a test project. Were I use access 2000 and VB and for report crystal report. In access I have 25 tables with collect data about 25 different dimensions of an auto part. I created a report using crystal report and put 25 fields [field name 'dimension'] from each database into report. For eg my report looks like.
dimen1.value, dimen2.value, dimen3.value and so on till 25 dimension.

Now after creating a report I entered first record with 25 dimension i.e. one value per table. After that I entered 2nd record in which I put only 4 dimension. Now when I preview the report my problem is 1 record show all the 25 dimen. perfectly but 2nd record which has only 4 dimension shows first 4 dimension correctly but from the fifth dimension it shows records of first record.

I am really confused . Why the 2nd row in report shows the data in 5th dimension of first record. 2nd row in report is supposed to be blank as I have entered only 4 dimensions. If you can guide then please help