index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Filters not working :: (9) Post a New Message | Post a Reply
Sep 27 2004, 9:02 AM	Filters not working Post a Reply
RKBob from: Mt. Home, Arkansas	We create a report that lists customers. When we run it, a list of customers comes up correctly.  Then we want to filter it with the filters at the top of the report listing. I'm looking at a customer name from the resulting report called "Gene Inc.". On the filter, I select: first box - Customer Name second box - contains third box - Gene I get an error message that replies: Your filter is invalid. Customer Name LIKE '%Gene%' What is wrong?  Obviously I have a customer with a name that contains "Gene" as the listing shows.  I've tried with no quotes, single quotes, double quotes, all return errors. Can you please give me some direction?  Thank you. Bob
Sep 27 2004, 9:49 AM	Re: Filters not working Post a Reply
ghost from: Washington, DC	What kind of database are you using? Can I please see your connection string? ------------------------- Ghost
Sep 27 2004, 12:03 PM	Re: Filters not working Post a Reply
RKBob from: Mt. Home, Arkansas	Database:  Microsoft SQL Server 2000 sp3 Connection String:  Provider=MSDASQL;Driver={SQL Server};server=10.0.0.5;uid=SEAS;pwd=*********;DATABASE=MDSEASDemo
Sep 27 2004, 12:52 PM	Re: Filters not working Post a Reply
ghost from: Washington, DC	This error usually occurs when the report wizard thinks that your field type is numeric. Can you please email us (support@aspwebsolution.com) a sample dataset of your data so we can test this problem futher... You can export a few lines of the tables you used in this report a blank SQL database, back it up and email us a copy so we can actually work with the original field types. Question: Does this error occur in every report generated by your database? ------------------------- Ghost
Sep 27 2004, 1:05 PM	Re: Filters not working Post a Reply
RKBob from: Mt. Home, Arkansas	We will back up the database and send it soon (a small sampling). My experience so far is that the wizard blows up just about any time we try to filter on character or boolean fields.  It seems to work pretty well if the field is numeric. For example, if we build a filter that says to return anyone with a "Customer Code" of 2 (numeric field), it almost always works. If we ask it to filter by a boolean field (CustomerActive=True), it always bombs.  We've tried "True", "Yes", 1, <>0, just about anything we can think of but it always gives us the invalid filter error. Character fields almost always cause errors.
Oct 22 2004, 8:11 AM	Re: Filters not working Post a Reply
Darin from: Conway, AR	Ghost, I have this database .bak file ready to send to you for RKBob.  Please let me know where I can place it for you.  It is about 4.5 Mb.
Oct 22 2004, 11:25 AM	Re: Filters not working Post a Reply
ghost from: Washington, DC	upload a copy at the link below and send an email to support@aspwebsolution.com http://www.cityjams.com/uploads ------------------------- Ghost
Oct 28 2004, 3:53 PM	Re: Filters not working Post a Reply
RKBob from: Mt. Home, Arkansas	Ghost - Do you have an update on this issue?  Thank you. RKBob
Oct 29 2004, 11:02 AM	Re: Filters not working Post a Reply
ghost from: Washington, DC	I just checked our uploads site and it is not there - Probably because it was too big (<2Megs). Can you reduce the database size or try uploading it somewhere else and send me a URL. thanks. Also, try running the report wizard with the northwind or Pubs databases and let me know if you get the same error on boolean fields ------------------------- Ghost
Pages: (1)   [1]

search this forum: