Sunday, February 05, 2012   
 Search   
 

http://www.foxfirereporting.com
Register  Login  
Forums  
      
 Forums    
SearchForum Home
  Support  Foxfire! 6.0x Support  Filtering on a ...
 Filtering on a data item compared to a SQL function result using "build expression"
 
 12/4/2008 12:40:23 PM
DefinitiveAnn
1 posts
www.cprplus.com


Filtering on a data item compared to a SQL function result using "build expression"

Still using Foxfire 6.06.

I  have a customer who wants to compare one date field to a date ten days after another date field.  I am trying to use the "build expression" option in the filters and creating the expression using the SQL dateadd function.

the filter looks like

Tickets.start is less than (build expression)

And the expression is:

dateadd(dd,10,ref_date).

The function by itself should return the date ten days after the referral date.  However, when I try to run the report, I get the error:

Program ODBC_GENFILT
Line 6,553
Variable 'dateadd.prg' is not found

I'd really rather not create a data item for this - next time she may want to compare a different time frame to a different date.  On a whim I tried putting quotes around the expression, but they pass through to the SQL, converting the function to a text string.

Is there a workaround or a tweak to make the build expression feature work with SQL expressions?

 5/19/2009 2:01:59 PM
uberstein
12 posts


Re: Filtering on a data item compared to a SQL function result using "build expression"
Hi Ann. :-) (It's Mike from FL--we've spoken on the phone many times)
In fact I think I may have mentioned this error to you on an occasion or two. I'm the guy who always bugged you about FF reports. :-)

I wish I could offer help, other than clicking Ignore a bunch of times usually still runs the report and returns the result.

The only other way I've found to get around it is to create many different data items (Current Date Minus 10 days, Current Date Minus 30 Days, etc etc.) and use those data items in the filter panel expressions. Maybe even make a bunch of these items part of the standard FF database with all the others.
It's cumbersome, but it works once you've created the necessary data items for filtering purposes.

Sorry I can't be of more help.
  Support  Foxfire! 6.0x Support  Filtering on a ...
   
SearchSearch  Forum HomeForum Home     
 Links    
   
  
Downloaded from DNNSkins.com