[AccessD] OT: VB datareports

Charlotte Foust cfoust at infostatsystems.com
Tue Jul 29 12:05:12 CDT 2003


If you want to do it the hard way, you should be able to create the
grouping in ADO using the SHAPE provider, which allows you to create a
hierarchical recordset, much like what Access does behind its reports
when you setting up grouping.

Charlotte Foust

-----Original Message-----
From: Eric Barro [mailto:ebarro at afsweb.com] 
Sent: Tuesday, July 29, 2003 8:56 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] OT: VB datareports


There are just some things that are taken for granted in Access. One of
which is grouping in reports.

This is a question to those who are familiar with VB data reports...

I have a data report design in VB. I am NOT using data environment so
the stuff about grouping in reports on the M$ website doesn't help at
all.

My problem...I get the error that says that the Report sections do not
match the record source. What I need to do is to programmatically tell
the data report to group the records. I can't seem to figure it out. I
use and ADO recordset for the datasource on the data report. I even
tried putting the actual SQL statement as the datasource but it still
complains.

I would appreciate being pointed in the right direction...links, hints,
etc...

Thanks in advance.

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list