0

Impression de plusieurs champs sur une ligne

Bonjour, j’utilise 2 tables : une DSA DAE l’autre facture 

- je dois récupérer des infos de la table DSA DAE (image 109) pour les imprimer sur la facture (image 110). 
- j’arrive à récupérer les champs sur la table DSA DAE  sur la facture, mais je n’arrive pas à imprimer les différents champs sur une même ligne, voir exemple dernière capture image 108.
merci pour vos retours. 

2 replies

null
    • Fred
    • 2 wk ago
    • Reported - view

    Take a look at your cloud DB. I created a new tab on the Facture client DB and created a new formula field with the following code:

    'DSA 1'.'N° interne' + " " + 'DSA 1'.'Marque & modéle'.'Marque et modéle DM' + " " +
    "N°" +
    'DSA 1'.'N° série' +
    " " +
    'DSA 1'.'Site / service / N° Cde'

    Then I added this new formula field to the print layout. It works but is clumsy.

    Something that will help in your printing with the old print engine, is to create a new child table of Facture client. You can call it 'éléments de facture' (sorry for the bad google translation). Now Ninox will display the linked records for you in a list in the print layout.

    If you find yourself creating fields with the same name and end with a different number, like you do with DSA 1, DSA 2, DSA 3, DSA 4, etc, then you should create a child table. Then that child table has a link to Facture client and to DSA. This way you can create 1 linked record or 10000 linked records.

    Also, may I recommend that you merge all of your product (Marque) tables into one. As they all store the same type of data. You can then create a simple choice field that will differentiate between the products.

    In the new Marque table will be a new child table called Images. This way you can store 1 image or 1000 images of a particular item.

    Something else you may want to consider is to learn how to use the dynamic printing. It is a much better printing system. You can see this example or attached.

      • Fred
      • 2 wk ago
      • Reported - view

       here is an example of a child table showing up in the print view.

      here is the form view:

      GAMESTATS is the child table.

      and here is the print view:

      See how GAMESTATS is already in the print view.

Content aside

  • 2 wk agoLast active
  • 2Replies
  • 31Views
  • 2 Following