Bug Report Q487923
Visible to All Users

OLAP mode - Empty data cells are displayed when a dimension includes a large number of grouping values

created 12 years ago

When I add a field with a lot of values, the PivotGrid displays empty total cells (fig. 1), but If I apply a filter on these values everything works fine (fig. 2, filter by [Num documenti].[Anno]).

This behavior not depends on the data source because with the v57 the problems doesn't happen. I think it could depend on the large amount of attribute values on rows but I don't know the real cause.

Images and .CUB file in attachment.

Thank you.

Answers approved by DevExpress Support

created 12 years ago (modified 12 years ago)

We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

    created 12 years ago (modified 12 years ago)

    Hello,
    You are right, this behavior is caused by the PivotGrid limitation. If you run this project in IDE in debug mode you will see the exception "Rowsets cannot contain more than 2048 columns".

      Show previous comments (1)
      DevExpress Support Team 12 years ago

        Hello,
        I am afraid that I do not see any workaround for now. Thus, I kindly ask you wait while our developers are examining the issue. Perhaps, they will be able to find a solution soon.

          Still no fix available? I need a solution ASAP.
          Thank you.

          DevExpress Support Team 12 years ago

            Hello,
            Our developers are working on this issue right now. I believe it will be fixed in several days.

            Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

            Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.