using @* in Setfilter

subhadynamics
subhadynamics Member Posts: 109
edited 2011-10-28 in Entrepreneur Solution
Hi All

The Item Ledger Entry table we have a field "Issued For".The Issued For field we have given the data like this For Eg: Branch Transfer from Bangalore,Branch Transfer from Hyderabad,Mechanical,Grinding Etc ..

I have a report using this same filed "Issued For ".but i need to filter the records like this @*BR.TRFR* in the Reports .How can i use the same filteration in the reports .

I have given the code like this

recItemLedgerEntry.SETFILTER(recItemLedgerEntry."Issued For",'<>%1','@*BR.TRFR*');

But this is not working in the reports!

Please help me out !!!

Thanks

Subha

Comments

  • navuser1
    navuser1 Member Posts: 1,334
    this will help you.

    Now or Never
  • subhadynamics
    subhadynamics Member Posts: 109
    Thanks For the reply.

    But my report to filter the records without the branch transfer details from Issued For
    field .I need to filter with the field issied for with <>%1 ,BR.TRFR.

    Thanks

    Subha
  • navuser1
    navuser1 Member Posts: 1,334
    subhadynamics wrote:
    Thanks For the reply.

    But my report to filter the records without the branch transfer details from Issued For
    field .I need to filter with the field issied for with <>%1 ,BR.TRFR.

    Thanks

    Subha

    SETFILTER(Issued For",'<>%1','*BR.TRFR*');
    Now or Never
  • vijay_g
    vijay_g Member Posts: 884
    navuser1 wrote:

    SETFILTER(Issued For",'<>%1','*BR.TRFR*');

    the guy telling you, i think he has not used it before posting either it can't be possible if you will try it on object designer will not work but you can try to help of Mark Or Unmark to do for it.
  • subhadynamics
    subhadynamics Member Posts: 109
    yea the above filteration is not working in that Reports.
  • vijay_g
    vijay_g Member Posts: 884
    subhadynamics wrote:
    yea the above filteration is not working in that Reports.

    right. but in report you can skip these records that r lying in SETFILTER without '<>%1'.
  • subhadynamics
    subhadynamics Member Posts: 109
    how can skip the records ???
  • David_Singleton
    David_Singleton Member Posts: 5,479
    The way you are doing this is completely wrong. You should have a code field that drills down to a list of options with a key on that field and filter an option. Then you need to carefully think out the options so that they work for you.

    The problem here is not code, the problem is that you have not solved the business requirement of the customer correctly.
    David Singleton
  • navuser1
    navuser1 Member Posts: 1,334
    navuser1 wrote:

    SETFILTER(Issued For",'<>%1','*BR.TRFR*');

    Sorry !
    This will not work.

    Use CurrReport.SKIP function to skip those records which you want.
    Now or Never
  • bala_first
    bala_first Member Posts: 7
    sehnazjoshep wrote:
    Ya this is not working for me I have tried out all the option which is mentioned here. Anyone is here for sloving this problem?


    hi,

    try this one..

    SETFILTER(Issued For",'<>%1','@*BR*TR*FR*');


    this will work if 'Issued For' field is a Text or code data type only.....
  • Sog
    Sog Member Posts: 1,023
    TS wrote:
    How can i use the same filteration in the reports .
    I'll think you want to have this answer.
    So I suggest you don't place the filter on some variable in your report, but on the dataitem (aka a record) iterating those ledger entries.

    I encourage you to read and reread your requests. We have NO knowledge of your situation, just describe the problem as best as you can, so we can help you the best way we can :)
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|

Categories