Is there a limit as to the number of worksheets that could be populated with a webfocus report?

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

PO

I am not aware of any limit, I assume you are using the Table of Contents option to force the creation of multiple tabs (worksheets).

Note the number of worksheets is
limited by available memory on the user's machine.

I have a job that creates over 100 worksheet in one workbook.

quote:

Originally posted by jgelona:
I have a job that creates over 100 worksheet in one workbook.

Do you use only COMPOUND ON?

No I am not using a table of content to create multiple tabs. Should I be using that?

PO, may I suggest you tell us what you're attempting to accomplish?

If WebFOCUS could create a spreadsheet with 5000 tabs, how does that help?

In my report the sheets are looping through the code. I have an & variable name &OPEN. On the first pass the value is OPEN. On the last pass the value is CLOSE. All the passes in between the value is blank.

ON TABLE PCHOLD FORMAT XLSX &OPEN

This is a summary report. The first pass is a state wide summary. The next 5 passes are Region Summaries. The rest of the passes are for each County.