Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping with Visual Basic and Crystal Reports 8

Status
Not open for further replies.

eamonskelly

Programmer
Jun 14, 2001
11
GB
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
 
where does this recordset come from and where do these "unbound fields" come from. do you want to group these for a crystal report?
 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top