Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set report height = where the last section footer ends

Status
Not open for further replies.

Moogles

MIS
Oct 6, 2002
37
US
Hi,

The last section in my report is a dataenvironment section footer(parent data). The detail section above the footer section is dynamically retrieve from db(child data). The footer section is fixed.
I was unable to set the report height = to the end of the footer section.

Could you help?

TIA
 
just wondering why you want to set the report height and in particular, why at that point. it seems like the 'report' is already done by the time you get to here and the height cannot (then) be set.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Hi, Michael--

I did set the report height at the design time. But when running it, the report height is always longer than what I need. I am trying to let the report ends when the footer section ends. The dynamic height for the detail section is causing me not able to predict how long the report will be.

TIA
 
... but again "WHY". When the report has 'printed' to the footer, it has (presumably) already 'printed' the info preceeding it, so all that is left is the footer. You cannot change what has already been 'printed', and (normally) the report footer will not change (decrease)height without deleting or moving controls.

So, the exercise as described can't be done, and the alternative doesn't seem to be useful.

I rember that the 'report height' is just the sum of the indivisdual section heights, so you cannot "set" it directly, you can only manipulate the (individual) section heights.

I do not know (or understand) what you are attempting to accomplish here, or why it is 'necessary'. The overall report is just whatever the design generates and with the exception of some possible "white space" contraction is not going to change.

Again, I'm just trying to understand this issue. I do not think it can be 'fixed' from the perspective of setting a property during the report instantiation process.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Hi, Michael --

I deleted report header and footer. The report print out in one page without extra space at the bottom.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top