Options

Filters in request form

DnealDneal Member Posts: 103
Hi all,

I have created fields on the request form that I will be using has filters for different tables. Is there a way to have these fields behave like the field selections on the dataitem tab? I want to be able to use ..,>,<,<> and =.
Is this possible?

Thanks!

Dneal

Comments

  • ara3nara3n Member Posts: 9,258
    you can add a dataitem at the bottom of the report. You can use this to as a dummy dataitem to get the filters, On prereport you copyfilters to a global variable. Onpredataitem of these add currreport.break;
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DnealDneal Member Posts: 103
    That's a great idea! I'll give it a go.

    Thanks kindly!

    Dneal
  • DnealDneal Member Posts: 103
    I used a dataitem of integer. Only number is available for the ReqFilterFields. How do I put the needed filters on this tab?

    Thanks again,
    Dneal
  • ara3nara3n Member Posts: 9,258
    you need to use the actual table not integer table
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DnealDneal Member Posts: 103
    Oh, I misunderstood. I have 5 tables in this report, the customer doesn't want to see 5 tabs. They want one tab, which is why I'm using an option tab with global varibles. I thought you meant I could use a dummy table for all the fields, and do it in one tab.

    I'm still trying to figure out how I can get the fields on the option tab to behave like the filters on the dataitem tab.

    Any ideas?

    Thanks,

    Dneal
  • DnealDneal Member Posts: 103
    Quote:
    Any ideas?


    Read documentation (Application Developer's Guide, Development I, Development II). All answers are there.


    I appreciate your response, as obvious as the solution you gave was however, I have read development I and II along with the Application Designers Guide. I can't find anywhere that lets me make the field behave like a filter in the tab.

    Dneal
  • markborgesmarkborges Member Posts: 170
    Did you try to put all those fields from those 5 tables into a single table, and used it as a dummy catch dataitem?

    I think this would be very complex, but, if it's really necessary, this could work for you and your customer unbelievable request.

    :wink:
    Marcelo Borges
    D365 Business Central Solutions Architect
    BC AL/NAV C/AL Developer
    BC Repositories.com
  • DnealDneal Member Posts: 103
    Your idea does give me a solution. I'm starting to see that this is going to be complex. I will go back to the client to let them know how involved this request will be.

    Thanks for your suggestion! If they go ahead I will have a way to proceed.

    Thanks again,
    Dneal
  • ara3nara3n Member Posts: 9,258
    Hello Dneal.
    Please take a look at report 10028. On Option tab there is an example for budge filter. basically there view things that you need to change on text box property.

    TableRelation. Copy and paste from actual field.
    ValidateTableRelation := No
    ClearOnLookup := No



    Also on OnValidate()
    "Acc. Schedule Line".SETFILTER("Budget Filter",BudgetFilter);
    BudgetFilter := "Acc. Schedule Line".GETFILTER("Budget Filter");



    The sourceexp is BudgetFilter;

    Hope this helps.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DnealDneal Member Posts: 103
    Thanks ara3n! That is exactly what I was looking for. =D>


    Dneal
  • ara3nara3n Member Posts: 9,258
    You are welcome. :P
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSterDenSter Member Posts: 8,307
    @ Dneal: some people should just be ignored :mrgreen: don't get annoyed with them, it'll only cause stress.
Sign In or Register to comment.