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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Footer of the report is half-visible in two-column report

Status
Not open for further replies.

AndrewMil

Programmer
Jul 11, 2000
6
UA
I have a two-column report. When I preview or print it the footer with totals and other final information is visible in a half: the contents is visible only to right margin of the first column. When I set the ColumnCount to 1 the footer is visible good. What to do to correct the situation?<br>Thank you, Andrew
 
Do you need 2 footer sections? I mean are you totalling 2 different columns of stuff, or is it all totalling to one field or group of fields? Is it that you just want the total showing up twice on the report? More detail please!<br>=)
 
I need simple one-column footer. Two column is only the detail section where are placed prices (to effective using of the page space). Below is showed the template of my report. I need the ADDITIONAL INFORMATION occupy all space from first GOODS column to second PRICE2 column.<br><br>&lt;Header section&gt;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COMPANY NAME<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Address <br>----------------------------------------------------<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRICE-LIST<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dated ........<br><br>&lt;PageHeader Section&gt;<br>----------------------------------------------------<br>&nbsp;goods ¦ price1 ¦ price2&nbsp;&nbsp;¦¦ goods ¦ price1 ¦ price2<br>----------------------------------------------------<br>&lt;Detail Section&gt;<br>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;¦¦ .....&nbsp;&nbsp;&nbsp;.....&nbsp;&nbsp;&nbsp;&nbsp;...... <br>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;¦¦ .....&nbsp;&nbsp;&nbsp;.....&nbsp;&nbsp;&nbsp;&nbsp;...... <br>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;¦¦ .....&nbsp;&nbsp;&nbsp;.....&nbsp;&nbsp;&nbsp;&nbsp;...... <br>----------------------------------------------------<br>&lt;End of Detail Section&gt;<br>&lt;Footer Section&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ADDITIONAL INFORMATION<br>.....................................................<br>.....................................................<br>.....................................................<br>&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;Signatures<br><br>&nbsp;&nbsp;&nbsp;.......................<br>&nbsp;&nbsp;&nbsp;.......................<br>&lt;End of Footer Section&gt;
 
Is your additonal information area just one field? Is it a combo box or list box?&nbsp;&nbsp;It sounds to me like all you have to do is stretch out the control in the footer.....but maybe I am not understanding you. I'm sorry if I am not terribly helpful, but I am trying! So you want it to look like this:<br>&lt;Detail Section&gt;<br>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;¦¦ .....&nbsp;&nbsp;&nbsp;.....&nbsp;&nbsp;&nbsp;&nbsp;...... <br>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;¦¦ .....&nbsp;&nbsp;&nbsp;.....&nbsp;&nbsp;&nbsp;&nbsp;...... <br>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....&nbsp;&nbsp;&nbsp;&nbsp;¦¦ .....&nbsp;&nbsp;&nbsp;.....&nbsp;&nbsp;&nbsp;&nbsp;...... <br>----------------------------------------------------<br>&lt;End of Detail Section&gt;<br>&lt;Footer Section&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ADDITIONAL INFORMATION<br>...........................................................<br>...........................................................<br>...........................................................<br>&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;Signatures<br><br>&nbsp;&nbsp;&nbsp;.......................<br>&nbsp;&nbsp;&nbsp;.......................<br>&lt;End of Footer Section&gt; <br><br><br>So everything is all even? Is that the problem?&nbsp;&nbsp;or is it not showing all the information at all? If it's just that the information isn't fitting, stretch the box out. If the information isn't showing up at all, maybe the control isn't bound to the right source, or there is some other problem. I don't know enough details about it to really say. good luck!<br>
 
There are many object in the footer: labels and fields. When I am in Report Constructor (or Builder, I work with russian version of Access97 and my terms maybe incorrect) all objects are fully visible. But when I PREVIEW or PRINT the report the parts of objects which are right to first column PRICE2 are invisible. I understand how to stretch out the control.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top