hi VB Master, I'm building an application using VB6, MS Access 2003 as database, and crystal report ocx for printing and report.
Right now I'm using ms dao (database files) to connect crystal with access. But it is very slow, when I want to show 1 record out of 1000, the rpt load all 1000 record first before filtering.
I need help if someone know how to tell crystal to load only records I want to see.
I tried to convert database driver using OLEDB, that work, crystal only load records I want to see, but when I proceed into my other report I received error messages says there is no files ... bla bla... and I can't use some of my queries.
any help would be appreciated. thanks.
Ricky80
0
Newbie Poster
Recommended Answers
Jump to PostIt has been a long time since I used CR, but if I remember correctly, you can set the sql statement of the CR so that only the records you want are queried for, thus making it faster.
Good Luck
Jump to Posthmmmm....
Why dont you create a Queery in the database then connect that quiry in the CRThen use SQL command in deleting and recreating that quiry in your vb app.
In that way you can customize (using the sql command in creating a query view) what will …
All 5 Replies
vb5prgrmr
143
Posting Virtuoso
Ricky80
0
Newbie Poster
jhai_salvador
48
Junior Poster
Ricky80
0
Newbie Poster
jhai_salvador
48
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.