How do you save a pivot grid, graph, or chart in Toad for Data Analysts? When I try to save my work, Toad tries to save the SQL statement or the Query Builder window.
RESOLUTION:
In Toad for Data Analysts, when you run a select statement or run a statement built in the Query Builder and once you get the result set you want, you can either click on the "Pivot and Charts tab" or right mouse click and select "Send to | Pivot Grid or Charts Designer."
In the tab mode, you cannot save the Pivot or Charts, because it will try to save your select statement or your Query Builder. But instead, if you select "Send to | Pivot Grid or Charts Designer" it will open a new window and in this window you can save your work.
1. Run the Select Statement in the Editor window or run a statement built in Query Builder window.
2. In the Result Sets tab, right mouse click, select "Send To" and either "Pivot Grid" or "Charts Designer"
3. In the new Pivot Grid or Chart window, you should be able to save your work.
Note this option is only in Toad for Data Analysts 2.5 and above.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center