Visual Studio Report every other only contain header/footer.

Hello,

I have a slight problem driving me crazy.

I created a form with a report viewer launching a report.

First page is fine, looks fine, prints fine.

Every other page (2,4,6 etc.) is blank apart from the header/footer.

I searched this Google thing and a few suggested that components on the page is too wide, but I've tried resizing everything to just be an inch in the middle with no luck.

Any help would be greatly appreciated.

Thank you
~j
LVL 2
prositAsked:
Who is Participating?
 
mlmccCommented:
It would be set in the report.  It may be that the RDLC reports don't have a paper size you can set.

Just trying to figure out why this particular report has an issue.

If you create a new report does it have the same problem?
If not then perhaps just recreating the report will solve the problem

mlmcc
0
 
prositAuthor Commented:
Oh, another thing, the print preview on the screen does NOT have the blank pages...
0
 
mlmccCommented:
Which reporting tool?

In Crystal one cause of this is a field that is slightly wider than the available page width.
or a field that is on the right side of the report that extends past the right margin.

mlmcc
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
prositAuthor Commented:
Oh sorry, it's in the reportviewer built into VS2013.

And the margin thing isn't it, I moved everything to the middle just to try it and it still does it.

~j
0
 
mlmccCommented:
Try taking them off 1 by 1 or take all but 1 off and make it only 1 inch wide.

Another thing that might do it is if you have a page setup that is too wide for the printer.
Most printers have a minimum right and left margin.  The minimum is .25" and you set a margin of only .1", it might cause the same issue.

mlmcc
0
 
Bob LearnedCommented:
Do you have any custom configuration for the layout (rectangles, formulas to hide/show rows, ...), or is it a simple report?
0
 
prositAuthor Commented:
Thank you for the responses, but none of it really worked.  

I decided to recreate the report from scratch and see when things go bad.  On the report query I have three fields that are very narrow on the report and the problem started when I made them smaller.  

So I started looking at the data and those three fields contain NULL values, could that be the problem?  

Just not sure why resizing them makes them freak out...
0
 
mlmccCommented:
Null values generally don't cause issues like that.  However if the field is set to grow, it will grow vertically which might push a field to the next page.  If the value is NULL it could appear to be a blank page.

mlmcc
0
 
prositAuthor Commented:
i'll try and do a replace on the query and see if that was the problem.
0
 
prositAuthor Commented:
So the NULL is not the problem, even if I only have two fields without header/footer that takes up less than half of the page width it prints every other page blank...

Scratching my head I am...
0
 
mlmccCommented:
Can you upload the rpt file?

mlmcc
0
 
prositAuthor Commented:
Maybe that's the problem, I don't have rpt files, they're rdlc's... I've added the form and the report.

~j
0
 
prositAuthor Commented:
It won't let me add the rdlc file...

Grab it from www.funchtech.com/reports.zip

tnx
~J
0
 
mlmccCommented:
I don't have a VS environment so I can't look at an rdlc report file.

The rpt was my fault.  I didn't look up to see you weren't using Crystal.

Is the width of the report too wide for 1 page?
Is there a page view in the report editor?

mlmcc
0
 
prositAuthor Commented:
I tried only grabbing one column and centering it, still does it.
There's a print-preview and in the preview it does not show blank second pages.

The interesting thing is that I took the header and footer out just to make sure, but when they are there it will print the header and footer but not the content.

Very annoying...
0
 
mlmccCommented:
Check the paper size or the paper selected for the printer.  If you are choosing a page that is too large you might get that effect.  I know Crystal defaults to A4 which is slightly different from the normal letter paper used in the US.  That can sometimes cause some issues.

mlmcc
0
 
prositAuthor Commented:
Maybe a dumb question, but the paper size is fine for every other application...

Where are you suggesting changing it?  On the printer?

Reason I ask, if this is the issue, I will have a problem anyway because the application will be printing on 100's of printers across all over the company.

tnx
~j
0
 
prositAuthor Commented:
I've changed every possible setting and I finally found it...

It's the body value of the actual report, not the size of the page which I kept thinking was the most logical place for it...

Thank you for getting me in the right direction.

~j
0
 
mlmccCommented:
Great.  I haven't used that reporting tool (no VS environment) so I didn't know where to look.

mlmcc
0
 
prositAuthor Commented:
At least you got me looking, much appreciated.

Happy Friday
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.