Date Filter

aliennav
aliennav Member Posts: 449
edited 2007-04-24 in NAV/Navision Classic Client
Hello Everyone
I have applied date filter in some reports,where the data item is ITEM only.whatever values i give in the request form that are being displayed on the report but the data is not gettin filtered according to the dates mentioned.
What might be the problem??

Comments

  • ssingla
    ssingla Member Posts: 2,973
    Which date filter are u applying on the Item card. I wonder except "Last Date Modified" there is any Date field on the Item card. Surely it will be on ILE and Value Entry.
    What are u trying to do.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • ecclectic
    ecclectic Member Posts: 176
    aliennav wrote:
    Hello Everyone
    I have applied date filter in some reports,where the data item is ITEM only.whatever values i give in the request form that are being displayed on the report but the data is not gettin filtered according to the dates mentioned.
    What might be the problem??


    try entering the dates in the option form if it is available, not on the "first" tab where you set your filters. There are high chances that setting dates filters in the "first" tab won't do the job as the data item is Item and it will only filter on fields and values attached to the item master.
  • aliennav
    aliennav Member Posts: 449
    I know that there's only Last Date Modified field
    .But when i have called all the fields from the item table in the article statement report,then how can i achive this thing that in date filter when customer enters some date range ,the items should get selected according to the posting date
    Or, in other words only items which get posted in that duration of period should appear.

    What to do 4 this??
  • vikram7_dabas
    vikram7_dabas Member Posts: 611
    for this report u have to take 2 dataitems 1)item and 2) item ledger entry and link them with the date filter and the posting date of item ledger entry table then ur filters will be working correctly.
    Vikram Dabas
    Navision Technical Consultant
  • aliennav
    aliennav Member Posts: 449
    also tell me that in which Data Item's section i should call all the values??
  • vikram7_dabas
    vikram7_dabas Member Posts: 611
    it depends upon u that which values u wants to print
    Vikram Dabas
    Navision Technical Consultant
  • aliennav
    aliennav Member Posts: 449
    Do i need to do some coding in the request form for date filter attachment??

Categories