Showing posts with label break. Show all posts
Showing posts with label break. Show all posts

Monday, March 26, 2012

Forcing section break to odd pages

Hi - I'm new to this forum and fairly new to Crystal. Using 9.0. Because we print two-sided, I need to force a section break to start on next available odd numbered page so that I can treat the printed sections as separate documents (e.g. I don't want 1st page of new section to print on back of preceeding section). These sections are anywhere from 10 - 18 pages in length, and it is a huge report - over 11,000 pages. I'm pretty sure that there is a way to do this but I don't have time to fumble around with it. I already have 10 hours in this one report!

Thanks in advance
RobinI wrote a report recently that needed something simular, prehaps you can try this. The report prints a list of people at a specific place. Sometimes the place (group one) has lots of people and stems onto two pages and other times it fits on one page. As I'm duplex printing, I need to check whether the pages are even or odd and thus to include a page break or not.

In the section expect, I added a new group footer. In both group footer 1a and 1b I checked the 'new page after'. Then in group footer 1b, I added

Right (ToText(PageNumber),1) in ["0","2","4","6","8"]

which causes my report only to add a blank page after group one has finished if the current page number ends in any of the values above.

Hope it helps.

Monday, March 19, 2012

Force page break for each record in table

I hae a tabel with about 20 rows in it. All 20 rows represent one data
record and are formated to discplay as one page. How do I make each record
break to a new page (1 instance of this table on each page)?
Thanks.
--
moondaddy@.nospam.nospamThere isn't an option to have a table do a page break for every detail row.
However, you can force the table to do a page break after every group.
Create a group in your table and move all the fields into the group header
boxes. Then set the table to break after each group. You'll have to be
careful and group your table on a field that's unique to each record...
"moondaddy" <moondaddy@.nospam.nospam> wrote in message
news:e2Le$PDNGHA.3936@.TK2MSFTNGP10.phx.gbl...
>I hae a tabel with about 20 rows in it. All 20 rows represent one data
>record and are formated to discplay as one page. How do I make each record
>break to a new page (1 instance of this table on each page)?
> Thanks.
> --
> moondaddy@.nospam.nospam
>

Force No Page Break

Hi --
I have a Report that generates a table with a lot of rows. Reporting
Services breaks my report up into 13 pages. I'd like it to be all one giant
table. Is there a way to force no page breaks?
Thank you!In RS 2005, html only you can do this. It is a report property (not a table
property) called interactive size. I believe you put in 0 for it no not have
page breaks.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dev648237923" <dev648237923@.noemail.noemail> wrote in message
news:%23$WNcbc0GHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hi --
> I have a Report that generates a table with a lot of rows. Reporting
> Services breaks my report up into 13 pages. I'd like it to be all one
> giant table. Is there a way to force no page breaks?
> Thank you!
>|||Thanks -- I set it to 0,0 and that worked great!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eL6Iubd0GHA.1040@.TK2MSFTNGP06.phx.gbl...
> In RS 2005, html only you can do this. It is a report property (not a
> table property) called interactive size. I believe you put in 0 for it no
> not have page breaks.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "dev648237923" <dev648237923@.noemail.noemail> wrote in message
> news:%23$WNcbc0GHA.3568@.TK2MSFTNGP03.phx.gbl...
>> Hi --
>> I have a Report that generates a table with a lot of rows. Reporting
>> Services breaks my report up into 13 pages. I'd like it to be all one
>> giant table. Is there a way to force no page breaks?
>> Thank you!
>>
>

Force new page.

I have a report that has multiple graphs on it. I would like to force a page break (new page) in between the different reports causing a report to be generated on it own page. Im assuming that Im missing something here because it seems like a easy/usable feature. Any help would be great.

Thanks,

ZDB

Hello ZDB,

Click on your chart, then press F4 to open the Properties window. In here, set the PageBreakAtStart or PageBreakAtEnd to True, depend on where you want the page break.

Hope this helps.

Jarret