[MSCE U17] Advanced Settings: define how report should populate data in seed table.

Introduction

MicroStation U17 provides more control on populating data from report to MicroStation tables via seeds using “Advanced” setting (tech preview feature).

How to enable this feature?

After selecting a Seed and a Report, user can click the “Advanced” button to open Advanced setting dialog:

This dialog includes 5 groups. The first group is showing the Table Seed Name, Report Category, and Report Definition Name. Users can change the options of the other 4 groups "Title Row", "Header Row", "Body Rows", and "Summary Row" to generate a table with different data sources and specified starting row & cell. The selected row number is from the seed table, not the newly created table.

Video for using the settings dialog:


Steps for using the Advanced settings:

  • Create a table in the seed file(dgnlib file)
    1. Row 1 and 2 are Title rows;
    2. Row 3 is Header row;
    3. Row 4 and 5 are Body rows;
    4. Row 6 and 7 are Summary rows;

  • Create a Report Definition

  • Click on the Advanced icon

The settings dialog is prompt, and the settings are set to default values if it is the first collaboration time for the specified Seed and Report. 

Group “Title Row” shows how users fills the Title row.

a) If the user selects “No” in “Use Title From Report”, then the contents of Title rows remain. If the user selects “Yes”, then the contents of Title rows are from Report.

    

    If there is content in the Title Row of the selected seed, the default value of "Use Title From Report" is "No", otherwise it is "Yes".

b) If the user selects “Yes” in “Use Title From Report”, then the user can select a row which will be filled with data from Report.

    

c) After the user has selected “Yes” in “Use Title From Report” and selected a row in “Selected Title Row”, the user can also select a starting cell from Title Row if there are more than 1 cell in the selected row.

    

Group “Header Row” shows how user fill the Header row. It is similar with “Title Row”.

a) If user select “No” in “Use Column Headers From Report”, then the contents of Header rows remain. If user select “Yes”, then the contents of Header rows are from Report.

If there is content in the Header Row of the selected seed, the default value of "Use Column Headers From Report" is "No", otherwise it is "Yes".

b) If the user selects “Yes” in “Use Column Headers From Report”, then the user can select a row which will be filled with data from Report.

c) After the user has selected “Yes” in “Use Column Headers From Report” and selected a row in “Selected Header Row”, the user can also select a starting cell from Header Row if there are more than 1 cell in the selected row.

Group “Body Rows” shows how users fill the Body rows.

a) user can select a row as “Starting Body Row”, then the report data will be filled in the table starting from the specified row. The default value of Starting Body Row is the first empty body row.

b) After the user has selected a specified row as starting body row, the user can also select a starting cell from Body Row if there are more than 1 cell in the selected row.

Group “Summary Row” shows how users fill the Summary row. It is similar to “Title Row”.

a) If the user selects “No” in “Use Summary Row From Report”, then the contents of Summary rows remain. If the user selects “Yes”, then the contents of Summary rows are from Report.

If there is content in the Summary Row of the selected seed, the default value of "Use Summary Row From Report" is "No", otherwise it is "Yes".

b) If the user selects “Yes” in “Use Summary Row From Report”, then the user can select a row which will be filled with data from Report.

c) After the user has selected “Yes” in “Use Summary Row From Report” and selected a row in “Selected Summary Row”, the user can also select a starting cell if there is more than 1 cell in the selected Summary row.

In the end, let’s have a look at the different results with different settings :

1.

 

2.

Users can also try to change it to different settings to get different results.

AdvancedSettings.zip