Focal Point
[CLOSED] Report caster, excel multiple pages

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

April 24, 2013, 02:43 PM
YKK
[CLOSED] Report caster, excel multiple pages
Hi all

I have a problem that is causing me headaches
I have 17 fex that are filling up a excel template that have 15 sheets ( tabs ).
I’m trying to have report caster run the reports one after the others to fill the excel template but it won’t allow me to make more than 1 task sent to the library.
I tried to add “ execute “ at the end of each fex but report caster runs only the first.
Here is how the fex are working
SRP01 to SRP05 create Focus databases
SRP06 open template 00, fill page 3 than save it as template01
SRP07 open template 01, fill page 4 than save it as template02
SRP07 open template 02, fill page 5 than save it as template03
And so on to template 10, fill page 13 than open the excel workbook
Hoping someone can help me make this work on report caster
“Please note that I have no knowledge of java and all these other programming language”

Thank you in advance

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


7.6. / Win 7 / Excel
April 25, 2013, 02:47 PM
YKK
Why did'nt i think of that, wait, I know why,
I haven't got a clue what you are talking about

Don't know compound excel report or EXL2K OPEN or EXL2K CLOSE

Could you please provide or advise where I can find sample code to do just that


7.6. / Win 7 / Excel
April 25, 2013, 03:19 PM
Tom Flynn
Search on EXL2K OPEN.
Over 20 pages of threads...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
April 26, 2013, 08:11 AM
YKK
Sorry, wasn't trying to have attitude, just tried to have a little humor, sorry you took it that way.

Yes it is 4 year we have webfocus but i work on it on average 5 to 8 hours a week only, also took courses and started usin the software 6 months after only.

All our reports are very basic and this one is my first very complex one.

Dod not mean to be arrogant, belive me I appreciate all the help all of you can give

Again I am deeply sorry it did not sounded like I entended, I will be more carefull from now on


7.6. / Win 7 / Excel
April 26, 2013, 04:30 PM
Kathleen Butler
Thanks YKK for your sincere response back. It's really appreciated and helpful that you clarified.

This is a reminder to everyone that we want the Focal Point Community to be a friendly community where developers can collaborate and help each other. Please do not respond back to posts in a negative tone. If you feel that someone is being negative please contact me.

If anyone can offer YKK further assistance or elaborate that would be very helpful since this is his first complex report. I'm sure there are others that my have the same question.

Thanks,

Kathleen Butler
Information Builders

This message has been edited. Last edited by: Kathleen Butler,
April 26, 2013, 05:50 PM
Kathleen Butler
Hi YKK,

I checked with our technical leads at Information Builders. If the information below is not enough please don't hesitate to open a case with our tech support so we can help you further.

***********************************
While email distribution will allow for multiple tasks in the same schedule, producing several reports which show up as attachments in an email, Library distribution only allows for 1 task, with one report output, to be stored in the library. So to put several reports together in a library distribution, you need to be put together as one compound report.

Compound reports have to be developed through developer studio’s gui tools, eg, Document Composer, and automatically generated in order to be supported by Caster. Due to the complexity of the required internal syntax, compound reports that are put together or edited manually are not supported if they have problems with Caster distribution.

If bursting is to be used, the compound report has to be a coordinated compound report, with a matching first BY field for all the subreports.

Take a look at this section rom pages 188-189 of the 7703 ReportCaster Development and Library Content manual (DN4501007.0511).

Manually Coded Excel Compound Reports

Excel Compound Reports enables you to generate multiple worksheet reports using the
EXL2K output format.
The syntax of Excel Compound Reports is identical to that of PDF Compound Reports. By
default, each of the component reports from the compound report is placed in a new Excel
worksheet (analogous to a new page in PDF). If the NOBREAK keyword is used, the next
report follows the current report on the same worksheet (analogous to starting the report
on the same page in PDF).

Output, whether sent to the client using PCHOLD or saved in a file using HOLD, is generated
in Microsoft Web Archive format. This format is labeled Single File Web Page in the Excel
Save As dialog box. Excel provides the conventionally given file suffixes: .mht or .mhtml.
WebFOCUS uses the same .xht suffix that is used for EXL2K reports. Since the output is
always a single file, ReportCaster can distribute it.
The components of an Excel compound report can be FORMULA or PIVOT reports. For more
information about the Excel Compound Reports feature, see the “Creating Reports With
WebFOCUS Language” manual.

Note:
Excel 2002 (Office XP) or higher must be installed. Excel Compound Reports will not
work with earlier versions of Excel since they do not support the Web Archive file format.
Bursting is not supported with Excel Compound Reports.

Compound Reports and Coordinated Compound Reports

ReportCaster can distribute compound reports developed using the Document Composer in
Developer Studio in AHTML, DHTML, EXL2K, PDF, and PPT formats.
ReportCaster can burst and distribute coordinated compound reports developed using the
Document Composer in Developer Studio in DHTML, PDF, and PPT formats.

Again, please open a case with Technical Support and we'll be happy to further assist you.

Sincerely,

Kathleen Butler
April 27, 2013, 01:31 AM
FrankDutch
You try to do this with reportcaster.
But does it work as one single fex without reportcaster.

So do you have one fex that holds all the others from srp01 till srp17




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

May 03, 2013, 01:52 PM
YKK
Sorry for late reply, i didn't have much time to work on my report.

I am currently trying to insert 19 of the fex into the first one, I don't know if this is what a compound report is but so far it seems to work outside reportcaster, once I finish this, I will try it in report caster.

Thank you all.


7.6. / Win 7 / Excel
May 10, 2013, 08:29 AM
YKK
Still not working but have no time to work on it at the moment

Thank you anyway to all people who tried to help


7.6. / Win 7 / Excel
June 18, 2013, 08:12 AM
YKK
Just a note

I gor the answer from the expert at the summit

They suggested the following

Open the first report in text, add -RUN at the end then copy the second report in text, add -RUN and keep on doing that until the last report.

It worked perfectly.

Great summit.

Thank you all


7.6. / Win 7 / Excel
June 14, 2017, 01:55 PM
Terri1977
Hello,
I have a program that is generating multiple sheets in EXCEL. In the program (using Text Editor), I use EXL2K OPEN for the first TABLE and then the last one EXL2K CLOSE. When I attempt to set up a schedule through ReportCaster, it generates an error. However, if I set it up with one of the TABLES and take off the EXL2K OPEN to just EXL2K then it works. Can you assist so that all the tabs can be generated using Report Caster? Thank you.


WebFOCUS 8
Windows, All Outputs
June 14, 2017, 02:30 PM
MartinY
Terri,
Please, stop posting the same question over multiple treads.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007