Read more

Report Items By Line Number in Plant 3D

The other day a client needed a report of items by Line Number.  A common way to get the report would be to group by the PipeRunComponent_LineNumberTag.  That report ends up excluding all fasteners. So, the typically, an incorrect report by line number would look something like this: Noticing the Group and Sort panel at […]

Read more

Nozzle Reports for AutoCAD Plant 3D

This entry is part 1 of 2 in the series Creating a Nozzle Report

This entry is part 1 of 2 in the series Creating a Nozzle ReportOne client asked how to create nozzle reports in the Report Creator.  While you can easily print out a list of nozzles, the out-of-the-box setup doesn’t give you a way to view the Equipment tag. Special thanks to Ken Fauver for coming […]

Read more

Sharing SQL Queries

  Today I wanted to post a tip on how to share queries.  Often users or the PDOTeam will post a query and we want you to know how to use that in your own project (like the query below).   SELECT [Components-Valves].ID_COUNT_, [Components-Valves].DWG_NAME_, [Components-Valves].SIZE_, [Components-Valves].SPEC_, [Components-Valves].CW_RES_01_, [Components-Process Lines].TAG_, [Components-Process Lines].SIZE_ AS [Line Size], IIf([Components-Valves]![SIZE_]=[Line […]