Hi,
I have tried many different things to get this to work but can't, i'm hoping someone on here can shead some light or just tell me it is not possible.
I have a report giving detailed spend by particular individuals and then a sub report in the header that lists the total expenditure for each individual. The report is 125 pages long and although the detail report is in A-Z order the users want their lives made easier.
They would like to have the page number on which their detail appears on the summary report. For Example
Name Amount Page #
Fred £100 7
....
John £250 27
....
Sara £1056 69
To complicate matters further the detail could spread over more than page so just return the first page on which it appears.
Thanks in hopeful anticipation!!
Ant
I have tried many different things to get this to work but can't, i'm hoping someone on here can shead some light or just tell me it is not possible.
I have a report giving detailed spend by particular individuals and then a sub report in the header that lists the total expenditure for each individual. The report is 125 pages long and although the detail report is in A-Z order the users want their lives made easier.
They would like to have the page number on which their detail appears on the summary report. For Example
Name Amount Page #
Fred £100 7
....
John £250 27
....
Sara £1056 69
To complicate matters further the detail could spread over more than page so just return the first page on which it appears.
Thanks in hopeful anticipation!!
Ant
