Options

2 level Date Filter

gulamdastagirgulamdastagir Member Posts: 411
hello,

A: I have a report which uses ReqFilterFields Property of the dataitem set to "Date Filter"


B: But in the DataItem-OnAfterGet Record Trigger have already set a series of 8 filters using DataItem.SETFILTER ().

C:when i run the report, "B" disturbs "A" leading to an Inaccurate Report.

D:Can "A" and "B" Coexist peacefully?

Thanks in Advance,

gd
Regards,

GD

Comments

  • Options
    krikikriki Member, Moderator Posts: 9,098
    Save the filter in "Date Filter" in a variable in the "OnPreReport". So you can restore the "Date Filter" to the filter the user wanted when needed.

    BTW : DataItem.SETFILTER (): you mean other fields or the same field. If it are other fields:no problem.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    ara3nara3n Member Posts: 9,256
    You need to use different FilterGroups for A and B and they won't interfere with each other.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    krikikriki Member, Moderator Posts: 9,098
    ara3n wrote:
    You need to use different FilterGroups for A and B and they won't interfere with each other.
    Not in this case, because it is a filter. So it is for filtering records to calculate flowfields.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    ara3nara3n Member Posts: 9,256
    Use a different record to copy the filters to and use it to calculate the values.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    gulamdastagirgulamdastagir Member Posts: 411
    kriki Posted: Wed Sep 06, 2006 7:50 am Post subject:


    Save the filter in "Date Filter" in a variable in the "OnPreReport". So you can restore the "Date Filter" to the filter the user wanted when needed.

    BTW : DataItem.SETFILTER (): you mean other fields or the same field. If it are other fields:no problem


    Thanks Rashed and Special Thanks to Kriki
    Regards,

    GD
Sign In or Register to comment.