Create a Table Report

When you create a Table report, QuickBase makes it easy to display only those records you wish in the format you prefer.

To create a table report:

1. Open the QuickBase Report Builder page.

   You can do so in one of the following ways:

   • In the menu bar on any application page, select Customize > Create a new > Report. Then select the table whose records you want to view.

   • In the table bar on any application page, click the name of the table that you want to create a report for and within the menu that appears, select Create a New Report.

2. In the dialog, select Table and click Create.

3. Tell QuickBase what records you want to see.
   If you want your chart to show only a certain kind of record or only records that meet specific conditions, you can tell QuickBase so in the Report Builder's Filters section. For example, maybe you only want to show sales figures for a specific period of time, like the last quarter. Or maybe you'd only like to see sales of "widgets" and not your other products. To make choices like this, go to the Filters section and select the Filter records. Then make the selections you want. Read how.

4. Tell QuickBase how to order records in the report.
   Within the Sorting & Grouping section you can set the reports sort order and also organize records into groups. Read how.

5. Tell QuickBase what fields (columns) to include.
   What information do you want to show? Use the Columns section to tell QuickBase which columns (fields) you'd like to display and in what order. Read how.

6. Set output format.

   1. Note: If the application manager has not granted you the right to export data, you can't select an alternate output format. QuickBase will only display your report in a browser.

   Most of the time, you won't want to make a change here. However, if you want to output to something other than QuickBase's standard report display, you can. To see what's possible, go to the Options section. Make a choice from the Format dropdown:

   • Normal. Select this option and QuickBase formats the report to appear nicely in a browser. This is the standard report display you see throughout QuickBase.

   • Plain Text. Need to keep it simple? Choose this option and QuickBase displays your report in unformatted text. You won't win any design awards, but this output works nicely for those using handheld devices.

   • Comma-Separated Values and Tab-Separated Values. Both these options let you export the data in the specified format. You can then view it in a spreadsheet or other database program.

   • XML (flat or structured). Select this option if you plan to transform your report using an XSL style sheet. If so, you must create and store this style sheet as a text page within a QuickBase application, preferably the same one as your report. When you select an XML option from the Format dropdown, QuickBase prompts you to enter the URL of your XSL file. If you've saved the XSL file as a text page in the same application, just type its name (like marketing.xsl) in the Associated XSL document text box. If the XSL file lives in another QuickBase application, enter its URL in the Associated XSL document text box. This will be something like: https://www.quickbase.com/db/6pfpsy9r?act=DBpage&pagename=genericstructured.xsl. You must replace any ampersands in your stylesheet URL with the caret (^) character.

     1. FAQ: Should I choose Flat or Structured?
        If you don't get the results you expect, try "flat" instead of "structured" or vice-versa. Most stylesheets work with either flat or structured XML but not both.

7. Set other display options.

   Option	Report Builder Section	Description
   Hide main table and show only summary table	Sorting & Grouping	The Main Table is the report you've been designing, so most of the time you'll want this checkbox turned off. Some report designers select this checkbox and the one beneath it, Show summary table based on the grouped columns. Doing so shows only Totals and Averages tables. However - if it's a summary report you want, you can create one instead of a table report.
   Show summary table based on the grouped columns	Sorting & Grouping	Select this option to display the summary table beneath the main table you've designed. (What's a summary report?) The Sorting/Grouping options set in your main report determine the rows that appear in your summary table. Columns in the summary report are always numeric fields. In order for a summary report to appear, your main report must have Grouping options set. Also, one or more numeric fields must have at least one of the Totals and averages options turned on in field property settings. (Read about configuring numeric fields.) If numeric fields use both those options in your report, two summary tables appear: one that shows totals and one that shows averages.
   Display only new or changed records	Options	Select this option if you want the report to contain only records that have been added () or changed () since a user's flags were last cleared.
   Allow editing records from this report	Options	Select this option to hide all edit buttons ( or ) in your report.
   Allow viewing records from this report	Options	Select this option to hide all view buttons ( or ) in your report.

8. If you want, create a calculated (formula) column for the report. To do so you must choose Custom columns in the Columns section, then turn on the Define a calculated column checkbox.
   Adding a calculated column brings the power of QuickBase formulas to report design. Read why you'd want to add a custom column and learn how.

9. If you want, color code records in your report according to their values using Highlight records based on criteria. For instance, highlight all high priority items in yellow. You set this up using a simple QuickBase formula. Read how.

10. When you're done, click Display to view the results of your modifications. If you don't like the results, click the Customize button at the top of the page to return to the Report Builder.

11. Save the report. To do so, you will need to supply a name for the report, and whether you're saving the report as Personal (only you can view it) or Common (others can view it).

    • If you've displayed the report, you can save without returning to the Report Builder. To do so, go to the prompt by the report title and click Save as.  

    • To display and save at the same time from within the Report Builder, click Save.

    About saving Common reports:
    You can only save a common report if the manager of the application has granted you permission to do so. When you save a common report, you don't need to allow absolutely everyone access to it. QuickBase prompts you to select the roles that should see it. To share with all application users, select All Roles. (An Application Manager can change which reports a particular role can access at any time. To learn how, see Specifying Which reports a User Can Access.) To help others understand what your report shows, type in a description. If you want the description to display above the report, turn on the Show description on report page checkbox.

Once you've created your report, it's easy to manage. You can modify a table report at any time. You don't even need to open it in the Report Builder! Add a column, change sort order, move columns around. Read more on editing reports.

Related Topics

• What is a report?

• Create a new report from scratch

• Create a new report

• Using a Custom Column in a report

• Delete a report

• Copy a report to use as the basis for a new report

• Delete a report

• Email a report

• Subscribe to a report

• Change the field order in an existing report