Focal Point
Report Output Formats

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7561032952

November 28, 2007, 04:56 PM
<BrianS>
Report Output Formats
I have a report in excel (ON TABLE PCHOLD FORMAT EXL2K) but there are too many records. How would I get it to output to a text file? Thanks.
November 28, 2007, 05:06 PM
GinnyJakes
Brian,

The simple answer is ON TABLE HOLD FORMAT ALPHA.

The more complex issue is where you want to put it. It would help if you gave more information including your environment specifications which you can store in your signature in your profile.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
November 28, 2007, 05:12 PM
Leah
There is an option to use another form of excel which is for the office 2007. You are stuck with the spreadsheet limits if the report data is to be pulled into a spreadsheet. I also played with putting small heading lines to get more data displayed.


Leah
November 29, 2007, 03:32 AM
GamP
Excel before 2007 only accepts 64K rows.
Excel 2007 accepts a million, which should get rid of most size limitations.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
November 29, 2007, 10:37 AM
Francis Mariani
GamP, can WebFOCUS generate an Excel spreadsheet with more than 64K rows? If so, then the issue was with Excel versions prior to Excel 2007.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 29, 2007, 02:04 PM
FrankDutch
Who wants an excel spreadsheet with a million rows?

there is no way to handle it.

try to break it down into different pages based upon the first by field

BYTOC=ON (I think)




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

November 29, 2007, 03:05 PM
Francis Mariani
I want an excel spreadsheet with a million rows! I want it all!

Just kidding.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server