This is certainly on my (very long) list of “things that Revit really should be able to do by now”. Most design offices resort to a time consuming and error prone method of Excel to produce drawing registers.
It is possible using just Revit’s revisions (no extra sheet parameters) along with Dynamo and a database to produce something similar. I wouldn’t say it is easy or simple- but does have the benefit that a reasonable drawing register can be produced directly from Revit, and takes only seconds to refresh.
The process is basically:
- Using Dynamo, export details of sheets, revisions and mapping between the two to a database
- Join it back together in the database using the IDs, so you have a complete list of all sheets and revisions
- Produce a report from this data. This will dynamically update as the underlying data is refreshed (using Dynamo). I used Excel pivot tables & Access- but could equally be PowerBI or any other reporting tool.
Refer below screenshots:
Sheets
Revisions
Mapping
Joined
Access
Excel
