Current filter:
                                You should refresh the page.
                                0
                                Alan Parker - Aderant 10.10.2011

                                  • We are developing a SharePoint 2010 WebPart which contains an instance of DevExpress ASPxPivotGrid control. The control is bound to an OLTP cube (Adventure Works DW in sample). The fields are properly allocated across row, column, filter and data areas. The number of rows allowed per page is set to some discrete number.
                                    In the data area we have two fields. The combination of these two fields in data area results in spanning the data over two different pages. That means the pagination control displays two links for navigating between the pages and that works well. It is also note that if a particular field is removed from the data area then it should have data only in the single page.
                                    However, if the user right clicks on that particular field in the data area and hides it using context menu, then even if it should display only single page the pagination control still displays links for both of the pages. If the user clicks on the link for the second page then the page refreshes and after the refresh operation the first page is displayed without a pagination control.
                                    What user should actually expect is the pagination control should vanish by itself immediately when the user hides that particular field, if the resultant data should produce only single page.
                                    Please find the attached sample and video. The cube used for this sample is available at following link

                                    https://skydrive.live.com/redir.aspx?cid=9fabe63781adb7f5&resid=9FABE63781ADB7F5!104

                                    Steps to Reproduce:

                                    1. Open the Web Part

                                    2. Wait to populate the pivot grid control with proper data

                                    3. Verify the pivot grid displays first page and the pagination control contains links for second page also

                                    4. Navigate to second page to make sure that it really exists and displays some valid data

                                    5. Right click on the field “Sales Amount” in data area and click on the “Hide” context menu item to hide that particular field

                                    6. Wait for the page to refresh and reload

                                    7. It can be observed that the pagination control still contains two links for both first and second pages

                                    8. Click on the link to second page in the pagination control

                                    9. Wait for the second page to load

                                    10. It can be observed that the pagination control is vanished and the first page displayed

                                Sample.zip
                                0
                                Constant (DevExpress Support) 10.10.2011

                                Hello Paulson,

                                I am afraid that I cannot replicate the problem on my side. I have attached a sample project, which works fine for me. Please change it to replicate the problem or provide us with your sample project replicating the issue. We will review it and do our best to find a solution for you.

                                I am awaiting your response.

                                Thanks,
                                Constant

                                dxSample.zip
                                0
                                10.10.2011

                                Hi Constant,

                                I would like to mention a few things to which you may put your attention before you try to reproduce

                                1) Web Part is not for ASP.NET Web application but SharePoint 2010
                                2) In the sample application that we provided you may please notice that the data is bound to the grid only on a call back for the first time

                                In the sample application that you’re provided we found that it lacks the above things. You may please consider binding the database in the call back as we did it in our sample application and try to use the same database. Please verify the video that already attached with the same sample.

                                Thanks,
                                Paulson

                                0
                                10.10.2011

                                Hi Constant,

                                I have created a new sample which is a simple asp.net application and used the same cube. I am able to reproduce the same issue. I have attached the modified sample and database.
                                Please note that in order to reproduce this issue you should use the same database and same logic.

                                Steps to Reproduce
                                1. Open the Web page
                                2. Wait to populate the pivot grid control with proper data
                                3. Verify the pivot grid displays first page and the pagination control contains links for second page also
                                4. Navigate to second page to make sure that it really exists and displays some valid data
                                5. Right click on the field “Sales Amount” in data area and click on the “Hide” context menu item to hide that particular field
                                6. Wait for the page to refresh and reload
                                7. It can be observed that the pagination control still contains two links for both first and second pages
                                8. Click on the link to second page in the pagination control
                                9. Wait for the second page to load
                                10. It can be observed that the pagination control is vanished and the first page displayed

                                Thanks,
                                Paulson

                                Sample10102011.zip
                                0
                                Constant (DevExpress Support) 10.11.2011

                                Hello Paulson,

                                Thanks for the additional information. I am afraid this might take some additional time to research the problem.
                                I will update this thread once I have any results. Thanks for your patience.

                                Thanks,
                                Constant

                                You must  log in  or  register  to leave an answer

                                Is your intention to post an answer to your own question?

                                • If so, then proceed.
                                • If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
                                • If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.