Hi Guys,

I created compound PDF reports .I am having an issue in it.

I replicated my problem with CAR example.

 -*-------------------Header Report---------
SET COMPOUND = OPEN
TABLE FILE CAR
HEADING
"CAR:<CAR"
" RCOST:<RCOST"
" DCOST:<DCOST"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF NOBREAK
END
-*------------------Detailed Report----------
TABLE FILE CAR
  PRINT 
    RCOST 
    DCOST
  BY CAR 
  ACROSS COUNTRY
  ON TABLE SET BYPANEL ON
  ON TABLE PCHOLD FORMAT PDF CLOSE
END
 

If i run this i am facing an error

[IMG:left] [/IMG]

If i remove NOBREAK in my first report(Header Report) then i am not getting any error
but i am getting my First report in one page and second report in next page.

I need my second report at the end of my first report.

Can you guys help me.

Valid inputs are highly appreciated.

Thanks in advance.
Rakesh

This message has been edited. Last edited by: Rakesh Boddu,

The width of one of the report components is wider that the PDF page.

This is not allowed when you use NOBREAK.

You need to either change the size of the PDF layout to a larger one or reduce the with, by changing the styling, say font size, etc

Thanks Waz for very quick response.

I cannot change width ,i cannot make it static.
The ACROSS columns are dynamic.

Is there any other way to bring my second report to the end of first report.

Thanks,
Rakesh

You cannot have the 2nd report in a compound no-break report not fit in the pagesize of the first report... it just is not logical.

Here, this should work for you:

TABLE FILE CAR
HEADING
"CAR:" RCOST:" DCOST:ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
END
-*------------------Detailed Report----------
TABLE FILE CAR
PRINT
RCOST
DCOST
BY CAR
ACROSS COUNTRY
ON TABLE SET BYPANEL ON
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,PAGESIZE='LETTER',ORIENTATION=LANDSCAPE,SIZE=8,$
ENDSTYLE
END

This message has been edited. Last edited by: Anatess,

How dynamic is the across ?

What is the maximum number of values ?

When designing a report these are the sorts of things that need to be considered.

You can change the PAGESIZE and ORIENTATION, as we Anatess' example.

Page Size can be quite large, but ends up very small.

Another option is to use a coordinated compound report, this way you can have multiple reports handing the across parts.

Hi Waz and Anatess,

Thanks for replies.Great

Instead of using Compund PDF,i joined my SQL's and i am using just PDF report.

Thanks,
Rakesh