i'm hoping there is a solution to this as it's driving me crazy!!! i need to have a total line and my line looks like below - notice the >= sign. the > is causing me all kinds of grief. i've tried > and that does not work. i've tried making the >= a token (placed the >= in a token and used) but that does not work. can i create a var string above the command and use that?? THANKS FROM anyone!!! when i remove the >= portion, it returns the total and works!
Mary
<command SQL="SELECT SUM(LINE_FEA_QTY * LINE_FEA_UNIT_PRICE)
FROM LINE_FEATURE_XREF
[indoogrid:gridViewWhereClause] and LINE_FEATURE_XREF.line_fea_type='mrc'
and (LINE_FEATURE_XREF.line_fea_end is null or LINE_FEATURE_XREF.line_fea_end >= '3/26/2008')"></command>