by Hi,
FROM A DESPERATE PERSON
First of all, I would like to thank everybody who has helped me before.
Please HELP me if you can as I'm a newbie in VB, Microsoft Access and
crystal reports. I'm getting very desperate as I'm left with one week to
complete my project.
I'm using MDB database and I've now finished with the database access.
But now, the problem lies with the speed while printing selected
database records.
I've currently using Crystal reports 2.0 that comes with VB 3.0. I've
created a crystal report custom control on my form. I've generated the
following record selection criteria in VB.
CrystalRpt.ReportFileName = "k:\project1\rpt1.rpt" 'name of rpt
CrystalRpt.SelectionFormula = "{CUST.DATE} >= Date(1996,09,01)"
CrystalRpt.UserName = "irene" 'db is secured
CrystalRpt.Password = "irene"
CrystalRpt.DataFiles(0) = "K:\project1\cust.mdb" 'db to use
CrystalRpt.Destination = 1 'to printer
CrystalRpt.Action = 1
CUST.DATE is a field in CUST table which is indexed. This table also
consists of two other indexes. This table is very big and has more than
60000 records. I've set the use <indexes for speed> option in crystal
reports. This database is stored in a network drive. Apart from this,
this database also has another two tables which holds around the same
number of records.
The problem is : crystal reports takes more than 10minutes to select
records from Sep 1996 onwards. What I can see on the screen is it check
from the 1st record to the last record in the table? Why? I've already
supplied the index for date? Why it takes so long here but in VB, this
can be done in a few seconds. This selection time is absolutely out. Is
crystal report slow???? So what can I do? I thought of using VB printer
object, but that'll be very tedious and time consuming (This report also
requires to calculate total amount of money spent, etc under each
customer categories).
Any suggestions? Should I still continue to use crystal reports? Is
there any third party report printing s/w that will solve my problem? Or
is Microsoft Access report function difficult to learn? How long will it
takes normally for a totally new person? What do VB programmers normally
use for report generation?
--
Cheers,
Irene
---------------------------------------------------------
My Homepage : http://home.pacific.net.sg/~irene
:-))))))))) Have a nice day
---------------------------------------------------------