I've created a user function in the report class in an attempt to calculate a page number that breaks by group (according to details found in a MSDN post referred to by an earlier thread here). In short, I pass into my function the field upon whihc my group is based (clientID) and the global value for page number, and sue these values to calculate a new page number.
I then use this function as the expression on a text box in the page footer.
When I view the report I get an error stating that the clientID is not available in that context.
Any ideas on how I can approach this issue? I'm thinkin that pehaps I can attach to an event on the group and capture the current clientID in a variable that the function would ahve access to?
Any ideas or direction would be helpful.
Thanks
David C
I then use this function as the expression on a text box in the page footer.
When I view the report I get an error stating that the clientID is not available in that context.
Any ideas on how I can approach this issue? I'm thinkin that pehaps I can attach to an event on the group and capture the current clientID in a variable that the function would ahve access to?
Any ideas or direction would be helpful.
Thanks
David C