Javed,
I have tried your function in an other report and it seems that it works very fine as long as you do not have any sub-sections under the main section. If you have subsections BO performs the function on each subsection. I had a first main section, with on the first page 3 sub-sections the and on the second page 4 subsections. That gave me page number 31+42=12 already on the second page. I also have tried to use runningmin and runningmax but that gives sometimes an good result and than suddenly after +/- 5 main sections a wrong page-number. The parentheses are included by BO because there are in this report-file more subreports with each an other query but all with the same database-objects (in this case the database object is ‘SC’ and the query is ‘Type01’)
Christophe,
I don’t know how many sections I will have because that depends on the input of the user. I ask the user for a list of items (in this case Sample codes: SC) and for each item in that list I want to print a report.
Gijs Damen
Tessenderlo Chemie
From: Javed Maqsood[SMTP:jmaqsood@IX.NETCOM.COM]
Gijs,
It seems like you did not clone the entire formula. Try the formula below…
=“Page “&FormatNumber(Page()-RunningSum(( If <SC(Type01)><>“XXX” Then Page());<SC(Type01)>)+1,”#”)
Try one other thing - Rename your object SC(Type01) to a name that does not
have a parentheses. Sometime parentheses in formulas gets the BO parser
confused.
Javed Maqsood
Context Integration
From: Christophe GROS[SMTP:CGROS@SANDERS.FR]
If you have a small number of sections, you can create in your document a
report for each section, with a global filter for each report based on the
section concerned
Listserv Archives (BOB member since 2002-06-25)