# Pivot Grid Opening Problems **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [August 22, 2016, 7:57am UTC](https://forums.toadworld.com/t/pivot-grid-opening-problems/38220 "2016-08-22T07:57:22Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![David\_Woomer](https://avatars.discourse-cdn.com/v4/letter/d/e9a140/32.png) [@David\_Woomer](https://forums.toadworld.com/u/David_Woomer)\ **Post date:** [August 22, 2016, 7:57am UTC](https://forums.toadworld.com/t/pivot-grid-opening-problems/38220/1 "2016-08-22T07:57:22Z")
I am using version 4.0.0.624 and having issues with the pivot grid. When I run a query and right click in the results I can choose send to pivot grid but nothing happens. My result set is small. Also, when I try and open a tpg file created in a prior version nothing happens–I don’t get an error message. It just doesn’t open. Is there a known bug about this? ---
**Author:** ![Filip.Cevela](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/filip.cevela/32/200_2.png) [@Filip.Cevela](https://forums.toadworld.com/u/Filip.Cevela)\ **Post date:** [August 23, 2016, 4:36am UTC](https://forums.toadworld.com/t/pivot-grid-opening-problems/38220/2 "2016-08-23T04:36:25Z")
Hi David, I tried it with Editor and with Query Builder result but I don’t have any problem with sending to Pivot Grid. Can you please tell me more information? What database provider are you using? What previous version are you used for generating tpg file? Thanks ---
**Author:** ![David\_Woomer](https://avatars.discourse-cdn.com/v4/letter/d/e9a140/32.png) [@David\_Woomer](https://forums.toadworld.com/u/David_Woomer)\ **Post date:** [August 23, 2016, 6:24am UTC](https://forums.toadworld.com/t/pivot-grid-opening-problems/38220/3 "2016-08-23T06:24:31Z")
Hi Filip, I am connected to an Oracle database. The previous version of Toad I used was 3.6.0.3276. In the new version I also tried to send a table right to a pivot grid with a right click, and got the following error: In the prior version of Toad I had no problem doing this. Thanks. David Woomer **From:** Filip Cevela [[mailto:bounce-FilipCevela@toadworld.com](mailto:bounce-FilipCevela@toadworld.com)] **Sent:** Tuesday, August 23, 2016 7:38 AM **To:** [toaddatapoint@toadworld.com](mailto:toaddatapoint@toadworld.com) **Subject:** _EXTERNAL_ RE: [Toad Data Point - Discussion Forum] Pivot Grid Opening Problems **RE: Pivot Grid Opening Problems** Reply by Filip Cevela Hi David, I tried it with Editor and with Query Builder result but I don’t have any problem with sending to Pivot Grid. Can you please tell me more information? What database provider are you using? What previous version are you used for generating tpg file? Thanks To reply, please reply-all to this email. Stop receiving emails on this subject. Or Unsubscribe from Toad Data Point Forum notifications altogether. Toad Data Point - Discussion Forum Flag this post as spam/abuse. ---
**Author:** ![Filip.Cevela](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/filip.cevela/32/200_2.png) [@Filip.Cevela](https://forums.toadworld.com/u/Filip.Cevela)\ **Post date:** [August 23, 2016, 6:35am UTC](https://forums.toadworld.com/t/pivot-grid-opening-problems/38220/4 "2016-08-23T06:35:18Z")
Hi David, I tried with my Oracle 11 and I still don’t see any problem. From your image it looks like there should be some problem with some datatype which are you using. Can you confirm that it happen on more tables with different datatypes in columns (some simple table with few columns would be great). If you have still problem also on other tables then I would like to ask if you can create Support Bundle (in Help -\> Support Bundle) and send it to me. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [August 23, 2016, 3:19pm UTC](https://forums.toadworld.com/t/pivot-grid-opening-problems/38220/5 "2016-08-23T15:19:05Z")
i have another user who has the same issue. I entered QAT-8501 for this but need some help reproducing this. can you do the following? 1. Open the Pivot grid in TDP 3.8. RIght click and chose Edit Undrlying SQL. Copy the SQL into an SQL editor. 2. Keep the SQL editor focused and generate support bundle from the Help menu. Chose ‘No’ when it asks you about row number. 3. Post or email directly to the complete support bundle (I need several files in there) and the pivot grid file that won’t open in TDP 4.0. You can email me: [debbie.peabody@quest.com](mailto:debbie.peabody@quest.com) ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [September 7, 2016, 7:51pm UTC](https://forums.toadworld.com/t/pivot-grid-opening-problems/38220/6 "2016-09-07T19:51:46Z")
This issue is fixed for patch release TDP 4.0.1. It is also in the current Beta if you would to try.