Report designs

ActivReporter includes numerous reports designed using Crystal Reports. You can use built-in reports as is, you can modify them to suit your specific needs, or you can design your own custom reports.

A new "Word" report design type was introduced in ActivReporter 8.19-0. Microsoft Word, a document editing platform familiar to most users, can be used to create custom report designs. See the section below labeled "Microsoft Word report designs" for instructions specific to creating and using Word report designs.

Report designs are managed from the Output tabs of the report wizards.

Crystal report designs

ClosedAdd a Crystal report design

  1. Start the report wizard for the report you want to add a design for.
  2. Select the Output tab.
  3. Click . The Report Designs dialog box opens.

  4. Enter a Name for the report design you are adding.
  5. In the Type field, select "Crystal".

  6. Click in the region to the right of the Type field to open the Load dialog box.

  7. Navigate to the folder where the report design is stored and click on the file name to select it.
  8. Click Open.
  9. Click Save to load the new design in the Report Design list box.

Note

After a report design is named and saved, it becomes available for use in report profiles.

ClosedAdd a Crystal report design by dragging and dropping

  1. Start the report wizard for the report you want to add a design for.
  2. Select the Output tab.
  3. Click . The Report Designs dialog box opens.

  4. Enter a Name for the report design you are adding.
  5. In the Type field, select "Crystal".

  6. Open File Explorer and navigate to the folder that contains the report design you need to add.
  7. In File Explorer, click on the file name, drag the file to the area labeled "Click or use drag & drop to add a report design file" in the Report Designs dialog box, and release the mouse button.

  8. Click Save to load the new design in the Report Design list box.

Note

After a report design is named and saved, it becomes available for use in report profiles.

ClosedSave a Crystal report design to a file

  1. Start the report wizard for the report with the report design you want to save to a file.
  2. Select the Output tab.
  3. Click . The Report Designs dialog box opens.

  4. In the Report Design list box, highlight the report design to save to a file.
  5. Select > Tools > Save Design to File. The Save As dialog box opens.

  6. Navigate to the folder where you want to save the file.
  7. In the File name field, enter a name for the report design file. (The file extension will be .rpt.)
  8. Click Save. ActivReporter saves the file to the designated location.

ClosedExport a Crystal report design's XML schema

  1. Start the report wizard for the report with the XML schema you want to export.
  2. Select the Output tab.
  3. Click . The Report Designs dialog box opens.

  4. In the Report Design list box, highlight the report design to export the XML schema for.
  5. Select > Tools > Export XML Schema File. The Save As dialog box opens.

  6. Navigate to the folder where you want to save the XML schema.
  7. In the File name field, enter a name for the XML schema. (The file extension will be .xsd.)
  8. Click Save. ActivReporter saves the XML schema to the designated location.

Note

If the report you are exporting has one or more subreports, you will be prompted to save each subreport individually.

ClosedDelete a Crystal report design

  1. Start the report wizard for the report that has the design you want to delete.
  2. Select the Output tab.
  3. Click . The Report Designs dialog box opens.

  4. In the Report Design list box, highlight the report design to delete.

  5. Select > Edit > Delete. ActivReporter prompts you to confirm that you want to delete the design.

  6. Click Delete.

Microsoft Word report designs

ClosedAdd a Word report design

  1. Start the report wizard for the report you want to add a design for.
  2. Select the Output tab.
  3. Click . The Report Designs dialog box opens.

  4. Enter a Name for the report design you are adding.
  5. In the Type field, select "Word".

  6. Click in the region to the right of the Type field to open the Load dialog box.

  7. Navigate to the folder where the report design is stored and click on the file name to select it.
  8. Click Open.
  9. Click Save to load the new design in the Report Design list box.

Note

After a report design is named and saved, it becomes available for use in report profiles.

ClosedAdd a Word report design by dragging and dropping

  1. Start the report wizard for the report you want to add a design for.
  2. Select the Output tab.
  3. Click . The Report Designs dialog box opens.

  4. Enter a Name for the report design you are adding.
  5. In the Type field, select "Word".

  6. Open File Explorer and navigate to the folder that contains the report design you need to add.
  7. In File Explorer, click on the file name, drag the file to the area labeled "Click or use drag & drop to add a report design file" in the Report Designs dialog box, and release the mouse button.

  8. Click Save to load the new design in the Report Design list box.

Note

After a report design is named and saved, it becomes available for use in report profiles.

ClosedAdd a content control to a Word design

Content controls are the conduit for adding data from ActivReporter to your Word report designs. The instructions below explain how to add a single content control to a Word document. You can build upon this knowledge to add numerous fields and even data tables to your designs.

ActivReporter currently supports three content control types: rich text , plain text , and check box . You can access the content controls from the Controls section of the Developer tab.

To insert a content control:

  1. Open a blank Word document.
  2. Save the document in a convenient location with a descriptive name.
  3. Associate the Word document with a document design by following either the "Add a Word report design" procedure or the "Add a Word report design by dragging and dropping" procedure above. Leave the Report Design dialog open.
  4. In Word, if the Developer tab is not visible, enable it. Expand this link to learn how.
    1. Select the File tab.
    2. In the navigation area, click Options. The Word Options dialog opens.

    3. Select the Customize Ribbon tab.
    4. In the Customize the Ribbon field, ensure "Main Tabs" or "All Tabs" is selected.
    5. In the list box below the field, scroll to find the "Developer" option.
    6. Mark the "Developer" checkbox.

    7. Click OK to close the dialog. The Developer tab is added to the ribbon.

  5. Select the Developer tab.
  6. In the Word document, locate the cursor at the position in the document where you want to insert the content control.
  7. Click the icon for the content control you want to insert in the document. For illustration, this procedure will use a rich text control. A placeholder is inserted in the document.

  8. With the content control selected, click Properties in the Controls section of the Developer tab. The Content Control Properties dialog box opens.

    While all other fields in the dialog are optional, an entry is required in the Tag field in order to link the content control in Word with the data in ActivReporter. In the next few steps, we'll learn how to determine what to enter in the Tag field.

  9. Return to the Report Design dialog in ActivReporter, ensuring that the report design you added in step 3 is selected in the Name list.

  10. In the Document Tables table, give focus to the Fields cell in the first row and press F2. The Report Fields list box opens.

  11. From the dropdown, select "Word Content Control Tags".

  12. Browse the list to locate the tag that represents the information you want to load in the content control and highlight it. For this illustration, we'll highlight "{Report.FormattedAccount}".
  13. With the tag highlighted, press Ctrl+C to copy the tag.
  14. Back in Word in the Content Control Properties dialog, paste (Ctrl+V) the tag in the Tag field.

  15. Click OK.
  16. Save and close the Word document.
  17. Back in the Report Design dialog, click and browse or drag and drop to update the association between the Word document and ActivReporter.
  18. For the illustration, we'll mark the Grouping checkbox.
  19. Save the report design.
  20. Dismiss the Report Design dialog to return to the report wizard.
  21. On the Output tab in the Design field, select the report design just created.
  22. In the menu, select Preview > Preview to PDF.

ClosedAdd a table with content controls to a Word design

  1. Open a blank Word document.
  2. Save the document in a convenient location with a descriptive name.
  3. Associate the Word document with a document design by following either the "Add a Word report design" procedure or the "Add a Word report design by dragging and dropping" procedure above. Leave the Report Design dialog open.
  4. In Word, if the Developer tab is not visible, enable it. Expand this link to learn how.
    1. Select the File tab.
    2. In the navigation area, click Options. The Word Options dialog opens.

    3. Select the Customize Ribbon tab.
    4. In the Customize the Ribbon field, ensure "Main Tabs" or "All Tabs" is selected.
    5. In the list box below the field, scroll to find the "Developer" option.
    6. Mark the "Developer" checkbox.

    7. Click OK to close the dialog. The Developer tab is added to the ribbon.

  5. In the Word document, locate the cursor at the position in the document where you want to insert the table.
  6. Select the Insert tab.
  7. Click Table and move the cursor over the grid until you highlight the number of rows and columns you want.

    If you want to include headings in the table, be sure to include one row for headings and one row for the data template. ActivReporter always expects the data template for a table to appear in the last row of the table.

  8. Once you reach the rightmost and bottommost box of your selection, click to add the table to the document.

  9. Hover over the table until the table selector is visible, then right-click and select Table Properties from the context menu. The Table Properties dialog box opens.

  10. Select the Alt Text tab.

  11. In the Title field, enter a name for the table. Remember the name; you will enter it in the ActivReporter Report Design window to associate the table with the design.
  12. Click OK.
  13. In the top row of the table, enter and format headings as desired.

  14. Select the Developer tab.
  15. In the table, locate the cursor in the cell where you want to insert a content control.
  16. Click the icon for the content control you want to insert into the table. For illustration, this procedure will use rich text controls. A placeholder is inserted in the table cell.

  17. With the content control selected, click Properties in the Controls section of the Developer tab. The Content Control Properties dialog box opens.

    While all other fields in the dialog are optional, an entry is required in the Tag field in order to link the content control in Word with the data in ActivReporter. In the next few steps, we'll learn how to determine what to enter in the Tag field.

  18. Return to the Report Design dialog in ActivReporter, ensuring that the report design you added in step 3 is selected in the Name list.

  19. In the Document Tables table, give focus to the Fields cell in the first row and press F2. The Report Fields list box opens.

  20. From the dropdown, select "Word Content Control Tags".

  21. Browse the list to locate the tag that represents the information you want to load in the content control and highlight it. For this illustration, we'll highlight "{Report.FormattedAccount}".
  22. With the tag highlighted, press Ctrl+C to copy the tag.
  23. Back in Word in the Content Control Properties dialog, paste (Ctrl+V) the tag in the Tag field.

  24. Click OK.
  25. Repeat steps 15-24 for each content control you need to add to the table.

  26. Save and close the Word document.
  27. Back in the Report Design dialog, click and browse or drag and drop to update the association between the Word document and ActivReporter.
  28. For the illustration, we'll mark the Grouping checkbox.
  29. When you mark the Grouping checkbox, the Fields field is enabled. Press F2 to use the Report Fields list box to select and copy the fields to group the report data by. You can use Ctrl and/or Shift selection to select multiple fields.
  30. Paste your selection(s) in the Fields field. For this illustration, we'll group by "JournalEntry".
  31. In the Document Tables table in the Title column, enter the name you assigned to the Word table in step 11.
  32. In the Fields column, press F2 to use the Report Fields list box to select and copy the fields to group the table data by. You can use Ctrl and/or Shift selection to select multiple fields.
  33. Paste your selection(s) in the Fields column. For this illustration, we won't group the table data.

  34. Save the report design.
  35. Dismiss the Report Design dialog to return to the report wizard.
  36. On the Output tab in the Design field, select the report design just created.
  37. In the menu, select Preview > Preview to PDF.

Report data

In the past, the data available to a report was limited to the data that AccountingWare's developers made available. If there was enough clamor for more data, occasionally developers would provide an "extended view" with additional data for custom reporting. With ActivReporter 8.21-0 and the introduction of data sources and data extensions, users can define for themselves the data that is available to a report (within reason, of course).

ClosedAdd a data extension to a report design

  1. Start the report wizard of the report for which you want to augment the data.
  2. If you have not already added a report design for the report you want to create, do so. You cannot directly add an extension to a built-in report. If you want to use a built-in report as the basis for a report design, you can save it with a new name.
  3. In the left-hand pane of the Report Designs window, highlight the report for which to extend the data.

  4. Select the Advanced tab.

  5. In the Name column of the Data Extensions table, select the extension name from the drop-down list of available extensions. Notice that the join conditions for the extension load in the Join Conditions column.
  6. In the Data Source column, select the data source for the report design.
  7. Save your changes.