How to remove Blank Space in a report

[Tanweer]

I am using a report which is based on a query and has a subreprot in it. The
problem I am having is a report whcih should come in two pages coming in 4
pages as my main record print on first page and subreport record print into
another page and I tried can grow can shrink property but it is not helping.
Is their any thing I need to do to take care of this space issues.

Thanks
Tanweer

 

[Jeff Boyce]

Tanweer

Have you use the CanGrow/Shrink properties for both the control
(?subreport?) and for the section in which the control is placed?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tanweer]

I start using the articel I saw in MS KB
ACC2002: Keeping Subreport or Text Box Data Together on a Page
View products that this article applies to.
Article ID : 292050
Last Review : November 6, 2003
Revision : 1.0
This article was previously published under Q292050

This seems to eliminate atleast lot of white spaces.

What to do If I have no data in subreport how to not show the section
Thanks

 

[Jeff Boyce]

Tanweer

If the subreport has no data, you want it to shrink, right? Have you set
CanShrink property on the subreport control in the main report?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tanweer]

I used this article which work on one report
MY subreport has so much data it span to two pages when I print my report I
get first page with main report data which is by the way only four line
covering only quarter of page
Second page come up blank
Third page has data from Subreport
Fourth Page has data from Subreport

My question how I can force it to start from first page printing subreport
data and how to avoid second blank page.
My Mian report controls are in Detail section
and subreport is pasted under artifical footer 1

Thanks
Tanweer


ACC2002: Keeping Subreport or Text Box Data Together on a Page
View products that this article applies to.
Article ID : 292050

 

[Jeff Boyce]

Tanweer

?Is the subreport property set to "Keep Together"? It sounds like the
subreport believes it cannot start until it is at the top of a new page.

Or is there a chance the property concerning what to do before/after the
subreport control indicates starting on a new page?

These are the only things I can think of...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tanweer]

I am not sure wher eto check for these setting

The group 1 property where the subreport is dropped has the setting called
keep Together is enabled.

?Is the subreport property set to "Keep Together"? It sounds like the

subreport believes it cannot start until it is at the top of a new page.

Thanks
Tanweer

 

[Jeff Boyce]

What happens to the report if you disable that?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tanweer]

Stay the same can I send you the Mdb file with the report just to take a
quick look into it.

Thanks
Tanweer

 

[Jeff Boyce]

I've run out of ideas here.

Since the assistance provided in these newsgroups is essentially voluntary,
it probably wouldn't be appropriate (or necessary) to send your .mdb file.
It may be that other newsgroup readers have an idea that can help.

If you don't have time to continue trying to puzzle this out, and need
someone to look at your database, perhaps a local college/university has
someone, or you may decide to hire a consultant...

Best of Luck

Jeff Boyce
Microsoft Office/Access MVP

 

[Tanweer]

I do have time and want to resolve it here in this negroup as this is the
best place if I can't resolve it here than it is very hard to resolve by
others.

I am going to close this and open a new trace to track it from start.

Appreciate all your help.

Thanks
Tanweer

 

[Brian Bastl]

Hi all,

I didn't see it mentioned here, and it's probably not relevant to this
particular issue, but whenever my report's controls encroach into the
margins, I always end up with blank pages.

Brian

 

[Jeff Boyce]

Good catch, Brian.

I wondered about that, but took Tanweer's literally ... page 1, main report
& blank space, page 2 & 3 subreport. Maybe I missed the description of an
extra blank page...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[maqsood]

My question how I can force the sub report that if it is blank,so it will be
hide and if it has some data ,so i forced to the sub report that when the
data will displayed then page will be break automatically.



Thanks

url:http://www.ureader.com/msg/10657558.aspx