Dynamic URL with filters on RTC report

mtlmonk

Hello,

I need to build a URL that will launch a page from a clickable text field in a RTC report. So far, I've been able to pass in 2 string filters but need to enter another one with a filter > 0.


This works:
="dynamicsnav://///runpage?page=123456&$filter='Contract%20No.'%20IS%20'''%40" + First(Fields!Contract_No.Value) + "'''%20AND%20'Change%20Order%20No.'%20IS%20'''%40" + First(Fields!MLURLChangeOrderNoFilter.Value) + "'''"

But need to add another filter that will look for a value greater than 0.

This DOESN'T WORK:
="dynamicsnav://///runpage?page=123456&$filter='Contract%20No.'%20IS%20'''%40" + First(Fields!Contract_No.Value) + "'''%20AND%20'Change%20Order%20No.'%20IS%20'''%40" + First(Fields!MLURLChangeOrderNoFilter.Value) + "'''%20AND%20'Qty.%20Remaining%20to%20Release'%3E0"

I believe that %3E at the end is the > symbol

mtlmonk

Anybody?

SeeSharp

I think you're missing the "IS" keyword after the column name and before %3E

mtlmonk

Thank you so much! It worked.