Without the page caching, the number get incremented too many times. Apparently, the page header before generate eep can fire more than once.
Without it, my page 2 had vCurrentPageNumber = 5 Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Tuesday, October 01, 2013 4:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Capture rep[ort page number to variable??? Good to know it works! I also have never fooled around with the "page cache" setting before. Karen -----Original Message----- From: Dennis McGrath <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Tue, Oct 1, 2013 4:11 pm Subject: [RBASE-L] - Re: Capture rep[ort page number to variable??? I wound up putting the variable increment in the Page Header Before Generate eep because I needed it to be correct in the before generate eep. The key is turning page caching on. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Dennis McGrath Sent: Tuesday, October 01, 2013 1:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Capture rep[ort page number to variable??? I’ll sure try it It may not work because I am using 2 pass but we will see. I love the system variable for their ease of use, but I sure miss the pure functionality of the old #PAGE variable for this particular job. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Tuesday, October 01, 2013 1:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Capture rep[ort page number to variable??? Dennis: I've never tried that before, but looking in my notes document, I found the following code that I saved. Could this help you? If you need to manipulate page numbers,: 1. Main Menu | Report | Actions | Before Generate ... SET VAR vCurrentPageNumber INTEGER = 0 ; RETURN 2. Enable Cache Pages option Main Menu | Report | Cache Pages (default is set to OFF) 3. Right-click on Page Header Band | After Generate Custom EEP ... SET VAR vCurrentPageNumber = (.vCurrentPageNumber + 1) Karen -----Original Message----- From: Dennis McGrath <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Tue, Oct 1, 2013 1:24 pm Subject: [RBASE-L] - Capture rep[ort page number to variable??? I want to hide a region based on the report page number. I understand #page no longer exists, so how can I test the page number? Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]<mailto:[email protected]>
