Is it possible to have expandable turned on for compound reports? I seems to always expand the first report in a compound document.

Here a sample

TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT HTML OPEN
END
TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT HTML OPEN
END
TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT HTML CLOSE
END

Thanks,
Bob G.

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

quote:

TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT HTML OPEN
END
TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT HTML OPEN
END
TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT HTML CLOSE
END

Try this Code:

 
TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS
ON TABLE SET EXPANDABLE ON
ON TABLE PCHOLD FORMAT HTML OPEN
END
TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS

ON TABLE PCHOLD FORMAT HTML
END
TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE COLUMN-TOTALS

ON TABLE PCHOLD FORMAT HTML CLOSE
END 

Hi Arif

I tried your solution on 7.6.8 and it creates the first report as expandable but the next two reports display as full reports in the document.

We need to have all three reports on the compound document to be expandable. The initial method looked like it had worked but when you expand a line on the second or third report it expands the first report instead.

Thanks for you help.

Hi Bob,

I checked with our technicals and was suggested that this seems to be an issue to be fixed by programming, so please open a case with Customer Support Services so that we can do further research. You may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry