Embed a report in a form

Often when you're viewing a parent record, you want to see a list of related child records. For example, say you're running a project, wouldn't it be great to see a list of related tasks when you're viewing the project record? No problem. You can easily create an informative display form like the one in the image below. To do so, you can embed a report within the display form.


This Project record features an embedded report of related task records.

To embed a report:
  1. Display the form you want to embed the report on.

    This form must belong to a parent table. You can't embed a report within a child record. To access a form, display a report of the table's records and click the view button () next to any record.

  2. Click Customize this Form on the Page bar.

    The Form Builder's Elements tab appears.

  3. Add the report link field (that links to the details table) to the form.

    Don't know how to add form elements and work with the report builder? Read how. The report link field is easy to spot as it's usually named after the details table you want to display. Also, when you select the field, its type displays in the Form Builder's right pane.

    When you select the Tasks field on the left, Quick Base displays info and controls to the right of the form
    elements list, and shows the field type at the top.

  4. In the right-hand pane, select Display the related records directly on the form.

    This lets Quick Base know you want to show the report. If you select the other option, Display just a link to the related records, Quick Base would insert a link instead of a list. The link opens the report you're about to specify.

  5. Click the Base the display on the report dropdown and select the report you want to show within the parent record.

    You can see and edit report settings directly from this screen, if you want. To do so, select a report from the dropdown, then click the blue report link. The report opens in the report builder. DO NOT select a report set with matching criteria (filtering). Doing so means that you may not show some records that users expect to see in a list of related records.

  6. If you want the embedded report to display in Grid Edit mode, turn on the Editable checkbox.

    When you make the report editable, viewers can edit child records the report contains directly on the parent form. They can also add new records without navigating to a new screen (even if the parent record has not yet been saved).  Read more about enabling spreadsheet-style editing of an embedded report.

    An Embedded Grid Edit Report lets users edit and add records spreadsheet-style. Editable reports don't display in Grid Edit
    mode when you merely display the parent record form. Like any other data-entry field on the form, embedded Grid Edit
    reports are only editable when you're editing or adding a parent record.

    Note: Embedded Grid Edit reports speed data entry. But there are certain situations in which you won't want to turn this feature on. What are they?

  7. Set the dimensions of the embedded report.

    Form real estate can be valuable. If your report takes up too much room, you can limit its size in one of two ways:

  8. Tell Quick Base when the report should appear on the form.

    When do you want the list of child records to display? Only when the form is in display mode? Edit mode? Or both? Specify your preference by selecting one of these options within the Display when this form is used for: dropdown.

FAQ - My embedded report isn't showing all the records that relate to the parent record. What's wrong?

Make sure the report you insert has no filtering/matching criteria set. If it does, you won't see the records you expect to see. OK, but how do you know which reports have matching limitations? You can see or edit a report directly from this screen. To do so, select the report from the list and click the report link to its right. Quick Base opens the report in the Report Builder so you can make changes.

Related Topics:


Go back      |       |   

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.