Request Form in Report

rtames
rtames Member Posts: 56
edited 2005-12-20 in Navision Attain
Hi

I'm new to navision programming reports.

Is it possible to create a request form in a report from where I can make a selection from a listbox. The listbox should be filled with some data from an excisting table (a query on that table(filter))

kind regards,

robbert

Comments

  • awarn
    awarn Member Posts: 261
    Yes, but instead of a list box how about a field that drills up to another form (like a list of items). This is a lot easier.

    Go View -> Request form.
    Add a textbox to the form.
    Create a variable of type Code (10 or 20, depending on what you are storing).
    Make the SourceExpr of the textbox your new variable.
    Change the TableRelation property to look up to the table you want (so if you wanted a list of items, the TableRelation would be 'Item' (no quotes).

    The user can now drill up, and your variable holds the data they select.


    If you want to hard code values, you can declare a variable of type Option, and then in the properties of that variable fill in the option string values, and this will appear in a combo box.



    If you really want a list, you need to create a new form (that shown the record you want when you run it), and put a subform on your options tab, where the source is your new form.


    -a
  • rtames
    rtames Member Posts: 56
    That works.

    But when I try to set a filter on the table so I do not get the whole tableview it doesn't work. Any ideas how to set a filter on the table?

    kind regards

    robbert

Categories