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     -INCLUDE or MATCH or something
Go
New
Search
Notify
Tools
Reply
  
-INCLUDE or MATCH or something
 Login/Join
 
Gold member
posted
I am wondering if either MATCH or -INCLUDE will help me accomplish something a little tricky. I would like to create an Excel report that has different pieces of data on each row across date quarters. For instance:

Q1 Q2 Q3 Q4
Acct Type 1
Acct Type 2
All Closed

The first two rows would be spread out by quarter based on when it was opened. The 3rd row is based on when an account was closed. Since I can't seem to come up with a GROUP BY statement, I figure I might have to run separate reports and sort of stack them on top of each other. Again, row three is a subset of rows one or two but based on the date closed.

Thanks to all. I'm new to the INCLUDE and MATCH uses.


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
 
Posts: 93 | Registered: February 20, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I would probably do the stack multiple report queries route. Example.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Bob

I would think of FML, that has the ability to get the same data into different rows.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Master
posted Hide Post
Is your data in multiple files? What is the format of the data? This may be as simple as:
TABLE FILE FILEX
SUM
CNT.FIELDA
ACROSS QUARTER
BY DATATYPE
END


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks dhagen. I actually used the MATCH FILE in the example link you sent. Could not figure out the FILEDEF...FML suggestion.

Now if I could figure out how to customize the field title at each sort break, that would be perfect. Conditional formatting for SKIP-LINE does not work when using Excel as PCHOLD format.

Thanks to all.


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
 
Posts: 93 | Registered: February 20, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
What do you want the field title to do?


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     -INCLUDE or MATCH or something

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