SSRS - Invalid group expression

(0) Share

Report

Posted on by Kedar Dande

640

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)

All responses (2)

Answers (0)

Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

The error says that Nothing is an invalid scope parameter of RowNumber() and that you should use a name of a group name. It makes sense to me.

Was this reply helpful? Yes No
Suggested answer

venkatesh vadlamani 3,180 on at

Like (0)

Report

try using the DS name in scope

Was this reply helpful? Yes No