How to Create a 2-Level Grouping in VB6 Data Report That Gets Data from a .DBF File

[MarkXoz]

Hi Everyone,
I'm new here.. I got a problem with creating groups in the Data Report which gets data from a .dbf file(foxpro). I tried creating a simple report without group headers/footers. The connection to the database is working fine. It displays the data from the database. But I need to use groups to display the info by Name. The error displays "failed getting rowset/s from current data source" I've also tried creating groups that gets data from MsAccess, and it's working fine too.. displaying info the way I want it to be. It seems that the problem is when the report is grouped and gets data from a .dbf file. Btw, these were existing databases so converting to MsAccess might consume a lot of time. I'm using Data Environment..

Can anyone help me here please? I've been searching the net for the same problem for two days now.. Thanks in advance!

[DataMiser]

What kind of connection are you using?

[dglienna]

Microsoft owns FoxPro, so use their site.

[MarkXoz]

Hi guys, thanks for the response. I've switched to using ms sql server rather than foxpro with vb.. It's a lot more smoother..