Eric Barro
ebarro at afsweb.com
Tue Jul 29 13:39:14 CDT 2003
Charlotte, Thanks for the direction. I decided to take the easy way out for now (yes I still want to learn to do it the hard way with the SHAPE provider). For this project I added a Data Environment to my project and worked my way through the grouping thing and will use this to learn all about the SHAPE provider to manipulate hierarchical recordsets. We have it so good with Access and it's magnificent report generator! --- Eric Barro Senior Systems Analyst Advanced Field Services (208) 772-7060 http://www.afsweb.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Tuesday, July 29, 2003 10:05 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] OT: VB datareports 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --- Incoming 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 --- 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