# How do i do this report?

**URL:** <https://www.dynamicsuser.net/t/how-do-i-do-this-report/29763>\
**Category:** User Forum\
**Created:** [March 9, 2011, 10:43am UTC](https://www.dynamicsuser.net/t/how-do-i-do-this-report/29763 "2011-03-09T10:43:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![skogza](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@skogza](https://www.dynamicsuser.net/u/skogza)\
**Post date:** [March 9, 2011, 10:43am UTC](https://www.dynamicsuser.net/t/how-do-i-do-this-report/29763/1 "2011-03-09T10:43:35Z")

</div>

hello friends  
I have a small problem to solve.

I shall be selecting the items that have NOT been purchasing a certain date.  
Thus, only articles that have procurement systems PURCHASE.

Example. Date 10-08-01-11-03-09 which items that I did not buy those dates.

how do I do?

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [March 9, 2011, 10:55am UTC](https://www.dynamicsuser.net/t/how-do-i-do-this-report/29763/2 "2011-03-09T10:55:28Z")

</div>

If i understand your requirement corectly,

you want to show the list of items which are not purchased in a given period?

---

<div class="post-metadata">

**Author:** ![skogza](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@skogza](https://www.dynamicsuser.net/u/skogza)\
**Post date:** [March 9, 2011, 11:06am UTC](https://www.dynamicsuser.net/t/how-do-i-do-this-report/29763/3 "2011-03-09T11:06:47Z")

</div>

Exactly!

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [March 9, 2011, 11:18am UTC](https://www.dynamicsuser.net/t/how-do-i-do-this-report/29763/4 "2011-03-09T11:18:41Z")

</div>

something like in Item dataitem

CLE.RESET;  
CLE.SETRANGE(“Item No.”,“No.”);  
CLE.SETRANGE(“Entry Type”,CLE.“Entry Type”::Purchase);  
CLE.SETRANGE(CLE.“Posting Date”,“Date Filter”);  
IF NOT ISEMPTY THEN  
CurrReport.SKIP;