Get the name of values in flowfilter field in report

vyanku · 2007-07-25

I have one report containing locationfilter field.
When I run the report I insert values in this field .
When the report executed can we get the name of those location which I insert into locationfilter field.
The Field name :- Locationfilter
datatype:- Code
FieldClass:- Flowfilter

kriki · 2007-07-25

You can get the values of filters ONLY in the OnPreReport-trigger.
Use GETFILTER("Some Field") to get the filter of a certain field and GETFILTERS for all filters.

vyanku · 2007-07-26

No I got the filter values but what I want to
Like if ur selecting vendor no. in General Journal it will automatically get the name of that vendor.
Just like this When insert locations in location filter field I want to get there names. Can I do this?? How??

kriki · 2007-07-27

That is not possible in a filter-field.
You would have to make a new field in the requestform, add an extra field in which you put the name and the code to do that, you have to put in the OnAfterValidate-trigger of the first field.

DenSter · 2007-07-27

Your problem might functionally be completely different from this pretty technical question, so here's a few options.

If the Location code is part of the table in your dataitem, you could add a lookup flowfield to the location name and do a CALCFIELD on that field in OnAfterGetRecord. It's going to kill performance if that report is bigger.

You could also program the lookup in code, but then you'll have the same performance issue.

Then you could sort the data by location and only get the location if the value of the Location Code changes.

Get the name of values in flowfilter field in report

Comments

Categories