index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Filter Questions :: (7)Post a New Message | Post a Reply
Oct 17 2006, 12:14 PM
 Filter QuestionsPost a Reply
 2shediac

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

since: Oct 17, 2006
from: Toronto,ont

Hi when I am doing a filter I want to filter by a text value and I can't figure how to do it. I select the field (say course code) and the is greater than but no matter how I put the data in the value field - I get invalid search condition.

Any thoughts?

Oct 17 2006, 7:03 PM
 Re: Filter QuestionsPost a Reply
 ghost

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

from: Washington, DC

Are you using a stored procedure?


-------------------------
Ghost
Oct 18 2006, 3:55 AM
 Re: Filter QuestionsPost a Reply
 2shediac

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

since: Oct 17, 2006
from: Toronto,ont

No ... Just a normal table. Its connected to a MySQL database though...



Oct 21 2006, 5:03 PM
 Re: Filter QuestionsPost a Reply
 ghost

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

from: Washington, DC

We cannot seem to reproduce this bug. Try to use the DisplayPreparedSqlCommand to display the SQL query and email it to us.

objWiz.DisplayPreparedSqlCommand = True



-------------------------
Ghost
Oct 23 2006, 9:55 AM
 Re: Filter QuestionsPost a Reply
 2shediac

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

since: Oct 17, 2006
from: Toronto,ont

That makes no difference.  When I go into add filters to the report and I choose a text field and  choose a condition (e.g. greater than) and then enter a value and I click add - I get invalid search condition.

If you want to see this live - I can set up a temporary link ...



Oct 23 2006, 4:36 PM
 Re: Filter QuestionsPost a Reply
 ghost

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

from: Washington, DC

There was a restriction of using Numeric evaluations (less than or greater than) on string comparisms in earlier versions of MySQL.
This bug will be fixed and an updated version of the report wizard will be available for download this Friday.

thanx!


-------------------------
Ghost
Oct 25 2006, 2:22 PM
 Re: Filter QuestionsPost a Reply
 ghost

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

from: Washington, DC

Download the latest version of the report wizard and add this property for the wizard:

    objWiz.AllowAllFilters = True.

For more information check out the link below:
http://aspwebsolution.com/forums/?tid=2137




-------------------------
Ghost
Pages: (1)   [1]

search this forum: