-
You filter flowfield by using a flowfilter, and including that flowfilter into the calcformula of the flowfield. So if you have a flowfield in table A that shows a total in table B, and you want to be able to filter on a certain date, then you need to add a field of type flowfilter to table A. Then in...
-
You filter flowfield by using a flowfilter, and including that flowfilter into the calcformula of the flowfield. So if you have a flowfield in table A that shows a total in table B, and you want to be able to filter on a certain date, then you need to add a field of type flowfilter to table A. Then in...
-
@David I agree that in Navision the flowfields are indeed very powerful and useful. However, the way they have been implemented in SQL causes a lot of extra overhead when you are writing to the database. Each key which uses SIFT creates another table in SQL which needs to get updated via a trigger when...
-
Please clarify your question. Do you want to allow the user to set or control the FlowFilter for a FlowFields on a Form or a Report ? Do you want to know how to use the CALCFIELDS function in C/AL code?
-
Please rephrase your question and try to use examples of standard Navision tables or at least with some imaginery records like: table B: 1, Test 2, Test2 3, Test3 and explain which records you want to filter how and what result you want to achieve.
-
Hi all Could you tell me how to filter flowfield in situation. I have one Field, that is flowfield from field b of table B but I want to calcfield with filter some record of B. Anyone show me solve it thanks
-
Please clarify your question. Do you want to allow the user to set or control the FlowFilter for a FlowFields on a Form or a Report ? Do you want to know how to use the CALCFIELDS function in C/AL code?
-
Please rephrase your question and try to use examples of standard Navision tables or at least with some imaginery records like: table B: 1, Test 2, Test2 3, Test3 and explain which records you want to filter how and what result you want to achieve.
-
Hi all Could you tell me how to filter flowfield in situation. I have one Field, that is flowfield from field b of table B but I want to calcfield with filter some record of B. Anyone show me solve it thanks
-
Do not forget that there will be Webservices which can be used to feed the Reporting services in MS SQL... it means, you can still use FlowFields... :-)