To make most changes to your report, you never even have to leave the report itself.
If your report is a Table report, you can modify it by manipulating elements directly on the report. QuickBase lets you add, remove and change columns without leaving the report display. See your layout changes as you make them! To modify other types of reports or to access some advanced controls (like matching criteria) you need to make changes within the Report Builder. The Report Builder offers more features, so if you don't see a way to do what you want from within the report itself, click the Customize this Report link on the Page bar.
Note: If you are viewing a report on a table Home page (the title in the page bar will read Table Home), many of these options are not available. To edit the report, click REPORTS & CHARTS in the Page bar, and open the report.
Tip: Any user can edit and/or save a report. But only those with "Save Common Reports" access permissions can save changes or create reports that are available to other application users. However, any user can save a personal report, which is visible only to themselves. Read more.
QuickBase lets you modify your report directly on the report display itself. You can:
Move a column. Click
on a column heading and drag the column to the desired location. QuickBase outlines the column heading in yellow.
Click and drag it to the new location, which is indicated in green.
Hide a column. Click on a column heading menu , then select Hide this column.
Add a column. Click on a column heading menu , then select Add a column. Choose a field (or fields—you can select more than one) from the list that displays. QuickBase inserts the column(s) to the right of the column you clicked on.
Tip: If you want, add a field from another table! You can create and display a lookup field here in one stroke. Read more about lookup fields.
Change the sort order and set grouping options. Want to order your list according to the values in a particular field? Click on a column header to sort by that column. To group on the values in a particular field, click on a column heading menu , then select Group A to Z or Group Z to A
(These menu options reflect the values in the field. So, if you click on a numeric type field the option would read Group low to high. Likewise, if you select a date type field the option reads Group oldest to newest.) Read more about sorting and grouping.
Add a related column. If the table you're viewing is part of a relationship, you can easily draw in a lookup field from a master table. For instance, you may want to display an email field alongside the task table's Assigned To field. To do so, click on a column heading menu for a field that's part of the relationship, then select Add a column. QuickBase displays a dialog to choose fields from a related table. Make your choices and click OK to add the fields to the report. (Read more.)
Set column properties. Use this option to format the way the column displays in this particular report. Click on a column heading menu , then select Column properties. QuickBase displays a dialog box which lets you format the column. You can:
Change the label. Within the Column heading override box, type in the name that you want to display at the top of the column. This name will appear above the column in this report only. The field name remains the same.
Set column alignment. Tell QuickBase exactly how values in a column should line up. Click the Justification dropdown to align values on the left side of the column or the right or to center the label and contents.
Edit this field's properties. Click on a column heading menu , then select Field properties to get behind the scenes and edit the field's properties.
Make a new table based on the current column. Have you found that one table isn't enough? Often application managers find that the information they've been tracking in a field really belongs in its own table. Click on a column heading menu , then select New table based on this column. Read more.
When you've got the report looking like you want it to look, click Save in Page bar. Or, you can save your settings as entirely new report, by clicking Save > Save as. QuickBase prompts you to name the report and specify whether or not it should be a Personal report (which only you can see) or a Common report (available to other application users). If Common report is not an option, then your application manager hasn't granted you permission to save reports visible to other users.
Editing a report on-screen is a fast way to format columns and set ordering. However, the Report Builder offers all the controls you need for precision reporting.
Open the report in the Report Builder. You can do so in one of the following ways:
(Common and Personal Reports) If the report is displayed in your browser, click the Customize this Report link on the Page bar.
(Common reports only) In the table bar, click the table featuring the report. Click REPORTS & CHARTSon the Page bar to display a list of reports for that table. Click the name of the report to open it.
Make the necessary changes. You can set:
When you're done, click Display to view the results of your modifications. If you don't like the results, click the Customize this Report link again to make further edits.
When you are satisfied with how the report looks, save it by doing one of the following:
If you've displayed the report, you can save without returning to the report builder. To do so, click Save above the report. Or if you want to save your changes as an entirely new report, click Save > Save as.
To display and save at the same time from within the Report Builder, click Save in the Page bar.
Tell QuickBase how to save the report.
Whenever you save a report, QuickBase displays a dialog box.
If you want to save the report for your reference only, type in a name and select the Personal report radio button. Click OK.
If you want other users to see your report, type in a name, select the Common report radio button and click OK.
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 share it with absolutely everyone. 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, select the Show description when displaying report checkbox.
In certain situations (like when you click a report link field, or when you conduct a Find operation, for example) QuickBase displays results using reporting defaults you specify for each table. You cannot change these defaults by clicking Customize this Report or rearranging columns directly on the screen. When you do so, QuickBase actually creates a new report, but makes no changes to your reporting defaults. You can change reporting defaults, however. Read how.
Return to top
© 1999-2013 Intuit Inc. All rights reserved. Legal Notices.
Open topic with navigation