The SAS Output Delivery System and reporting techniques

ODS TAGSETS TABLEEDITO​R - option priorities

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

ODS TAGSETS TABLEEDITO​R - option priorities

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.


Accepted Solutions
Solution
‎08-23-2016 04:24 PM
New Contributor
Posts: 3

Re: ODS TAGSETS TABLEEDITO​R - option priorities

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!

View solution in original post


All Replies
SAS Super FREQ
Posts: 8,868

Re: ODS TAGSETS TABLEEDITO​R - option priorities

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

New Contributor
Posts: 3

Re: ODS TAGSETS TABLEEDITO​R - option priorities

Posted in reply to Cynthia_sas

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.

 

Solution
‎08-23-2016 04:24 PM
New Contributor
Posts: 3

Re: ODS TAGSETS TABLEEDITO​R - option priorities

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!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 281 views
  • 0 likes
  • 2 in conversation