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.
Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
force pdf to one page
Hi everyone,
I wanted to know when you export to a pdf if there is anyway to force the pdf to go from 2 pages to 1. Are there any parameter i might be able to pass?
thanks to all who answers the questionTry setting the rc:PageHeight property on the URL.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"j-man" <j-man@.discussions.microsoft.com> wrote in message
news:0D6875DA-FF61-4A83-8E60-84AEDFD74B12@.microsoft.com...
> Hi everyone,
> I wanted to know when you export to a pdf if there is anyway to force the
pdf to go from 2 pages to 1. Are there any parameter i might be able to
pass?
> thanks to all who answers the question
I wanted to know when you export to a pdf if there is anyway to force the pdf to go from 2 pages to 1. Are there any parameter i might be able to pass?
thanks to all who answers the questionTry setting the rc:PageHeight property on the URL.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"j-man" <j-man@.discussions.microsoft.com> wrote in message
news:0D6875DA-FF61-4A83-8E60-84AEDFD74B12@.microsoft.com...
> Hi everyone,
> I wanted to know when you export to a pdf if there is anyway to force the
pdf to go from 2 pages to 1. Are there any parameter i might be able to
pass?
> thanks to all who answers the question
Monday, March 19, 2012
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!
>>
>
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 list to stay in same place on repeat pages?
Is there some way to force a list (or table) to print in the same place
on repeat pages as it does on the first page?
Say for instance on the first page the list starts 2 inches from the
top, can I make it so on continuation pages the list always starts 2
inches from the top? Instead of starting from the top of the second
page?
What I really need is for the list to always print in a fixed
rectangle, say start 2 inches from the top, and stop 2 inches from the
bottom. Even on the continuation pages. Is this possible?
thanks-JimCan you just do this by adding page headers and footers to the report that
will regulate this? Or are there other complexities to your report that are
not mentioned?
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"jim_slc" <jim_slc@.yahoo.com> wrote in message
news:1135899791.488352.157070@.g47g2000cwa.googlegroups.com...
> Is there some way to force a list (or table) to print in the same place
> on repeat pages as it does on the first page?
> Say for instance on the first page the list starts 2 inches from the
> top, can I make it so on continuation pages the list always starts 2
> inches from the top? Instead of starting from the top of the second
> page?
> What I really need is for the list to always print in a fixed
> rectangle, say start 2 inches from the top, and stop 2 inches from the
> bottom. Even on the continuation pages. Is this possible?
> thanks-Jim
>|||Thanks for the reply Douglas. Once I figured out that having the
header/body/trailer fill the whole page I got it close enough.
on repeat pages as it does on the first page?
Say for instance on the first page the list starts 2 inches from the
top, can I make it so on continuation pages the list always starts 2
inches from the top? Instead of starting from the top of the second
page?
What I really need is for the list to always print in a fixed
rectangle, say start 2 inches from the top, and stop 2 inches from the
bottom. Even on the continuation pages. Is this possible?
thanks-JimCan you just do this by adding page headers and footers to the report that
will regulate this? Or are there other complexities to your report that are
not mentioned?
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"jim_slc" <jim_slc@.yahoo.com> wrote in message
news:1135899791.488352.157070@.g47g2000cwa.googlegroups.com...
> Is there some way to force a list (or table) to print in the same place
> on repeat pages as it does on the first page?
> Say for instance on the first page the list starts 2 inches from the
> top, can I make it so on continuation pages the list always starts 2
> inches from the top? Instead of starting from the top of the second
> page?
> What I really need is for the list to always print in a fixed
> rectangle, say start 2 inches from the top, and stop 2 inches from the
> bottom. Even on the continuation pages. Is this possible?
> thanks-Jim
>|||Thanks for the reply Douglas. Once I figured out that having the
header/body/trailer fill the whole page I got it close enough.
Subscribe to:
Posts (Atom)