Report manager - References list extraction

Hi Antonio,

Antonio Commone said:

Now I wolud like to have a table sorted like the original hierarchy

Technically, the hierarchy (both order and nesting) is not maintained anywhere as data structure, which makes the situation a bit more complex.

Whereas the nesting information is simple, because it's defined by "what reference is attached in what model" (and it leads to recursive algorithm), the order is defined only by the attachments definition position in design file (in other words, in what order the model were attached and written to files).

Antonio Commone said:

is it possible?

As Barry Lothian wrote already, it's not supported by MicroStation CE reports.

There are two reason: As I mentioned, there is no such data structure available, that can be used as the report input. The second is, that even when the latest Update 16 offers (as Technology Preview) tables aggregation, it does not support it in a recursive nested way (it's not Excel ;-)

I agree with Barry Lothian and Jon Summers that VBA is the way to go (I do not assume NET addin or C++ application is what you prefer over VBA).

To iterate through attached references is simple recursive process, but a question is what is expected output? To write e.g. csv file is demonstrated in Jon's example, but if you want to e.g. create specifically formatted table and to place it into DGN file, VBA is not enough.

Regards,

  Jan

Hi Antonio,

Antonio Commone said:

Now I wolud like to have a table sorted like the original hierarchy

Technically, the hierarchy (both order and nesting) is not maintained anywhere as data structure, which makes the situation a bit more complex.

Whereas the nesting information is simple, because it's defined by "what reference is attached in what model" (and it leads to recursive algorithm), the order is defined only by the attachments definition position in design file (in other words, in what order the model were attached and written to files).

Antonio Commone said:

is it possible?

As Barry Lothian wrote already, it's not supported by MicroStation CE reports.

There are two reason: As I mentioned, there is no such data structure available, that can be used as the report input. The second is, that even when the latest Update 16 offers (as Technology Preview) tables aggregation, it does not support it in a recursive nested way (it's not Excel ;-)

I agree with Barry Lothian and Jon Summers that VBA is the way to go (I do not assume NET addin or C++ application is what you prefer over VBA).

To iterate through attached references is simple recursive process, but a question is what is expected output? To write e.g. csv file is demonstrated in Jon's example, but if you want to e.g. create specifically formatted table and to place it into DGN file, VBA is not enough.

Regards,

  Jan