Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel Table for PIVOT
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Excel Table for PIVOT
 Login/Join
 
Member
posted
I'm looking into using a template where I have a tab with two pivots that are tied to two different tabs with excel tables (vba ListObject).

On the data tabs that will be replaced by WF, is it possible to have WF place the data in the tabs as an Excel table (vba ListObject) so the source of the pivots can be just "myTable1" and "myTable2" rather than specifying an actual range (for example A:Z) which might include blank rows?

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 4 | Registered: October 11, 2018Reply With QuoteReport This Post
Master
posted Hide Post
So you have a template with 3 sheet? Sheet 1 contains your pivots and the other 2 sheets contain data table from WebFOCUS? If I was doing this I would not have any blank rows in my data tables, then I would have an Auto-Open macro that would redefine myTable1 and myTable2.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 917 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel Table for PIVOT

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.