I have to print 15 records per page in ssrs report.
I'm using rectangle which is having only one table as data source.
Steps:-
1.Added a row group which is existing top level group.In group expression I wrote the expression as CEILING(Row Number(Nothing)/15),where 15 is number of records to display per page and unchecked group header and footer unchecked.
2.On the Page Breaks section of Group Properties, checked “Between each instance of a group.”
3.Next, go to the Sorting section of Group Properties and delete the sorting.
Now while deploying the report I am getting the following error:-
1. A group expression for the grouping 'Group 1 object uses the Row Number function with a scope parameter that is not valid. When used in a group expression, the value of the scope parameter of Row Number must equal the name of the group directly contains the active group.
Can anyone please help?
*This post is locked for comments
I have the same question (0)