[RESOLVED] Sub report issue?

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

I only have Crystal 8.5 but hopefully 9.2 is similar.

Open the Format Section screen in the SubReport.
Click on Details
Ensure the option - Use Multiple Columns is selected
A new Tab will appear called Layout. Format the Layout as desired.

Thanx for reply & kind suggestion but thats not solving my problem because it displys whole data again in next column. rather I want it to display in a such way that only 1 to 20 in 1st column & remaining 21 to count(records) in next column. is there any way to display or any formulas ? :rolleyes:

No one is going to spoon feed,so u have to try by urself only, I have solved it withhelp of brucevde suggestion & some help from google search. bye