Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • Hi,
                                    We are doing analysis for migrating our xtraPivotGrid usage into DXPivotGrid at the moment.

                                    We found when trying to "hide" a field in the pivot grid by setting Width property to 0 is not working anymore in the DXPivotGrid.
                                    Seems that you're validating the MinWidth property now in DXPivotGrid.
                                    Now even though this might be considered as correct behavior, however this may break our app.
                                    Can you please kindly advise how I can force "override" the width property? Or suggest any other alternatives of doing this.

                                    The intention is to have some fields in data area/row area/column area, however they are "hidden" from the pivot grid. So that we're still able to get their values on a particular selected cell/row.
                                    You can think this as existing hide/unhide column in excel, but we just need to able to hide programmatically in this case.

                                    Thanks.

                                DXPivotGrid - Hiding Columns with Width setting is...e.xlsx
                                0

                                Hi Bembeng,

                                We are currently looking into your issue and will get back to you once we have any results. Please bear with us.

                                Thanks,
                                Alex

                                0

                                Hello Bembeng,

                                Thank you for your question. If I understand it correctly, you want to access data source field values, corresponding to the specific Field Value. If my assumption is correct, you can accomplish this task without creating hidden fields. Simply use the PivotGridControl.CreateDrillDownDataSource method to get the list of all corresponding data source records and get required values via the provided interface. Please try this solution and let me know your results.

                                Thanks,
                                Constant

                                0

                                Hi Constant,
                                I have attached the example of usage for the hidden column in the excel file.

                                Thanks for the suggestion, one thing that I found with the suggestion:
                                In order to get the amount for the hidden fields, now I have to go into the drill down first to get the raw data for that dimension then sum the numbers for the "hidden" fields. This might work but introduce 2 additional steps in the process rather than just directly getting the available "hidden" cells as we're doing in the winform version.
                                If you look into the attached example, you'll find that we're evaluating the formatting for each cell, so I can imagine if we need to perform create drill down then sum up for each cell, this can be pretty bad on the performance side, where we actually have this kind of formatting applied not only to 1 particular field, but can be 3-4 fields at the same report. (imagine 3 different sales columns with any discount given columns for each respectively).

                                This is pretty common on a normal datagrid usage, but I would think that this is probably common scenario in the pivot grid? where we evaluate the formatting not based on the existing cell value, but from other cell which may not be meaningful to the users hence we're hiding it.

                                Thanks for the suggestion, I'll probably look into this first for the time being to see the performance impact, but I'll be happy if you have any other suggestion to achieve what we're trying to do without using hidden columns.

                                Example of hidden column usage.xlsx
                                0

                                Hello Bembeng,

                                Thank you for the clarification. I understand your requirements. However, I need to discuss this behavior with our developers, so I will still leave this report as active. We will answer you as soon as possible. We are sorry for the delay.

                                Thanks,
                                Constant

                                0

                                Hello Bembeng,

                                Thank you for your clarification. You can use the PivotGridControl.CustomFieldValueCells event to hide specific columns. I have created a sample project that demonstrates this approach. You will find it in the attachment. Please note that this approach is even better than setting the width property to 0, because it does not corrupt keyboard navigation.

                                Thanks,
                                Constant

                                dxSample.zip
                                0

                                Thanks Constants.
                                Just want to say that you guys have been really helpful and very responsive to all of the queries, totally solid support system ;)

                                0

                                You are welcome, Bembeng

                                I am happy to hear that my assistance was helpful for you. Thank you for informing me. Actually, our customers' warm words are the best reward for all of us.
                                Please feel free to contact us if you have any further difficulties. We are happy to help you at any time.

                                Thanks,
                                Constant

                                0

                                Hi Constant,
                                Thanks for this, just managed to try this out and it works great.
                                There is just one minor thing: data2 is still being displayed in the data header area.

                                We used to work this around in xtraPivotGrid by using CustomDrawFieldHeader event to set 0pt rectangle and set the caption to empty.

                                I understand that we can use the ShowDataHeaders property to hide the field captions, but the major drawback is the user will not be able to add/remove/reorder the data fields, although we can still achieve the same with Show Field List (Customization Form), just additional steps is needed.

                                Can you please kindly advise whether there's any good solution for this.
                                Thanks.

                                Hidden Field Caption still in the Data Header Area.JPG
                                0

                                Hello Bembeng,

                                Thank you for your update. I am afraid the DXPivotGrid control does not provide a capability to hide specific field headers. I recommend you hide all corresponding areas and use the Excel 2007 style form to allow your user to modify layout. Does this solution is suitable for you?

                                Thanks,
                                Constant

                                0

                                Hi Constant,
                                Yeah, that's the approach that I'm going to propose for now, it's a behavior change but since the customization form is a pretty nice interface, I hope the users will be happy with this :)
                                Thanks Constant, you have provided a nice solution for hiding the data cells which is much more important :)

                                0

                                Hello Bembeng,

                                I am glad to hear that this solution is suitable for your. However, going back to the beginning, I would like to ask whether you profile the performance when the CreateDrillDownData source method is used to calculate values from hidden fields? It seams strange to me that you have faced a performance issue caused by this method. I believe that the CreateDrillDownDataSource method is the best choice in this situation. If you experience any difficulties with using it, I would like to help you solve them and make your future experience with the DXPivotGrid control better.

                                Thanks,
                                Constant

                                0

                                Hi Constant,
                                To be honest, I didn't get a chance to test the DrillDownDataSource alternative, so I'm not too sure on the performance side of it.
                                I'll let you know if we need to go with that route in the end.
                                Thanks.

                                0

                                Hello Bembeng,

                                Thank you for your update. Usually, you can use the DrillDownDataSource feature without any performance penalty or using additional memory.
                                Please feel free to contact us if you need any additional assistance regarding this. We will be happy to help you.

                                Thanks,
                                Constant

                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners