Problem Filtering Report data

[HM1]

Hi

I have an unbound text box on a report that is performing a numerical
calculation based on a couple of bound textbox's. The problem I have is I
need to filter the report by the unbound text box, and i just can’t get it to
work.

If I use for example the following in the Filter box of the report properties
this works ok. (SumOfTotalSTKValue is a bound value)

SumOfTotalSTKValue > 100000

However if I use the same method for the unbound textbox

TextBoxValue > xx

it dosnt work, I receive a parameter box asking for a value.

FYI: The reason I am using the report for the filter rather than the bound
query is because the data is derived from a running sum which I am doing
within the report. If I do the running sum in the query it slows down
tremendously.

Is it that the filter only works for bound values??

Any ideas/help would be much appreciated.

 

[Duane Hookom]

"Is it that the filter only works for bound values??" ... yes

You can only filter and sort on expressions from the report's record source.
Why do you think you need a running sum in the record source rather than a
simple total?