guyinkalamazoo3


I have a form that uses some header information (like client ID with name, address, etc) and then uses a table for orders that customer has placed. I now need to print something like a page number (but not in the header or footer). When I try RowNumber, this does not work as the dataset is returning multiple records for the first customer and then the next item in the list (the next customer ID) skips the number of records from the first. So I need the first one to have 1, the second to have 2 and so on. I tries RunningValue, but for each record it starts back at 1. What I need is like a counter.

How would I go about this and thanks for the help.




Re: RunningValue question

Hammer2


guy,

what was the scope of your runningvalue expression

Ham







Re: RunningValue question

guyinkalamazoo3

I was using the dataset itself and then I tried the table that holds the orders.




Re: RunningValue question

Hammer2

Try

RunningValue(MyFieldsCount.value,Count,Nothing)

Is will eliminated the scope and you should then get continously counting rows.

Ham






Re: RunningValue question

guyinkalamazoo3

Using this I get an error message about aggregate functions only being allowed to use report items contained in the page header or page footer.



Re: RunningValue question

Hammer2

Guy,

I thought that you were not trying to place this in the header or footer and that you wanted a way to have a continues count of your rows, maybe I'm missing something, are you trying to get a page count, row count, and some of count

Ham






Re: RunningValue question

Hammer2

should read "some other count"