# NAV Flow Fields in Report Services

**URL:** <https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116>\
**Category:** Technical Forum\
**Created:** [January 14, 2010, 12:01pm UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116 "2010-01-14T12:01:26Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Supp85](https://avatars.discourse-cdn.com/v4/letter/s/b9e5f3/32.png) [@Supp85](https://www.dynamicsuser.net/u/Supp85)\
**Post date:** [January 14, 2010, 12:01pm UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116/1 "2010-01-14T12:01:26Z")

</div>

Hello all,

I am trying to replicate a NAV report in reporting services however Flow FIelds dont seem to appear is it possible to show these fields in reporting services?

---

<div class="post-metadata">

**Author:** ![MattTrax](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/matttrax/32/9408_2.png) [@MattTrax](https://www.dynamicsuser.net/u/MattTrax)\
**Post date:** [January 14, 2010, 1:01pm UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116/2 "2010-01-14T13:01:23Z")

</div>

FlowFields are not actual fields, so no. They are not stored in the database, but calculated on the fly when they are needed. You’ll need to look at the CalcFormula for the flow fields you need and replicate them in SQL.

---

<div class="post-metadata">

**Author:** ![ReGa](https://avatars.discourse-cdn.com/v4/letter/r/ee59a6/32.png) [@ReGa](https://www.dynamicsuser.net/u/ReGa)\
**Post date:** [January 14, 2010, 1:09pm UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116/3 "2010-01-14T13:09:15Z")

</div>

thats correct, depending on your version you have to use views or functions to get access to it.

if you also want a detail how to see here: [http://msdynamicsbooks.com/product\_info.php?products\_id=181](http://msdynamicsbooks.com/product_info.php?products_id=181)

but if you have any detail question how to:

- which field do you want to use?

- which version are you running ?

rgds,

rene

---

<div class="post-metadata">

**Author:** ![Supp85](https://avatars.discourse-cdn.com/v4/letter/s/b9e5f3/32.png) [@Supp85](https://www.dynamicsuser.net/u/Supp85)\
**Post date:** [January 14, 2010, 1:29pm UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116/4 "2010-01-14T13:29:54Z")

</div>

Thank you both for your reply.

Currently running NAV5.0 and using SQL Report Services 2005 and wanted to use ‘Cost Amount (Actual)’ and ‘Location Code’ fields from the Item Ledger Entry table. Would I need to replicate this in the dataset?

---

<div class="post-metadata">

**Author:** ![MattTrax](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/matttrax/32/9408_2.png) [@MattTrax](https://www.dynamicsuser.net/u/MattTrax)\
**Post date:** [January 14, 2010, 3:37pm UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116/5 "2010-01-14T15:37:49Z")

</div>

Location Code in Item Ledger Entry is not a flow field.

Cost Amount (Actual) is the sum of the Cost Amount (Actual) field from the Value Entry table with matching Item Ledger Entry No.

---

<div class="post-metadata">

**Author:** ![stryk](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@stryk](https://www.dynamicsuser.net/u/stryk)\
**Post date:** [January 15, 2010, 7:17am UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116/6 "2010-01-15T07:17:24Z")

</div>

Hi Tazzy,

check out this one (and the releated forum discussion):  
[http://www.mibuso.com/dlinfo.asp?FileID=1101](http://www.mibuso.com/dlinfo.asp?FileID=1101)

This may help you to generate the required sub-queries for NAV FlowFields!

Kind regards,  
Jörg

---

<div class="post-metadata">

**Author:** ![Supp85](https://avatars.discourse-cdn.com/v4/letter/s/b9e5f3/32.png) [@Supp85](https://www.dynamicsuser.net/u/Supp85)\
**Post date:** [January 21, 2010, 3:19pm UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116/7 "2010-01-21T15:19:13Z")

</div>

Thank you for your reply and thank you Jorg for the link that was very helpful!

---

<div class="post-metadata">

**Author:** ![stryk](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@stryk](https://www.dynamicsuser.net/u/stryk)\
**Post date:** [January 22, 2010, 8:18am UTC](https://www.dynamicsuser.net/t/nav-flow-fields-in-report-services/24116/8 "2010-01-22T08:18:51Z")

</div>

You are welcome [:)]