Page 1 of 1
PivotTable
Posted: Fri 18 Feb 2011 15:23
by khh
Hello,
How I can get the SQL behind the PivotTable result?
Thanks
Posted: Fri 18 Feb 2011 16:32
by .jp
Thanks for the post.
Please specify the product name and the version you are using.
Posted: Sat 19 Feb 2011 02:38
by khh
dbForge Data Studio for SQL Server 1.0.127
Posted: Mon 21 Feb 2011 11:19
by Alexz
There is the Edit SQL Text button on the toolbar.
After click this button, the document Text view will be opened, and you will be able to edit the SQL text.
Also you can clik Edit Text or Design Query in the context menu of the root node in the Data Source window.
Posted: Mon 21 Feb 2011 13:48
by khh
This brings SQL for the source table.
I meant the result SQL for the PivotTable.
Meaning the SQL that will give me PivotTable.
Posted: Mon 21 Feb 2011 14:27
by Alexz
The pivot table is build with internal functionality help without using SQL. So there is no SQL statement that you asked.
Posted: Mon 21 Feb 2011 14:46
by khh
OK
It would be a great feature if it is using native SQL statements.
"SQL PivotTable Designer" is what was in my mind.
Thank you
Posted: Mon 21 Feb 2011 15:16
by Alexz
Thank you for the suggestion.
We'll consider implementing this feature in one of the next versions of the product.