subreport PDF issues

[Richard Wrench]

I have 7 reports that I want to combine on a single report by using
subreports, but I cannot get consistent output regarding page breaks when I
export to PDF or when I display it on screen. What do I need to do?

Thanks Richard

[Ravi Mumulla (Microsoft)]

Try sticking in empty rectangles (of zero height) between suberports and
setting page break after each rectangle.

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Wrench" <rwr...@icsecurity.com> wrote in message
news:%23fEiws7...@TK2MSFTNGP09.phx.gbl...

[Richard Wrench]

The problem with that is that it previews fine, but the data overlaps on top
of itself when exported via PDF and printed.

"Ravi Mumulla (Microsoft)" <rav...@online.microsoft.com> wrote in message
news:%23AvVRG8...@tk2msftngp13.phx.gbl...

[SimonK]

I get the same problem. I have one report which contains 4 subreports
which each have a rectangle of zero height and set to page break after
it. Report previews in Report Manager fine and shows each report on
it's own page, but when I export it to PDF it puts the last 3 sub
reports on top of eachother. Is this a bug with the renderer or are we
doing something wrong?

[SimonK]

Think I've found a way round this overlapping issue. Drag the
rectangle so that it forms a border around your report and then 'Send
to back' so that the sub report is displayed over the rectangle. For
some reason this seems to stop the report data overlapping when
exporting to PDF format.

[SimonK]

After a bit more messing about with a report, rectangles seem to be
more unpredictable with their output results than I first thought.
(i.e.the results of the same action are not always the same!). Best
method which I'm now using is:

- Create all your sub reports on your 'container' report
- Create a table which is just one detail cell (ie has no header or
footer and only 1 column)
- Drag a sub report into the detail cell
- Create a dataset that just returns the current date (you can't use
the table unless it is linked to a dataset)
- Goto the properties of the table and tick 'Insert a page break after
this table'
- Set the Dataset name to the one created earlier
Repeat for all the sub reports that you want to have.

[Mehul Ramani]

Table thing works for me. but the problem is if one of the subreport doesn't contain any data than also the page is breaking. what to do for avoid this ? That means if subreport doesn't contain any record than page should not be break, the next sub report should come up.

From http://www.developmentnow.com/g/115_2004_8_0_0_449926/subreport-PDF-issues.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com