General information
Category:
Reports & Report designer
>>>>I am trying to print page numbers in column footer of a 2-column report. I intend that the page number will increment in each column, e.g., column 1 of the first sheet the page # is 1, in column 2 of the first sheet the page # is 2.
>>>
>>>In the first column print _PAGENO*2-1, and in the second, _PAGENO*2.
>>>
>>>HTH!
>>
>>Thanks for the idea, it is the right track. But since I'm dumb here, how do I know when I am in which column.
>>
>>If I pute _PAGENO*2-1 in the column footer, it appears in both columns. How do I get _PAGENO*2-1 to print in column one but not column two.
>>
>
>Right, let´s see. You could print _PAGENO*2-(IIF(ODDCOLUMN(),1,0)).
>
>Function ODDCOLUMN should be something like this:
>
>*
>* WARNING!! UNTESTED CODE AHEAD!!
>*
>IF TYPE("WHICHCOLUMN")="U"
> PUBLIC WHICHCOLUMN
> WHICHCOLUMN = 0
>ENDIF
>WHICHCOLUMN = WHICHCOLUMN+1
>RETURN (WHICHCOLUMN%2=1)
>
>After the report, you should RELEASE WHICHCOLUMN.
>
>Hope this is better!
Just tested it and it is right on target!!! :))))
Thanks for the help.
Dave
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only