Showing rows/columns with empty cells

6 posts, 0 answers
  1. Stephen
    Stephen avatar
    9 posts
    Member since:
    Sep 2010

    Posted 10 Nov 2016 Link to this post

    Hi,

    I am trying to figure out how to show rows and/or columns in the PivotGrid whose cells are empty, so if I have a list of products from an OLAP cube selected, and there are no values for these products with the selected measure(s) - the grid returns no cells and no rows, so I only see the grand total line and nothing else. 

    I would prefer all the selected data to be returned. Most pivot grids have an option to toggle this on or off, but I can't seem to find how to do this on the PivotGrid. 

     

    Can someone please advise? 

     

    Thanks

  2. Kalin
    Admin
    Kalin avatar
    1215 posts

    Posted 14 Nov 2016 Link to this post

    Hello Stephen,

    Thank you for contacting us.

    Can you please share more details regarding the exact scenario you want to achieve? Can you provide a screenshots of our PivotGrid compared to another pivot control that behaves differently? Also is this supported by the pivot in excel, can you please check it? Can you demonstrate this behavior in our online demos (demos.telerik.com/wpf) and share the exact settings, so we can check it on our side.

    I'm looking forward to hearing from you.

    Regards,
    Kalin
    Telerik by Progress
    Do you need help with upgrading your WPF project? Try the Telerik API Analyzer and share your thoughts!
  3. Stephen
    Stephen avatar
    9 posts
    Member since:
    Sep 2010

    Posted 17 Nov 2016 in reply to Kalin Link to this post

    Hi Kalin, 

     

    Please find the screenshots attached. They show the RadPivotGrid with rows that have data, then what happens when I select a measure with null values for all selections. I've also added screenshots using an Excel pivot grid OLAP connection, with the same output, i.e. one with data, and one without data. 

    There is also a screenshot of the selection in the Excel PivotGrid that allows you to enable showing empty rows or columns, and how it looks once it has been selected. 

     

    Hope that helps. 

     

    Thanks,

    Stephen

  4. Kalin
    Admin
    Kalin avatar
    1215 posts

    Posted 22 Nov 2016 Link to this post

    Hello Stephen,

    Thanks for the details. However we will need some more time in order to investigate the scenario.

    Will get back to you as soon as possible.

    Regards,
    Kalin
    Telerik by Progress
    Telerik UI for WPF is ready for Visual Studio 2017 RC! Learn more.
  5. Stephen
    Stephen avatar
    9 posts
    Member since:
    Sep 2010

    Posted 22 Nov 2016 in reply to Kalin Link to this post

    Hi Kalin, 

     

    I look forward to your response once you've had time to examine it. 

     

    Could you please open up a support ticket for this issue and add nemanja@pyramidsoftware.co.za as a cc to the issue so that we can be fully up to date when you do have a proper look at it? 

     

    Thanks,

    Stephen

  6. Kalin
    Admin
    Kalin avatar
    1215 posts

    Posted 23 Nov 2016 Link to this post

    Hello Stephen,

    Actually this is a feature that is available for the other providers and we already have it logged in our Feedback portal as a Feature Request. You can vote for it and track its status on the following link:
    https://feedback.telerik.com/Project/143/Feedback/Details/201206-pivotgrid-add-options-for-showing-items-with-no-data-when-using-olap-data-provid

    If you have any other questions or concerns, please let us know.

    Regards,
    Kalin
    Telerik by Progress
    Telerik UI for WPF is ready for Visual Studio 2017 RC! Learn more.
Back to Top