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

WillContinue Property

Status
Not open for further replies.

Pampers

Technical User
Apr 7, 2004
1,300
AN
Hi Everyone,

I want to show a label-control (lblContinue) in report-page-footer (or somewhere else) if the detail-section will continue on the next page. How can I use the WillContinue-property of the detail-section to accomplish this?

Pampers [afro]
Keeping it simple can be complicated
 
First you will need a text box not a label.

I haven't played with will continue but I am guessing if you make your control source the following you will see a -1 for yes and 0 for false.


Code:
= Reports!YourReportNameHere!Section("Detail").willcontinue


Or to display specific text...

Code:
= IIF(Reports!YourReportNameHere!Section("Detail").willcontinue,"Yes","No")

If that doesn't work the solution is more complicated. The jist of it follows but post back if you need specifics. You will need a variable that is scoped to at least the report and set it on the format event of the detail section to the will continue property. Then you can make a function to return it and use it as your control source of the text box.
 
Hi lameid,
Tnx for the reply. Let me give it try. I'll keep you posted.


Pampers [afro]
Keeping it simple can be complicated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top