7 Replies Latest reply on Aug 6, 2016 8:58 AM by srzuch

    Filemaker report

    goutam

      I am presently converting an access file to a filemaker solution and very new to filemaker.

       

      In Microsoft access, I have a report that displays the output of a query which in turns queries information from a table. How should I build that in filemaker?

        • 1. Re: Filemaker report
          beverly

          Queries are FIND and SORT. There are manual ways to do these actions and there are "scripted" ways to do these actions.

           

          You may start with the FileMaker Training Series (BASIC) as a starting point to learning how FileMaker works.

           

          In addition, this forum has a Resources section:

           

          • 2. Re: Filemaker report
            carlosilvia0

            Hi,

            in Filemaker don't exist a report but the layout and preview mode.

            • 3. Re: Filemaker report
              beverly

              Yes, the FORM is the layout. Preview is what it would look like printed. However the 'query' is to get (SELECT / FIND) & arrange (ORDER BY / SORT). FM is not sql

              beverly

              • 4. Re: Filemaker report
                Johan Hedman

                I recommend you to read the free FileMaker Training Series to get to know FileMaker better. There is a whole chapter about search in that training serie

                FileMaker Training Series | FileMaker

                • 5. Re: Filemaker report
                  carlosilvia0

                  I approve what do you write. Filemaker isn't born as relation database. I would append that recent function, ExecuteSql() of Filemaker or with external plug-in, have favorite a major step for SQL query in Filemaker.

                  • 6. Re: Filemaker report
                    Markus Schneider

                    As a start:

                     

                    For getting _records_, use the FileMaker functionality ('find mode', 'sort', etc.), show the (sorted) results in a layout with summary parts (etc.)

                     

                    For getting _data_, use eSQL - this will show the data in a text-box (field, $/$$-variable, etc). You can gather data via eSQL and create a 'virtual list' for display (~view)

                    • 7. Re: Filemaker report
                      srzuch

                      Filemaker does not have "queries" like Access.  In Access you define your basic table relationships (in the relationship graph) but you do not build  a multi table form or report directly from the relationship graph.  You first create a query where you select the related tables and fields, define how they are joined (best to use join fields in the relationship graph but can use any fields), sort, filter, aggregate, etc.  You build the form/report based on the query, or for quick analysis, just view the query itself.

                       

                      In Filemaker, the relationship graph is used for much more, and incorporate some of the query features.  You generally will define multiple relationships for the tables, and the tables will be shown multiple times.  These different table views are referred to as table occurrences ("TOs").  In FileMaker, you can define sorting, and difference types of relationships (e.g. greater than or equal to) in this graph.  Your multi-table forms and reports are built directly from these TOs in the relationship graph.   Additional filtering, sorting, selection of fields, etc. are done in the forms and reports.

                       

                      I am moving from Access to Filemaker, and do miss the queries from Access for the quick throw away analysis and views.  Filemaker has added a SQL function where you can execute SQL commands on related tables bypassing the relationship graph; but you need to enter the SQL command (no drag or drop functionality as in Access queries).

                       

                      Steven