[AccessD] Active Reports for Visual Basic 6

You don't say what your backend is.  If it's Access, test it directly in access.  If it's Sql Server test it in an ADP or in
Enterprise manager's Tools/Sql analizer.

I've used version 1 and like it.  I really like being able to build the recordset in the calling routine and pass it whole to the
report.  No, scratch that.  I love it!

Tom


----- Original Message -----
From: <paul.hartland at fsmail.net>
To: <accessd at databaseadvisors.com>; <dba-vb at databaseadvisors.com>
Sent: Friday, March 14, 2003 1:42 AM
Subject: [AccessD] Active Reports for Visual Basic 6


> To all,
>
> Has anyone had any experience with Active Reports v2.0 for Visual Basic, if so I wondered if someone could help me with somthing
(bearing in mind I only started using it yesterday).  I have built a report using the ADO connector and I need it to buils the
recordset on the fly. So I am trying to use the following method.....
>
> repPersonnelByOffice.dcRptData.Recordset = "SELECT * FROM [tblPersonnel] WHERE [FinishDate] Is Null ORDER BY [Office], [Surname]"
>
> But I get the error Type Mismatch and the whole line gets highlighted when I click debug.  Now I can't see anything wrong with
this, can anyone point out my mistakes please.......
>
> Thanks in advance.
>
> Paul Hartland
>
> __________________________________________________________________________
> Freeserve AnyTime - Go online whenever you want for just £6.99 a month for
> your first 3 months, that's HALF PRICE! And then it's just £14.99 a month
> after that.
>
> For more information visit http://www.freeserve.com/time/ or call free on
> 0800 970 8890
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com