Hi there,

I am using Vb 6.0 & CR9. My problem is that i have to show subreport in my main report but in a such a way that only 20 records of subreport will display sequentally from 1 to 20 & from 21 onwards it should display records in next column. Subreport is in details part of my main report. Actually i have 40 records but i want to display 20 in one column & remaining 20 in other column but in detail part of main report only.

eg.

Current display:

Details
----------------------------------------------------------------
1 Wheat
:
:
:
40 Cable

Desired display:

Details
----------------------------------------------------------------
1 Wheat__________21 Computer
2 Rice____________22 Laptop
:________________:
:________________:
:________________:
:________________:
20 Fuel___________40 Cable