#9814: Script Full to New Window different when "Drop Row Fields" - field setting was none becomes custom in New Window

swissarmyknife(*) reported 2013-08-21T18:56:00Z · last modified 2014-06-09T22:59:24Z

Script Full to New Window different when "Drop Row Fields" - field setting was none becomes custom in New Window

Dev	mattbrumley(*)
QA	swissarmyknife(*)

Priority	Low
Complexity	Unknown

Component	Q Analyzer - Pivot Grid Results
Version	Future - .9

Using SQL Server 2000 Northwind Database and Orders Table

See attached

(pivot_grid_03 script to new window.png and pivot_grid_02.png) show that I am setting Field Settings for the Row Field "Ship Region" to Subtotals "none" and no item is checked in the Field Settings custom list.

sa@SQLServer1_before_script_full.sql

(pivot_grid_04_after_script_full.png) if I right click and Script to New Window on this pivot, the Row Field "Ship Region" shows "Custom" with Sum checked in the new window's custom list, which is not what my previous window had.

sa@SQLServer1_after_script_full.sql