AspWebSolution Forums » Products » ASP Report Wizard v2

index | search | no replies | posting guidelines | help

» »

:: Export problems :: (5)

Feb 20 2006, 10:55 AM

Export problems

ac2901

since: Feb 20, 2006
from: Toronto ON Having problems exporting - have an Access database, reports appear fine on screen, but certain reports won't export all the data either to Excel, CSV or Text file. Seems to "hang" at between 30 and 60 records out of 1377. Yet other reports, also based on Queries in the same database, export fine - often with many more records than 1377. Total database size is about 60000 records. Any ideas what I might be doing wrong??

Thanks

Feb 21 2006, 5:54 AM

Re: Export problems

Post a Reply

ghost

from: Washington, DC I can't seem to reproduce this error. I just exported a report of about 100,000 records.
P/S: Do you have any image/blob fields in your report?

-------------------------
Ghost

Feb 21 2006, 8:35 AM

Re: Export problems

Post a Reply

ac2901

since: Feb 20, 2006
from: Toronto ON No funny stuff - just data.
I found post http://www.aspwebsolution.com/forums/?tid=1409
and added "objWiz.CommandTimeout = 60 " - seems to have solved that problem.

Found another bug or feature though - not sure which it is. If I design a report over a Microsoft Access Query which uses a wildcard character (e.g. *), the asp report returns no records. If I redesign the query to select based on exact matches - asp works fine. For example - Postal codes starting A through E are in Atlantic Canada. if I use A* or B* .. E* in the Access Query, the asp report returns no records - even though the Query works fine in Access.

But if I enter specific Postal Codes in the Access Query, then the asp report returns the correct records.

Is this a bug or a feature!

Thanks - great product.

Feb 22 2006, 5:35 AM

Re: Export problems

Post a Reply

ghost

from: Washington, DC Why don't you just use the regular starts with & OR condition as shown in the image below:

-------------------------
Ghost

Feb 23 2006, 12:07 PM

Re: Export problems

Post a Reply

ac2901

since: Feb 20, 2006
from: Toronto ON Thanks that's what I have done,

I have some fairly computer-illiterate users and I'm trying to set up as many of the regular requirements as Access Queries - if the wildcard is a limitation we have to live with, that's fine, we can work with that. Thanks for your help.

Pages: (1) [1]