Query correction in paginated report

Anonymous — Wed, 08 Feb 2023 10:44:23 GMT

Hi All,

1. Below query i am using to create paginated report:

EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT], 'ContractData'[Months Due], 'ContractData'[EPO Discount], 'ContractData'[SNAPSHOT_END_DATE],
Filter('ContractData','ContractData'[OVER 90]="YES"),
Filter('ContractData',Cast('ContractData'[SNAPSHOT_BEGIN_DATE] as Date)>="@Date"),

RSCustomDaxFilter(@ContractDataCONAME,EqualToCondition,[ContractData].[CO_NAME],String))

2. Created Date parameter and added date parameter in main dataset also.

3. When i run the report, getting below issue.

Could you please tell me is any changes in query or any inputs.

Thank you in advance.

topic Query correction in paginated report in Report Server

Query correction in paginated report