Reports

Syndicate content

Print settings are controlled mainly by your web browser. To read some tips for printing QuickBase reports and screens, please see our Print a Report and Print a QuickBase Screen help topics.

November 7th, 2011 - 11:11 AM

As long as there is a common link between the table on which you want to embed the report and the  table that contains the records you want to display, this process is simple.

Consider the example below. The application track projects across the business unit and is made up of three tables: Projects, Tasks, and Documents. You establish these relationships:

January 10th, 2011 - 4:01 PM
Tags:

You can limit a report to only show the top 5 records by adding this string to the end of the URL you see while viewing the report.

> &qskip=0&qrppg=5

You can replace 5 with another number to return a different amount of records. Be aware this will only work for table reports.

June 2nd, 2009 - 2:06 PM

1. Create a new report that includes all of the fields that you want to include in your mailing labels, form letter or envelopes. Expand the "COLUMNS TO DISPLAY" section and turn on only the columns that you need for your mail merge. Turn off all unnecessary columns.

February 5th, 2009 - 6:02 PM

1. In a new report or an existing one, create a custom calculated column. To do so, click on 'Custom columns' in the 'Columns' section. Once you've added all the columns you'd like to display on the report, check off the box next to 'Define a calculated column.'

In the expanded area of this section, set the field 'Type' to 'Checkbox.' Enter the following in the Formula box:

February 5th, 2009 - 6:02 PM

To accomplish this, you'd design your report with a custom formula field that combines values in all three contact fields and then (though they won't know it) let users search that field.

February 5th, 2009 - 6:02 PM

For reports with grouped data, clicking a column heading sorts the data within each group based on the selected column. It does not change your groupings.

February 5th, 2009 - 6:02 PM

QuickBase doesn't set the width of columns in reports. Since the program has no way of knowing what font and font size a user's browser is configured to, we leave it to the browser to determine the appropriate widths for each column and the appropriate width for the entire report. Usually the browser does a pretty good job of this.

February 5th, 2009 - 6:02 PM

1. In a new report or an existing one, create a custom calculated column. To do so, make sure that 'Custom columns' is selected in the 'Columns' section. Once you've added the normal columns you'd like to appear on the report, check off the box next to 'Define a calculated column.'

Set the field 'Type' to 'Duration,' and enter the following in the Formula box:

February 5th, 2009 - 6:02 PM

1. Choose a table from the Table bar.
2. Click REPORTS & CHARTS to open the reports panel, then click + New.
3. In the dialog, select Table and click Create.
4. In the Columns section, choose Custom columns and click and drag each column you want to include under Report columns.
5. Check Define a calculated column.

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit