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 is slows down tremendously.
Any ideas/help would be much appreciated.