I am trying to adjust my SSRS report to print only 10 lines per page. I am using this expression on a new group I added and putting this as the Group On Expression.
=Floor((RowNumber(Nothing) - 1) / 10)
When I go to preview the report I get this error message.
A group expression for the table ¿¿ uses the RowNumber function with a scope parameter that is not valid
The dataset name is RFQDetail. Do I need to add the dataset name to this expression. If so, what is the correct syntax?