I am trying to Create an EXPANDABLE ACCORDIAN REPORT.
I Want to be able to SEE Totals for sort group for example:
Period1 Period2
I have Fields:
+District (TOTAL) or at the bottom
+Location1
SUM(SALES) SUM(SALES)
+LOcation2
SUM(SALES) SUM(SALES)

How do I go about it. I know I can get row and colum totals.
Also, can I control the Expanable field.

This message has been edited. Last edited by: Kerry,

Does this work for you?

TABLE FILE CAR
PRINT SALES
BY COUNTRY SUBFOOT
"<COUNTRY <ST.SALES"
BY CAR 
BY MODEL
ON TABLE SET EXPANDABLE ON
END

ITs not adding Accordian in the report.

Did you run my sample code? I see the plus signs in addition to the subfoot. I tested this in 7.6.5 and 7.6.11.

Can you please start reproducing your errors with one of the sample files so that we can test in our own environments?

Works for me.

IT worked for me too now. I am going to try in my production DB. I am keeping my fingers crossed. I will let you know the results. Can you add accordians in Excel?

Arif

No, it is an HTML construct only.

Time to read the documentation: Creating Reports With WebFOCUS Language > Navigating Within an HTML Report > Controlling the Display of Sorted Data With Accordion Reports

I have some reports coming out of my peoplesoft reporting that includes expandable fields in excel that is why I asked if there is a trick.

I was able to work my report using your Car code.Thank you. I noticed that I can created multiple subheadings with totals.
SO, ST. is a sum function in report subheading?

quote:

Time to read the documentation:

T

To follow up on Tony's post, look up prefix operator. There are a number of useful ones you should get to know.