[CLOSED] Max Columns in AHTML?

Is there a maximum number of columns that can be displayed in AHTML?

The following amy be TMI, but, here it is:
I'm getting a blank screen, no display of the report, that has 81 columns in AHTML. I do a View Source and see that "everything is fine", no errors, and that 8000 rows were returned using "ON TABLE PCHOLD FORMAT AHTML". The report display when changing AHTML to HTML.

I'm doing a TABLEF FILE to a hold file (RPTFILE) which comes back in 57 seconds. Then I'm doing a TABLE FILE RPTFILE of that and doing some COMPUTEs in the PRINT section and BY TOTAL COMPUTEs withing 27 BY statements (Yeah, a lot but that's the requirment).

The complete fex runs in 5 minutes with a filtered result of 7798 rows, 1 minute for the extract and 4 minutes to display a report from the hold file). I'm checking indexes, etc. to see why it's taking so long. The original source table, before filtering, only has 408k rows.

Thanks, Doug

This message has been edited. Last edited by: FP Mod Chuck,

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Tom Flynn

Expert

posted

Hide Post

Doug,
Always been limitations with AHTML output; Rows X Columns shouldn't exceed 5K
Maybe that has changed a bit, but, haven't seen it.
LINK to docs...

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

Doug

Expert

posted

Hide Post

Thanks Tom,

I checked it out... And, bummer, too many limits...

I'll have to add a "Export to Excel" option for the users to slice and dice their results...

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

Doug

Expert

posted

Hide Post

I think it's time for a NFR, as follows, what's your thoughts?

Allow the selection of a limited number of columns ON WHICH to apply the AHTML Functionality when formatting a report for AHTML.

Any other things associated with this?

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

David Briars

Master

posted

Hide Post

Sounds like your process is running well, and you have a bottleneck, when the Active Report is being rendered in the browser.

If this is the case, perhaps try Active Cache?

Something like:

TABLE FILE GGSALES
PRINT *
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET LINES 50
ON TABLE SET WEBVIEWER ON
ON TABLE SET CACHELINES 100
END

Posts: 822 | Registered: April 23, 2003

Ignored post by David Briars posted

Show Post

Please Wait. Your request is being processed...