ProjectExplorer 5 for AutoCAD Civil 3D

Tutorials | Generating Quick Reports

Tutorials

Generating Quick Reports

This tutorial demonstrates the use of ProjectExplorer to generate a simple Civil 3D Alignment/Profile report to a PDF file. We then write the same report to a different file format in a few simple steps - to an Excel XLSX file.

Getting Started

In AutoCAD Civil 3D, Open the standard Civil 3D sample drawing: Intro-1.dwg

This drawing is part of the standard Civil 3D installation, and can generally be found in the following folder:

C:\Program Files\Autodesk\AutoCAD 2018\C3D\Help\Civil Tutorials\

Preparing to generate a Quick Report

There are two ways to generate reports in ProjectExplorer. The quickest, easiest way to generate a report of a single element from your Civil 3D model is to use the Quick Report function. Right-click any listed item in the ProjectExplorer window to access the associated Quick Report options.

  1. From the Civil 3D ribbon, select the Add-Ins tab and open the ProjectExplorer window.
  2. From the Alignments tab of the ProjectExplorer window, locate the alignment Second Street, and right-click the associated profile: Finished Grade Centerline - Second Street Design.
  3. Select Quick Report to File from the right-click menu.

The Create Quick Report dialog opens.

Configuring your Quick Report

To generate a Quick Report we need to choose a file type for the report, then configure the content and layout of the report using a Layout Style and a Report Style.

Layout Styles define the heading, visibility, and order of every column of data in the report. The units of numerical values can also be controlled from a Layout Style.

Report Styles define the page formatting, fonts, table style, and header/footer content of outgoing reports.

Layout and Report Styles can be saved and retrieved at any time, but for this tutorial we will define our requirements manually.

  1. Ensure that the File Type drop down list is set to PDF File.
  2. Note that the file name of the outgoing report file can be derived from a series of dynamic variables during the creation process, or you can specify a fixed file name in this dialog. By default, the report file name will be made up of a combination of the drawing name and selected object name.
  3. Change the Layout Style setting to Use custom Layout Style, then press the Edit Layout Style button.

The Layout Options dialog opens.

Layout Style Options

From this dialog we will define the layout of the outgoing report.

  1. In the Alignments tab of the Layout Options dialog, ensure that Configure Column Layout for Alignments/Profiles is selected.
  2. From the list view, ensure that just the first seven columns are checked (Alignment Name, Type, Object Style, Site, Start Station, End Station, Length). We don't want to crowd our outgoing report with too many data columns.
  3. At this point, you may rename or reorder any of the selected columns to match the standards in your organisation. Columns may be renamed by double-clicking on the required label, or by right-clicking and selecting Rename from the right-click menu.
  4. Change the drop-down list in the Alignments tab to Configure Column Layout for Alignment Entities/Points.
  5. From the list view, ensure that just the following columns are checked (Point, Station, Easting, Northing, Elevation, Bearing, Alignment Radius, Gradient, Profile Radius). Rename and reorder any of the selected columns to your own requirements.
  6. From the Alignment/Profile Options controls, set a desired Line, Curve and Spiral interval for the outgoing Quick Report.
  7. Select the General tab and note the options here to set the format of numerical values such as angles/bearings, stations, elevations, and slopes. Changes applied here will only affect the outgoing Quick Report.

Press OK to close the Layout Options dialog and return to the Quick Report dialog.

Report Style Options

Next, we'll specify the style of the outgoing report. Press the Edit Report Style for Quick Reports button. The Report Options dialog opens.

  1. From the Page Options tab, set the Page Size to A4, and the page orientation to Portrait.
  2. From the Font Options tab, set the Preferred Font to Corbel and the font size to 10pt.
  3. From the Table Options tab, set the Header Row Background Color to Pale Yellow, or a colour of your choice.
  4. Optionally, from the Report Header tab, check the Add Image to Header checkbox and press the Browse button to choose a company logo image file from your computer.

Finally, press OK to close the Report Options dialog and return to the Quick Report dialog.

Generate the Report

We are now ready to generate the report. From the Quick Report dialog, press the OK button and choose a path in which to save the PDF report file.

The report is generated. Open Adobe Acrobat to inspect the resulting report file.

If you wish to change the layout or style of the report, right-click the same object in the ProjectExplorer window and select the Quick Report to file option again. Your preferences will be remembered from the previous quick report.

Writing the same report to Excel

From the Alignments tab of the ProjectExplorer window, relocate the alignment Second Street, and right-click the associated Finished Grade Centerline - Second Street Design Profile. Select Quick Report to file from the right-click menu.

The Create Quick Report dialog opens again.

Configuring the report for export to Excel

Change the file type to XLSX file to generate an Excel file.

As we have previously configured our report settings, you can just accept the current layout style and report style, or make some minor adjustments if you wish.

Press the OK button to generate the file.

Open Microsoft Excel to review the output.

Note that three worksheets have been generated in the exported XLSX file. The first worksheet contains the report header. The second worksheet contains the selected object geometry. The third worksheet contains the Report Footer.

To prevent the report header and footer from creating additional worksheets in the exported file, run the Quick Report option again and deselect the Add Fields to Report Header and Add Report Footer options in the Report Style dialog.

ProjectExplorer does not automatically set the width of columns in the exported Excel file. In Microsoft Excel, select the entire worksheet and select Autofit Column Width from the cell formatting options in the Excel ribbon.

You have now completed this tutorial.