1 Reply Latest reply on Jul 20, 2013 8:36 AM by GuyStevens

    Can fields from a search show up in a header?



      Can fields from a search show up in a header?


           I'm fairly new to Filemaker and know nothing about scripting. I do work for a fair and every year I need to make reports of the volunteers in each department. Is it possible to use one layout where the title includes two fields that change depending on the search I do to come up with each department list? Each report would have in the header the name of the fair, the year, the department number and the depatment name.

           For example, my first report would be titled XYZ Fair 2013 Department 8 Eggs and Poultry, the second report would be XYZ Fair 2013 Department 10 4-H, etc. I would like to use the same layout for each report keeping the fair name and year the same, but have the two fields (Department Number and Department Name) reflect in the header of the report without having to make a separate layout for each department.

           Is this possible? I hope my question makes sense. Thanks for your help.

        • 1. Re: Can fields from a search show up in a header?

               Yes it is. You can simply use merge fields in a text object in your header.

               If you do a find for a certain department and a certain fair you can set those fields in your header and then you should have what you are looking for.

               Just create one text object with some text and some merge fields. It will dynamically change it's length depending on the contents of the merge fields.

               It's like in a letter and you want to mix some standard text with some merge fields like:

               Dear <<Title>> <<LastName>>

               You still havent payed bill nr. <<BillNr>> for the amount of: <<Amount>>