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

Report with subreports: location of text field under sub reports

Status
Not open for further replies.

Sashanan

Programmer
Jan 19, 2001
235
NL
I have a report which also has several subreports in a formation much like this:


------REPORT--------
- -
- xxxx xxxx -
- xS1x x x -
- xxxx x x -
- xS3x -
- xxxx x x -
- xS2X x x -
- xxxx xxxx -
- -
- total -
- -
--------------------

(Doesn't look exactly the way I wanted to without a fixed width font, but hopefully you get the idea. Two small subreports, S1 and S2, on the left and a bigger one, S3, to the right of them.)

The nature of the report required me to put all these subreports in the footer. My problem is that the 'total' text field in the bottom left corner, which adds values from subreport 1 and 2, has its position based on where S3 ends. If the end of S3 turns out to be beyond that of S2, all is fine. But if S2 turns out to be longer, which happens in certain cases, the total is written right over the results of S2 and makes them unreadable.

What I'd like is that the 'total' textfield bases its position on where S2 ends, not on where S3 ends. But I have no idea how to achieve that, as far as I can tell the total just decided by itself that appearing after the end of S3 would be a nice idea. I certainly didn't set it up that way intentionally.

I've been trying some things like moving or stretching S2 and S3 a bit, but no matter what I do with them, it doesn't seem to change the situation any. The total stubbornly keeps appearing right after where S3 ends. Can anybody help me here?



"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)
 
You should be able to utilize the Report footer of the second subreport which is visible, and of course will always appear after the detail section....

Let me know if this helps....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top