# Display filterfields in report

**URL:** <https://www.dynamicsuser.net/t/display-filterfields-in-report/6186>\
**Category:** Developers Forum\
**Created:** [August 5, 2002, 8:28am UTC](https://www.dynamicsuser.net/t/display-filterfields-in-report/6186 "2002-08-05T08:28:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MFH](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@MFH](https://www.dynamicsuser.net/u/MFH)\
**Post date:** [August 5, 2002, 8:28am UTC](https://www.dynamicsuser.net/t/display-filterfields-in-report/6186/1 "2002-08-05T08:28:20Z")

</div>

I have designed a report with on the request form a datefilter, i.e. I created a qDatStartFilter and a qDatEndFilter which the user has to fill in (somehow I can’t manage to get the filter in one field of type Dateformula) The report is based on table 113 Sales Invoice Line and I enclose the Posting Date form the Sales Header in a variable called gDatPostingDate. It is that field on wich I filter the report with the above mentioned variables on the request form. Now I want to print both dates in the header of the report, so that the user can see wich period he has printed the report for. Anyone an idea? Groeten, Michiel Hageman ICT & quality manager PM Komponenten B.V. The Netherlands

---

<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:** [August 5, 2002, 9:28am UTC](https://www.dynamicsuser.net/t/display-filterfields-in-report/6186/2 "2002-08-05T09:28:54Z")

</div>

Maybe a TextBox with that SourceExpression:

```auto

STRSUBSTNO('Period: %1..%2', qDatStartFilter, qDatEndFilter)

```

But what about this:- Create a new FlowField in T113 with a LookUp to the Posting Date of T112

- Now you can set a (more complex!) Filter directly on the Posting Date

- Finally print your period like this

Best regards, Jörg Joerg A. Stryk Apollo-Optik, IT/ERP

---

<div class="post-metadata">

**Author:** ![daves](https://avatars.discourse-cdn.com/v4/letter/d/848f3c/32.png) [@daves](https://www.dynamicsuser.net/u/daves)\
**Post date:** [August 5, 2002, 3:57pm UTC](https://www.dynamicsuser.net/t/display-filterfields-in-report/6186/3 "2002-08-05T15:57:52Z")

</div>

For additional examples, examine any of the standard Navision reports that show a filter at the top of the report. After looking at several of them you should be able to design to fit your own situation. Dave Studebaker [das@libertyforever.com](mailto:das@libertyforever.com) Liberty Grove Software A Navision Services Partner