Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki Unable to 'Group' data column
    • Sign In
    • -OpenGround Wiki
      • -Applications
        • +Admin Portal
        • +Civil 3D Extension
        • +Data Collector
        • +Data Entry Module
        • -Excel Extension
          • Excel Extension Release Notes
          • +Excel Extension How Tos
          • +Excel Extension FAQ's
          • -Excel Extension Common Issues
            • Error when generating a report that contains a summary page
            • Excel opens multiple windows on loading the Excel Extension
            • The Excel Extension menu seems to be locked - sheet open in separate instance
            • Unable to 'Group' data column
          • +Excel Extension User Guide
        • +Launcher
        • +OpenGround Professional
        • +Portal Technical Preview
        • +Power BI Connector
        • +Template Studio
        • +Upload Portal
        • +Web API and Task Service
        • +Web Portal
      • +Guides and Learning
      • OpenGround Supported Platforms
      • +How To Contact Support
      • Component Center
      • Events
      • Training Guides
      • +Developer Resources

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

    Unable to 'Group' data column

    Issue Summary

    When reviewing items in the data selection panel the option to 'Group' a column of data is not available.

    Resolution

    Items when are set to be 'Long Text' in the configuration settings are not available for grouping. Usually, this property should be reserved for lengthy text such as geological or sample descriptions, or location remarks. These are not appropriate for grouping.

    In most cases where this is likely to cause an issue the required data column should be set to 'ShortText':

    1. Login to OpenGround using an account with sufficient privileges and select the 'Manage Model' under the Configuration Pack or perhaps the project as appropriate.

    2. 'Edit' both the affected grid and then the appropriate column to review the settings.

    3. Change the 'Display Type' from 'LongText' to 'ShortText' and 'Save' the changes.

    4. Restart the Excel Extension and continue with template design.

    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Mon, Mar 22 2021 12:09 PM
    • Stephen Evason Last revision by Bentley Colleague Stephen Evason
    • When: Wed, Mar 24 2021 7:11 AM
    • Revisions: 2
    • 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