Hello,
I want to create hyperlink in report to open page with filters "Global Dimension Code 1" = X and "Global Dimension Code 2" = '' {empty}.
Text001 := dynamicsnav:////runpage?page=20&$filter='G/L Entry'.'Global Dimension 1 Code' IS %1 AND 'G/L Entry'.'Global Dimension 2 Code' IS %2
STRSUBSTNO(Text001, x, '');
Result: no filter at all.
It works perfect with no empty filters. Did anyone have/solve this problem? Please help.