Once an Active HTML report is ran and you click on the Active arrow at the column heading and then click Calculate and then % of Total. This will give you the % of the column, what the clients wants to see is the % of the row. I can calculate it and present it to them but they want to use the tool. If the report generates these new columns then my question would be how to hide them until they want to see them.

This message has been edited. Last edited by: David Sibert,

I don't believe there is way to do it after the report generates but you could use RPCT in the ACROSS then use the stylesheet command HIDE=ON to hide all of the RPCT columns before the report generates. Then it's up to the user to unhide/hide the desired RPCT columns using ACTIVE Tech.

Here's some code to play with that works in 7.6.11:

TABLE FILE CAR
SUM SALES 
    RPCT.SALES AS PCT 
ACROSS COUNTRY AS ''
BY SEATS
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET STYLE *
TYPE=REPORT,COLUMN=RPCT.SALES(*),HIDE=ON,$
ENDSTYLE
END

On report generation, hit any Active drop-arrow and select Show Columns then select Show All. POW! All of the RPCT columns display nicely. To hide all of the RPCT columns, select Restore Original from the bottom of the Active drop-arrow menu.

David

Thanks David

My only issue is that first you have to hide a column prior to you being able to unhide a Percent column.

You're welcome.

You are correct, because the user cannot create the row percentage columns on the fly using Active Content technology options, we generate the row percentage columns, hide them, and finally allow the user to unhide them when they want to see them.

Which seems to be the working solution to your question:

quote:

If the report generates these new columns then my question would be how to hide them until they want to see them.

That's cool, though. I actually learned something useful doing this small exercise so I should thank you for asking the question!