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.

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?

I have tried setting EMPTRYREPORT ON.

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

No, there is no Dialogue Manager.

JG,

Did you try your report with

 MERGE = ON ? 

My suggestion re EMPTYREPORT will probably NOT work because there is no common sort field.

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,

Could you please elaborate what you did ?

Thanks.

Shravan

did you try Prarie's idea of
SET EMPTYREPORT=ANSI

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.

i don't know what its for, but Prarie came up with it, and it seemed to make alot of people blissfully happy.

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.

sorry
send Prarie a pm, maybe she can help

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.

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.

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.

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.

quote:

where is this component stuff in themanuals?

Yes...where is it???

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?

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

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.