ODS TAGSETS TABLEEDITO​R - option priorities

[high5in]

I'm using the tableeditor tagset and having success with it.  I do notice that when using certain options like the pivot table and chart, that many other options no longer work.  Is there a guide anywhere as to what options work in unison and what options do not?

Ex.  I want to create a report that has 2 web tabs.  Each tab displays data but only 1 tab has the pivot table export option.  The other tab displays raw data which can be sorted, filtered, etc.

Once I add the pivot table export option, i can no longer filter, etc.

[Cynthia_sas]

Hi:
  The best set of examples I know of is here: http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/index.html on the R&D web site. If you are running into issues when using the destination and you don't find what you're looking for on this page, then your best bet is to open a track with Tech Support.

cynthia

[high5in]

Thanks for the reply Cynthia.  I've used that link numerous times to identify how to use a certain option via examples.  However what it  doesn't tell me is what options no longer work when using specific options.

Another example:  I can use the following basic display options:

window_title="string"

window_status="string"  

However once I add in options to display a pivot table button to create a pivot table and chart, the basic display options no longer work.

If anyone else has run into this please let me know.

In the meantime I will try Tech Support and update this thread with any findings/response.

[high5in · Accepted solution]

I created a ticket and was able to find the following:

Autofilter and sort options do not work with the Pivot table options.  They will not allow the proper exporting of data to Excel.

Frozen headers will not work with setting a specifc pageheight option.  The pageheight will not allow the header to stay frozen.

Hope this helps if others run into any of the same issues!