index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Error message - Your filter is invalid! :: (8) Post a New Message | Post a Reply
Mar 28 2006, 5:52 AM	Error message - Your filter is invalid! Post a Reply
Ed Dwyer from: MIdlands. UK	Hi, I wonder if you could please assist me with this problem. I am trying to use a standard "Is equal to" filter on a field with a Char datatype in an MS SQL 2K database. I continually get the message: Your filter is invalid! [MITMAS].[MMITNO] = 000804  - when I try to filter with an all numeric value. However, when I use a filter value beginning with a non-numeric character it works fine (e.g. Filter(s): [MITMAS].[MMITNO] = '#112040'). Additionally, if I use the same all numeric value in a "Contains" filter on the same field, again it works no problem. I have download and installed the latest program version today and even tried including the  .DatabaseType = "SQLSERVER"  line in the Reports.asp file, but again still no success. Your help will be really appreciated. Regards - Ed
Mar 30 2006, 7:51 AM	Re: Error message - Your filter is invalid! Post a Reply
ghost from: Washington, DC	Is your data from a stored procedure or a table? ------------------------- Ghost
Mar 31 2006, 6:45 AM	Re: Error message - Your filter is invalid! Post a Reply
Ed Dwyer from: MIdlands. UK	Hi, The data is being pulled directly from a table.
Apr 3 2006, 7:24 AM	Re: Error message - Your filter is invalid! Post a Reply
ghost from: Washington, DC	Can you please send me a sample dataset to our support email so that we can test it! thanx! ------------------------- Ghost
Apr 5 2006, 2:50 AM	Re: Error message - Your filter is invalid! Post a Reply
Ed Dwyer from: MIdlands. UK	Many thanks - I will mail this to you.
Apr 12 2006, 1:24 PM	Re: Error message - Your filter is invalid! Post a Reply
ghost from: Washington, DC	This error happens because the report wizard is trying to evaluate your character field as integer. We will try to fix this problem by the next minor release. For now just use the Contains or the Starts with filter options. thanx! ------------------------- Ghost
Apr 13 2006, 12:25 AM	Re: Error message - Your filter is invalid! Post a Reply
Ed Dwyer from: MIdlands. UK	Many thanks, I have already advised my users to use the "contains" option.
May 30 2007, 6:58 AM	Re: Error message - Your filter is invalid! Post a Reply
Ed Dwyer from: MIdlands. UK	Guys, Can you please advise if the fix to this problem has been applied since version 2.0.0.615? Many thanks.
Pages: (1)   [1]

search this forum: