Format a Project Report

A user may only edit reports they own. To edit a report created by another user, the user will need to first clone the report a folder.

 

  1. Click the Reports icon on the left navigation pane.
  2. The reports pane will open.
  3. Click the arrow beside the folder containing the report to be modified to expand the report tree.

    Click the title of the report, click the three bars icon and select Edit.
  4. To insert or delete a row, click the row number and select Insert Rows Before, Insert Rows After or Delete Rows.
  5. To add the Company Logo, click inside the cell where the logo will reside and click the function key.
  6. In the Search for Functions field, type LoadImage. When function displays, double-click the function to add it to the function statement box.
  7. In the field selector, double-click the Logo field to add to the function statement box and click the OK button to save the function.
  8. To add the Project Name and Project Number to the report, select a cell and enter the following function: = {Projects.Number} & " " & {Projects.Name}
  9. Click your right mouse button on any section to then select Add Section such as Page Header, Report Header, Report Footer, Page Footer, Group Header, Group Footer or Repeating Group.

    1. Section Descriptions
      1. Page Header – appears at the top of every page.
      2. Report Header – appears at the beginning of the report.
      3. Detail – appears once for each row of data returned during execution.
      4. Report Footer – Contains summaries for the entire report and appears at the end of the report.
      5. Page Footer – appears at the bottom of each page. Can report on things such as Page #, etc.
      6. Group Header –used as leading or title areas for more detailed information that follows. A report can have multiple group headers for varying levels of data.
      7. Group Footer - used as trailing areas for more detailed information that preceded it. They are mainly used for aggregate data, such as sums and averages. A report can have multiple group footers for varying levels of data.
      8. Repeating Group - used for information that you want to repeat before continuing with other information in the report. Each repeating section can have its own header and footer allowing aggregate values on just the information within the repeating group.
  10. Basic formatting can be performed on the report using the formatting section at the top of the report. Select the cell(s) to be formatted and select the format from the toolbox below:

    1. Format cells
    2. Format print brush
    3. Format font
    4. Bold
    5. Italic
    6. Underline text

    7. Text color
    8. Background color