Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
MicroStation
  • Product Communities
MicroStation
MicroStation Wiki How to run a Report on location of cells and place as a Table
    • Sign In

    • -MicroStation Wiki
      • +Learning Tips
      • -MicroStation
        • +3D Printing - MicroStation
        • +Animation - MicroStation
        • +Archive / Backup - MicroStation
        • +Base Geometry - MicroStation
        • +Batch Processing - MicroStation
        • +CONNECT Advisor - MicroStation
        • CONNECT Integration - MicroStation
        • +CONNECTION Client
        • +Cells - MicroStation
        • +Change Tracking - MicroStation
        • +Configuration - MicroStation
        • +Coordinate Systems - MicroStation
        • +Curves - MicroStation
        • +Custom Linestyles - MicroStation
        • +DGN - MicroStation
        • +DWG - MicroStation
        • +Database - MicroStation
        • +Detailing Symbols - MicroStation
        • +Dimensions - MicroStation
        • +Documentation & Help - MicroStation
        • +Drawing Aids - MicroStation
        • +Exception - MicroStation
        • +FAQ - MicroStation
        • +Feature Based Solids Modeling - MicroStation
        • +File Access - MicroStation
        • +GUI - MicroStation
        • +General - MicroStation
        • +Graphics Display - MicroStation
        • +Groups - MicroStation
        • +Hardware / Input Devices - MicroStation
        • +Import/Export - MicroStation
        • +Installation - MicroStation
        • +Interchange - MicroStation
        • +Interference - MicroStation
        • +Internationalization - MicroStation
        • +Levels - MicroStation
        • +Licensing - MicroStation
        • +Manipulation - MicroStation
        • +Markup / Redline - MicroStation
        • +Measure - MicroStation
        • +Mesh - MicroStation
        • +Models - MicroStation
        • +Multi-Lines - MicroStation
        • +OLE - MicroStation
        • +Other - MicroStation
        • +Parametrics - MicroStation
        • +Patterning - MicroStation
        • +Point Cloud - MicroStation
        • +Printing - MicroStation
        • +Programming - MicroStation
        • +Project Navigation - MicroStation
        • +Properties - MicroStation
        • +RSS Feeds - MicroStation
        • +Reference - MicroStation
        • +Security - MicroStation
        • +Selection - MicroStation
        • +Settings - MicroStation
        • +Sheet Composition - MicroStation
        • +Solids - MicroStation
        • +Standards - MicroStation
        • +Surfaces - MicroStation
        • -Tables - MicroStation
          • Could not obtain data from data source when using Place Table from Excel File
          • How to control the size of initial Table placement
          • How to create Table seed that can be placed as a template into any design.
          • How to import an Excel Spreadsheet as a Table
          • How to run a Report on location of cells and place as a Table
          • How to update Table with modified contents from source file
          • Table option 'Refresh from Data Source' not available
          • Unable to edit Table
          • Why will linked Table not update
        • +Text - MicroStation
        • +UI Customization - MicroStation
        • +Units - MicroStation
        • +View - MicroStation
        • +Visualization - MicroStation
        • Welcome Page - MicroStation
        • +Accreditation - MicroStation
        • +i.Models - MicroStation
        • +ProjectWise Integration
        • +Raster - MicroStation
    • +Administration Wiki
    • +Annotations Wiki
    • +Bentley View Wiki
    • +MicroStation PowerDraft
    • +Printing and Plotting
    • +Programming Wiki
    • +Visualization Wiki
    • Window List Dialog for Missing Tool Dialog Boxes

     
     Questions about this article, topic, or product? Click here. 

    How to run a Report on location of cells and place as a Table

      Product(s): MicroStation
      Version(s): CONNECT Edition
      Environment: N\A
      Area: Tables
      Subarea: N\A

    How to run a Report on location of cells and place as a Table

    Background

    In the following example a user would like to place a Table in the design that will show the location of Street Lights along with their maintenance records ( Item types attached to cell ).

    Steps to Accomplish

    1. Use the Explore Advanced Search to Locate the Parking Light Cells placed in the design

    2. Generate a Report definition from the search

    3. In the Reports dialog ensure 'Search Location' settings are as required.

    4. Under the heading 'Include Items' select the 'Item Types' Cells and add the Related Item 'Element has attached Items' choosing the required attached Item data to include in the Report.

    5. Add Report Columns for the cells attached Item data

    6. Add Columns for the location of the cells and choose the property Cells > Geometry > Origin.

    7. Optional: Having selected the Origin in the last step this will populate the X,Y,Z location of the cells origin in the column, if individual columns are required for each coordinate under a different column heading. Right click on the column heading and select 'Add Formatting' and choose the coordinate required under ' Select Coordinate ' and change the additional formatting as required.

    8. Use the Reports ' Preview Results ' to verify the content is as required, and adjust accordingly

    9. Place the Report as a Table into the design choosing the appropriate Tool Settings.


     

    See Also

    Introduction to MicroStation Connect Edition Item Types

    Introduction to MicroStation Connect Edition Reports

    How to create Table seed that can be placed as a template into any design.

    Table option 'Refresh from Data Source' not available

    Other language sources

      Original Author: Carl Myhill
    • reports
    • explorer
    • MicroStation
    • tables
    • en
    • SELECTsupport.Items
    • 10.03.00.30
    • Share
    • History
    • More
    • Cancel
    • Carl Myhill Created by Bentley Colleague Carl Myhill
    • When: Thu, Jan 5 2017 9:50 AM
    • Andrew Bell Last revision by Bentley Colleague Andrew Bell
    • When: Mon, Jul 6 2020 1:28 AM
    • Revisions: 6
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies