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     Coordinated report fails when one of the reports does not have data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Coordinated report fails when one of the reports does not have data
 Login/Join
 
Gold member
posted
Hi,

I have 5 reports on a single PDF layout. All of them are coordinated through a BY field. The whole thing fails if one of the reports does not have data. Did anybody else face this problem before ? Can somebody please tell me what can be done in this case ?

Thanks.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Guru
posted Hide Post
Are these reports Compound Reports?

Have you tried SET EMPTYREPORT = ON and then tested a linecount from your extract in order to put a message in the heading if it is indeed an empty report?


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
Gold member
posted Hide Post
I have tried setting EMPTRYREPORT ON.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
<JG>
posted
I've tested this with 3 reports in 764 which is the version that you are on.
It works perfectly well as far as I can see.

Even if the first report which contains the OPEN or the last which contains the CLOSE
return no data it still generates the output.

have you got some Dialogue manager logic between your reports that could be causing the problem?

TABLE FILE CAR
SUM DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
-*
WHERE MODEL EQ 'XYZ'
-*
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=CAR, DRILLTHROUGH=DOWN(COUNTRY CAR), $
ENDSTYLE
END
-RUN
TABLE FILE CAR
SUM SEATS
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON COUNTRY PAGE-BREAK
HEADING CENTER
"COUNTRY: " "
ON CAR SUBHEAD
"**** CAR: BY MODEL
-*
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBHEAD, LINE=1, ITEM=2, DRILLTHROUGH=DOWN(COUNTRY CAR),
COLOR=RED, $
ENDSTYLE
END
-RUN
TABLE FILE CAR
SUM SALES
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON COUNTRY PAGE-BREAK
HEADING CENTER
"COUNTRY: " "
ON CAR SUBHEAD
"**** CAR: BY BODYTYPE

ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET STYLE *
TYPE=SUBHEAD, LINE=1, ITEM=2, DRILLTHROUGH=FIRST(COUNTRY CAR),
COLOR=RED, $
ENDSTYLE
END
 
Report This Post
Gold member
posted Hide Post
No, there is no Dialogue Manager.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Gold member
posted Hide Post
JG,

Did you try your report with
 MERGE = ON ? 


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Guru
posted Hide Post
My suggestion re EMPTYREPORT will probably NOT work because there is no common sort field.


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
Expert
posted Hide Post
I had the same problem with a coordinated report with 7 parts.

I ended up forcing the existence of all keys before producing the report.

This resulted in creating some parts with blank or missing data.

I would suggest collecting all keys prior to the coordinated report then joining the keys file to the file being reported on to make sure the keys exists.

This is a problem, I spend quite a long time trying to hide the "Empty Report", probably should put in a case with IB to get a fix or NFR.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Waz,

Could you please elaborate what you did ?

Thanks.

Shravan


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Expert
posted Hide Post
did you try Prarie's idea of
SET EMPTYREPORT=ANSI




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Gold member
posted Hide Post
Susannah,

I tried
SET EMPTYREPORT = ON  
. I did not try
 SET EMPTYREPORT = ANSI 
. I did not know about the second option. I will try that. Thanks.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Expert
posted Hide Post
i don't know what its for, but Prarie came up with it, and it seemed to make alot of people blissfully happy.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Gold member
posted Hide Post
Susannah,

I tried
SET EMPTYREPORT = ANSI  


Whenever I save the Compund Report or run it, it gives an alert
 >SET<
SET EMPTYREPORT = ANSI 


But, it lets me save and run. But,...my problem is not solved.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Expert
posted Hide Post
sorry
send Prarie a pm, maybe she can help




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Virtuoso
posted Hide Post
Did you ever try Jimsters suggestion in the beginning of this thread with a line count in heading? ANSI
would also work with a footing. In compound reports in the past..I have had to make a dummy report ...when there is no data so it would flow properly.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Gold member
posted Hide Post
I did not understand totally what Jimsters suggested before. Now I understood that. I will create a dummy report, run that report when reports do not have data. I will try that. Thanks.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Expert
posted Hide Post
Shravan, have a look at the code below.

This shows one way to force the existence of values, I used this in my report with the 7 parts
TABLE FILE CAR
PRINT COUNTRY
      CAR
      MODEL
      SEATS
      DEALER_COST
      RETAIL_COST
      SALES
BY    BODYTYPE ROWS CONVERTIBLE OVER SEDAN OVER COUPE
ON TABLE HOLD AS CONVERTIBLE
WHERE BODYTYPE EQ 'CONVERTIBLE'
END

TABLE FILE CAR
PRINT COUNTRY
      CAR
      MODEL
      SEATS
      DEALER_COST
      RETAIL_COST
      SALES
BY    BODYTYPE ROWS CONVERTIBLE OVER SEDAN OVER COUPE
ON TABLE HOLD AS SEDAN
WHERE BODYTYPE EQ 'SEDAN'
END

TABLE FILE CAR
PRINT COUNTRY
      CAR
      MODEL
      SEATS
      DEALER_COST
      RETAIL_COST
      SALES
BY    BODYTYPE ROWS CONVERTIBLE OVER SEDAN OVER COUPE
ON TABLE HOLD AS COUPE
WHERE BODYTYPE EQ 'COUPE'
END

-RUN

SET SQUEEZE = ON

COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=CM, $

SECTION=section1, LAYOUT=ON, MERGE=ON, ORIENTATION=LANDSCAPE, PAGESIZE=A4, $

PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', BOTTOMMARGIN=1.0, TOPMARGIN=1, $

COMPONENT='CONVERTIBLE', TEXT='CONVERTIBLE', POSITION=(0.187 0.563), DIMENSION=(* *), $
-*COMPONENT='SEDAN', TEXT='SEDAN', POSITION=(0.187 6), DIMENSION=(* *), $
COMPONENT='SEDAN', TEXT='SEDAN', POSITION=(+0 +0.7), DIMENSION=(* *), RELATIVE-TO='CONVERTIBLE'   , COMPONENT-TYPE=REPORT, RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, $
COMPONENT='COUPE', TEXT='COUPE', POSITION=(+0 +0.7), DIMENSION=(* *), RELATIVE-TO='SEDAN'   , COMPONENT-TYPE=REPORT, RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, $

END

-RUN

SET COMPONENT='CONVERTIBLE'

DEFINE FILE CONVERTIBLE
 BODYTYPE/A12 = E01 ;
END
TABLE FILE CONVERTIBLE
PRINT COUNTRY
      CAR
      MODEL
      SEATS
      DEALER_COST
      RETAIL_COST
      SALES
BY    BODYTYPE
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
END

SET COMPONENT='SEDAN'

DEFINE FILE SEDAN
 BODYTYPE/A12 = E01 ;
END
TABLE FILE SEDAN
PRINT COUNTRY
      CAR
      MODEL
      SEATS
      DEALER_COST
      RETAIL_COST
      SALES
BY    BODYTYPE
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
END

SET COMPONENT='COUPE'

DEFINE FILE COUPE
 BODYTYPE/A12 = E01 ;
END
TABLE FILE COUPE
PRINT COUNTRY
      CAR
      MODEL
      SEATS
      DEALER_COST
      RETAIL_COST
      SALES
BY    BODYTYPE
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
END

-RUN

COMPOUND END


Let me know if you want to know how I "hid" the midding reports.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
omg that's so clever, waz.
where is this component stuff in themanuals?
i searched on component pdf and got nowhere interesting...
I echo pbrighwell...learn something new every day.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Virtuoso
posted Hide Post
quote:
where is this component stuff in themanuals?



Yes...where is it???


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
I have had a DOC Enhancment request open since JULY 2005 asking that this syntax be added to the documentation. As far as I can tell it ain't documented yet.

So who will do this for us and post a cheat sheet for us coders who do not use DS?


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Platinum Member
posted Hide Post
I was having a similiar issue and got it to work by doing an "ON TABLE SET EMPTYREPORT ANSI". I placed this right above the "ON TABLE SET PAGE-NUM ON". Maybe this will help you as well.

Ana


WEBFOCUS 7.6.4
Server: WINXP
 
Posts: 121 | Registered: September 20, 2007Report This Post
Expert
posted Hide Post
Susannah, Prarie

I used to work for IB, there is an internal document.

But for us out side, use Dev Studio, create a report in the PDF Layout Painter (V7.1, V7.6 is better).

Its not easy, but play around and check the code generated.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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     Coordinated report fails when one of the reports does not have data

Copyright © 1996-2020 Information Builders