VB Data Reporter

[evandey]

I am trying to run a data report from VB. Instead of using the data environment, I am using an ADO recordset as my datasource. I'm having trouble getting the data report to group by the fields in my recordset. I'm receiving the error "Report sections do not match data source". Can someone please help. Thanks.

 

[Guest_imported]

The errror message means :
The groups you created in the report don't match the groups created by the ADO recordset.

Eg. In the report you have 2 groups, but the recordset creates only 1 group, you'll get an error.

Capiche ?

 

[scorpio66]

You need to use the MSDataShape provider with Compute clauses to achieve this.

Chaz

 

[evandey]

Can either of you be more specific on creating groups. I have a group by clause in the SQL statement but that doesn't seem to be working.

 

[scorpio66]

The groups in the SQL query are irrelevant. Use the MSDataShape Provider and shape the data using this so that it matches the structure of your report.

Chaz

 

[evandey]

Thanks scorpio66. I'll give this a try.