R&R11 Xbasew pivot table limitation

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
pbla1_wcc
Posts: 8
Joined: Tue Oct 10, 2017 12:44 pm

R&R11 Xbasew pivot table limitation

Post by pbla1_wcc » Tue Apr 25, 2006 9:27 am

I^m trying to create a pivot table with 30 rows, but R&R11 only seems to let me have 24. I can add the extra row definitions and the query runs with no error message, but only 24 rows show up in Excel. If I delete 6 other rows then the new ones at the bottom show up!____I couldn^t find anything in the documentation about limits. Has anyone hit the same problem?

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> R&R11 Xbase pivot table limitation

Post by kfleming » Wed Apr 26, 2006 4:35 am

This is not one that I am aware of.____I will have a look to see if I can reproduce this.____Kathleen__R&R Support

pbla1_wcc
Posts: 8
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: R&R11 Xbase pivot table limit

Post by pbla1_wcc » Wed May 10, 2006 4:53 am

Additional info:__What I^m trying to do means that I have one column field, one row field and 28 values to be summed. This works in Excel2000, but in the R&R pivot table I can^t get more than 24 value fields.____Peter__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: R&R11 Xbase pivot table limit

Post by kfleming » Wed May 10, 2006 10:40 am

I tested back to V8 of R&R and it does seem that the limit to the number of Pivot Export values is indeed 24. I will add this to the bug list but it will have a fairly low priority since you are the first user to encounter this.____Kathleen__R&R Support

Post Reply