Can Toad automatically generate scripts and reports after drag & drop in group panel?

Toad for Oracle - Beta
1

Hi experts,

I'm using Toad 17.1.717.3711 with DB Admin module license.

The Group Panel is really handy because I can just drag & drop to get the results I want.

But I was wondering—aside from just seeing the changes on the screen, can TOAD also automatically generate a script and an Excel report after I finish dragging and dropping?

That would be awesome if it can!

I’ve been using the Pivot Grid, and I love how it lets me drag & drop and easily create multi-dimensional Excel reports.

2025-02-20 10 58 01
2025-02-20 10 58 011920×708 277 KB

2

I don't know what kind of script you are looking for, but you can right-click and choose "Export" to send the data to Excel.

3

Hi John~

The screenshot below shows the Excel report and script I'm looking for.

Can TOAD generate a grouped report、group-by SQL script based on what I see in the UI after drag-and-drop?

01
011920×986 270 KB

02
021920×805 233 KB

4

Sorry, there is no way to get that SQL. Toad doesn't run additional SQL like that to produce the pivot grid.

5

Hi John,

Got it.
Thank you for your support. :blush: