Need help in parameter setup - Paginated report.

Anonymous — Wed, 08 Feb 2023 07:23:29 GMT

Hi All,

Below query i am using to create paginated report:

EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT], 'ContractData'[Due Date], 'ContractData'[SNAPSHOT_BEGIN_DATE], 'ContractData'[SNAPSHOT_END_DATE], 'ContractData'[SKIP], 'ContractData'[60 NON-REPO], 'ContractData'[PICKUP PEND], RSCustomDaxFilter(@ContractDataCONAME,EqualToCondition,[ContractData].[CO_NAME],String))

In main dataset, have two date fields(SNAPSHOT_BEGIN_DATE and SNAPSHOT_END_DATE).

Problem statement: when user selected any single date below query need to used to fileter the data.

Selected Date>=SNAPSHOT_BEGIN_DATE and Selected Date <= SNAPSHOT_END_DATE.

Could you please provide some inputs to create custom date parameter and apply custom date parameter value to filter the data based on above logic.

Thank you in advance.

topic Need help in parameter setup - Paginated report. in Report Server

Need help in parameter setup - Paginated report.