can i do with single or multi rpttextbox

[kalwar]

I have a one field access recordset, i want to display recordset through Query group based like

ssql="shape{select * from digits}as grp1 compute grp1,count(grp1.number)as totalno by number"

45
423
546
456
458
753
64
24

and i want to dispay detail section with five colums like this

45 423 546 456 458
753 64 24

while i have a single field plz help me how can i do with single or multi rpttextbox.

[brucevde]

Are you using Crystal Reports?

[kalwar]

i am using vb6 datareport, plz help me

[kalwar]

brucevde can you tell me how it will work with crystal report

[brucevde]

To setup the Details section for multiple columns.

1) Place the database field(s) in the details section as normal.
2) In Format Section dialog, click on Details and set the option "Format with Multiple Columns".
3) Once you check that option a new tab called Layout becomes visible. Use this tab to setup your multi-column page.
4) Set the Width property and set the Across Then Down option.

When you click OK, Crystal will duplicate your details section to the right X number of times, depending on the width you have chosen.