Grouping with Visual Basic and Crystal Reports 8

[eamonskelly]

I am using a number of unbound fields in VB and wish to group them from a field from an ADO recordset, from within VB. How can this be done?
Thanks

 

[MikeTom]

where does this recordset come from and where do these "unbound fields" come from. do you want to group these for a crystal report?

 

[eamonskelly]

The field comes from a recordset which is produced in VB via ADO, using a query sent back to an SQL Server 2000 database. The unboundfields are produced in the same way, by querying the database and returning the results as the recordset from which I use the individual fields as unboundfields, linked to unboundfields within the crystal report.

 

[MikeTom]

why don t you write a stored procedur e which returns all the records as one recordset and group them in the procedure. then base the report on that procedure.