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.

I would probably do the stack multiple report queries route. Example.

Bob

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

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

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.

What do you want the field title to do?