Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Compound Reports using Web Service Call

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Compound Reports using Web Service Call
 Login/Join
 
TSwan
Member
posted
We are writing a report that uses the compound report functionality. When we run the report in Developer Studio, it looks fine. When running the report by making a web service call to it, only the first part of the compound report shows up. Does anyone have any ideas of why it would be doing this and how to fix it?

In the code we are doing something like this (with an output of HTMTABLE).


SET COMPOUND = ON
TABLE FILE RPT1
PRINT
(create first report)
END
SET COMPOUND = CLOSE
-INCLUDE app/RPT2


WF 7.6.4 platform: Windows, databases: Oracle, browser:IE6
 
Posts: 10 | Registered: September 11, 2007Report This Post
Mika Keranen
Gold member
posted Hide Post
Hi TSwan,

I guess it should be SET COMPOUND = OPEN. Interesting, though, if it works in Developer Studio.

Regards,
Mika


WebFOCUS 7.6.x
PMF 5.2.x
 
Posts: 58 | Location: Sydney, Australia | Registered: April 22, 2005Report This Post
TSwan
Member
posted Hide Post
Now it has been set to
SET COMPOUND = OPEN

We are still unable to see the second report with the Web Service call.


WF 7.6.4 platform: Windows, databases: Oracle, browser:IE6
 
Posts: 10 | Registered: September 11, 2007Report This Post
Leah
Virtuoso
posted Hide Post
You don't close the compound until the last report is run. Surprised it works in Dev Studio. Of course In our world I've had to manipulate the last fex in the string to

ON TABLE SET ONLINE-FMT PDF
ON TABLE SET COMPOUND CLOSE

For some reason it just won't show if I go the other route using ON TABLE PCHOLD FORMAT PDF and the SET COMPOUND = CLOSE after all. Any suggestions out there


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
FrankDutch
Virtuoso
posted Hide Post
Hi

Do both report have the same output format (HTML)




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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
TSwan
Member
posted Hide Post
Thanks for all of your suggestions so far.

I tried changing the location of the COMPOUND = CLOSE to run after the include of the last report. It still works in Developer Studio but not with our Web Service call.

Both reports have an output format of HTML.


WF 7.6.4 platform: Windows, databases: Oracle, browser:IE6
 
Posts: 10 | Registered: September 11, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
Please update your signature so we know what version and platform you are running.




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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Mika Keranen
Gold member
posted Hide Post
If the report format is HTML and you just want to run two or more HTML reports one after the other, you don't need to use COMPOUND syntax. You should be able to it like this:

TABLE FILE CAR
SUM SALES
BY COUNTRY
END
TABLE FILE EMPDATA
SUM SALARY
BY DIV
END

If you'd like to use e.g. PDF format, you can do the same thing either like this...

SET COMPOUND = OPEN
-* or OPEN NOBREAK if pagebreaks are not needed.

TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
END

SET COMPOUND = CLOSE

TABLE FILE EMPDATA
SUM SALARY
BY DIV
ON TABLE PCHOLD FORMAT PDF
END

Without SET COMPOUND commands.

TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF OPEN
-*ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
END

TABLE FILE EMPDATA
SUM SALARY
BY DIV
ON TABLE PCHOLD FORMAT PDF CLOSE
END

Mika


WebFOCUS 7.6.x
PMF 5.2.x
 
Posts: 58 | Location: Sydney, Australia | Registered: April 22, 2005Report This Post
TSwan
Member
posted Hide Post
I took the compound statements out and yes it still works in Developer Studio but it still does not bring back both reports when using the Web Service API. Thanks for the suggestion.


WF 7.6.4 platform: Windows, databases: Oracle, browser:IE6
 
Posts: 10 | Registered: September 11, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Compound Reports using Web Service Call

Copyright © 1996-2020 Information Builders