Drop down option on report generation screen

sm0kkie
sm0kkie Member Posts: 2
edited 2006-11-06 in NAV/Navision Classic Client
I am working on a report based on the Customer table. I have added a couple of fields to specify the a customer type (Business, School, Church) and Category(Affiliate, Fundraiser). My database has several companies, all of whom can customize their types and categories. My issue is related to the the report details screen (the place where you define the report filters). Since I have defined in the Customer table a TableRelation to pull through the list of options for each of these fields, the options are not present on the details screen.

How do I get these options into the drop down on the report details screen?

Comments

  • easabangan
    easabangan Member Posts: 114
    Hi,

    I have tried doing what you have stated, but it seems that it works fine in the report that I have created.

    Try this :

    1. On the request form of your report report add a textbox.
    2. Fill the property of the text box table relation with the same value as you have define on one the fields the you have added in the customer table.
    3. If this fields are for filterings, add a codes to the trigger OnPreDataItem of the Data Item you want to filter.
    No future at CPI
  • Phenno
    Phenno Member Posts: 630
    Is your lookup "feature" does not work or you don't have that fields at all on pre-report form?


    If it's second one that you have to change a property for "ReqFilterFields" on Customer dataItem in the report.
    You can add your new fields to the list and they will be displayed by default (though, you can add them manually on to pre-report form).


    If it's first, if you ran Customer table through Object Designer, is there a lookup arrow applied on those fields?

Categories