Extra page in print preview and .pdf

I have tried and tried to get my reports to quit printing an extra blank page but have been unsuccessful in my efforts.

I've set the margins in my report properties to (all in inches):

.75 - top

.5 - left, right, bottom

My page is landscape so the width is 11 and the height is 8.5

I've made sure my table is not wider than 9.5 - I've even made it as small as 8" wide to see if that was the problem . (I've done this for the header/footer as well.)

My report prints all on one page but I still get a 2nd page with header/footer information and a blank body.

I read a post that said to try making the right margin 0 - that didn't work either.

Additional information: I just saw a post suggesting borders around everything to see what might be bleeding onto a 2nd page.

One page 1, the full borders are there, so nothing should be bleeding onto page 2. However, when I go to page 2, there are no borders around the header, but the left edge shows on the right side of the page. Also, the footer is missing it's left edge, but the right shows. I've tried making both the header and footer smaller, as well as moving them further right - still get the exact issue.

I'm using the reporting services for Visual Studio .NET 2003.

Any help would be greatly appreciated! Thanks!

Well, turns out it was the layout. Although my report elements were the right size, the layout was too big, forcing the margins over.|||

It is COOL that your posted your results!

|||

Hello - just a general comment!

I have eliminated the capability to export to PDF within RS in that PDF NEVER renders any ledgeable characters in my part of the world which includes:

Thailand, Cambodia, Laos, Mayamar (Burma), Vietnam, Pakistan and Tibet and this also includes any dialect in Mandarin!

We just stick to a TIF and everything is always perfect -

|||

When you say your layout was too big, what did you set it too?

Just curious, since I was having an issue similar to yours although I might not have worded it as clearly

http://forums.asp.net/1139722/ShowPost.aspx

Thanks

sql

Extra empty pages in PDF report

Report looks great in Visual studio and in a Browser, but when I convert it
to pdf for printing, I am getting extra pages after every good page with just
a header printed on those pages.
I tried decrease the size of the report and make sure that it fits into 8
1/2 x 11 inches, but it did not help.
I still have those annoying empty pages in the printed report.
Any other suggestions on how can I fix it?
Thank you.Simon if are you having problem with client side printing then you will want
to try the following.
Try setting body width to 8.46 if you are using letter/portrait. If you are
using letter/landscape then set the width to 10.96.
I hope that helps.
This is an issue Microsorft is now aware of.
"Simon Gold" wrote:
> Report looks great in Visual studio and in a Browser, but when I convert it
> to pdf for printing, I am getting extra pages after every good page with just
> a header printed on those pages.
> I tried decrease the size of the report and make sure that it fits into 8
> 1/2 x 11 inches, but it did not help.
> I still have those annoying empty pages in the printed report.
> Any other suggestions on how can I fix it?
> Thank you.
>|||Thanks Kevin. I figured it out about one hour before I got your e-mail. :-)
"Kevin Weir" wrote:
> Simon if are you having problem with client side printing then you will want
> to try the following.
> Try setting body width to 8.46 if you are using letter/portrait. If you are
> using letter/landscape then set the width to 10.96.
> I hope that helps.
> This is an issue Microsorft is now aware of.
> "Simon Gold" wrote:
> > Report looks great in Visual studio and in a Browser, but when I convert it
> > to pdf for printing, I am getting extra pages after every good page with just
> > a header printed on those pages.
> > I tried decrease the size of the report and make sure that it fits into 8
> > 1/2 x 11 inches, but it did not help.
> > I still have those annoying empty pages in the printed report.
> > Any other suggestions on how can I fix it?
> > Thank you.
> >

Extra Blank Page at end of Report

I have a crystal report and it is printing an extra blank page at the end. I have the detail ruler coming right up to the end of the text and I have surpressed the report header and footer. Any idea?In the section expert window, check if the 'New page after' options is checked for any of the sections.

If so, try this:
click on the X+2 button to the right of it and enter the following formula
Not OnLastRecord|||Thanks! In the Page Footer Section Expert, it is checked, but is greyed out so I can't uncheck it or alter it (see attached shot). Do you know how to un-grey it out?

Thanks,
Michael|||:) No, this is not the case...

Sorry, I didn't mention but I meant Detail, GH, GF sections, for which you would be able to uncheck the 'New Page after' option.
How about the 'New Page before' for the RF section? Is it checked?|||Yes...but it is greyed out like the page footer :(|||...'New Page Before' for the RF ?

Check this, may be you will find it useful:

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=http--supportbusinessobjectscom-communityCS-TechnicalPapersNoNav-crremoveblankspdfasp&sliceId=&dialogID=4246102&stateId=1%200%204244224

Actually, your situation is strange for me: you have no groups in the report just Details...

extending report server to support printing

Hi all
I am following the 'Deploying the Printer Delivery Sample' in order to add
printing functionality to reports.
After compiled code was put in both the reports server's and manager's bin
directories( and thier config files were
set accordingly), I can see the new printing delivery extension listed by
the server side (using the report server web service method
.ListExtensions(ExtensionTypeEnum.Delivery);).
But.. no sign for that extension when i open reports in the html viewer nor
in the subscriptions deliveries options..
I am not sure exactly where should i expect to see it if at all.. should i
create a button which will call the printing extension on click event'
I know that in the reports manager it should be listed in the subscription
deliveries options.
Another thing is that i am not sure i have added the codegroup section in
the *policy.config files correctly.
In the reports manager config file i had to remove it because it generated a
'no object reference' error..
I guess this should interfier at some point.
Thanks alot for your attention
ReaHi Rea:
Check Bryan's blog for some clarification on the codegroup placement:
http://weblogs.asp.net/bryanke/archive/2004/05/14/132110.aspx
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 26 Oct 2004 16:05:50 +0200, "Rea Peleg" <rea_p@.afek.co.il>
wrote:
>Hi all
>I am following the 'Deploying the Printer Delivery Sample' in order to add
>printing functionality to reports.
>After compiled code was put in both the reports server's and manager's bin
>directories( and thier config files were
>set accordingly), I can see the new printing delivery extension listed by
>the server side (using the report server web service method
>.ListExtensions(ExtensionTypeEnum.Delivery);).
>But.. no sign for that extension when i open reports in the html viewer nor
>in the subscriptions deliveries options..
>I am not sure exactly where should i expect to see it if at all.. should i
>create a button which will call the printing extension on click event'
>I know that in the reports manager it should be listed in the subscription
>deliveries options.
>Another thing is that i am not sure i have added the codegroup section in
>the *policy.config files correctly.
>In the reports manager config file i had to remove it because it generated a
>'no object reference' error..
>I guess this should interfier at some point.
>Thanks alot for your attention
>Rea
>
>

expression for count on a field

Can anybody point me in the right direction please?

I am printing labels. And have got this problem.

The total quantity for example is 250 all with different labels fields.

What I need is:

1 of 250

2 of 250

Example of label field: IAC-000245

This is my expression:

=CountDistinct(Fields!ASSETNO.Value)

But the result is is giving me 250 for all labels it should be 1 or 2 or 3

The end result will be:

=CountDistinct(Fields!ASSETNO.Value) & " to " & Fields!QUANTITY.Value

Kindest Regards

This may work for you...

=RunningValue(1,Sum,Nothing)

To append a string, you may need to convert the Running Value to a string.

cheers,
Andrew|||

Thank you it worked like a dream