Focal Point
Report Library

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

July 24, 2007, 08:02 PM
BobSh
Report Library
Has anyone come up with a way to extract records from Report Library so the reports are not BLOBs? We sold a subsidiary and need to provide them with their reports from the Library. They will not have WF or RC or RL.
Thanks.


WebFOCUS 7.7.05M, gen 144, Windows 2008 Server R2 64-bit, Tomcat 6.0.33, IIS 7.0, SQL Server, Excel 2013, PDF, HTML, FOCUS files.
July 25, 2007, 11:27 AM
Darin Lee
When you say 'extract records' are you meaning that you want the content of the reports individually extracted as records? or properties of the specific report?
The design of the Report Library is such that individual content on a stored report is not available. Each report is stored as a single object in a BLOB field (thus the need for a relational DBMS.) That's why FOCUS can't be the repository if Report Library is used. I suppose they could use the DB's native reporting tool (or some other) to extract records into a separate table (or for display as long as it has the ability to properly display the BLOB field.)


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat