Syndicate content


Create a summary report using the "percentage of total" option. To learn more, please see our Create a Summary or Crosstab Report help topic.

February 5th, 2009 - 6:02 PM

The "Edit" and "Display" Icons shown in table reports can be displayed in one of two styles: Descriptive or Small

This is a user-defined setting, effective for all applications with which user interacts, and is controlled via the User Preferences for each user.  

February 5th, 2009 - 6:02 PM

1. Open the table containing the report.
2. Click Reports & charts. A listing of the reports on the table appears.
3. Choose the report you're looking for. If you look in the address bar of your browser you'll see the query identifier as the last numeric portion of the URL.

For example:

February 5th, 2009 - 6:02 PM

Create a report with a custom formula column of type "Text". Use the following formula:

Case(DayOfWeek([Your Date Field's Name]), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday")

Then sort and group on the custom column.

February 5th, 2009 - 6:02 PM

In order to show a portion of a particular field's data on a report and/or form, you need to take these two steps:

1) Create a new formula field that will hold the subset of the original field's data, and

2) Add the new formula field to the forms and reports where you want the condensed field showing.

February 5th, 2009 - 6:02 PM

Just create a Formula URL field and use the following as its formula:

"javascript:if(confirm ('Are you sure you want to delete this record?')){location.assign('/db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]& "&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=q&qid=7")) & "')}"

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