index | search | no replies | posting guidelines | help login | register
Index » Products » ASP DataGrid
search this forum:
:: Download Excel ::    show all messagesPost a New Message | Post a Reply
Aug 17 2005, 1:02 PM
 Re: Download ExcelPost a Reply
 Hugh C Willard

View this author's profile Send this author a private message

since: Aug 16, 2005
from: Raleigh, NC

I downloaded the basic application Report Wizard. Copied the files to my W2000 IIS website, which has an Access db. Successfully Modified the pointers to the db. Created successfully the reports from the checkbox page.
Able to download as excel or any other format..csv, txt...successfully.

THEN

When adding the criteria to deliver only those records having a specific value in the XYZ column (XYZ can be any of the column headers in the db)....

I get the report in html successfully, but  ALWAYS..get the following msg when attempting to download in any format: (my value for "zone" was North)

[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'Zone = _qtNorth_qt'.

/export.asp, line 20

When this occurs, I  Cannot download and print to excel, nor any other format...
Please help.

Pages: (1)   [1]

search this forum: