Pass Multiple Parameters in Jump To URL option in Navigation Properties in RTC report

Business Central/NAV Developers Forum
1

Hi,

I want to pass multiple parameters in Jump to URL option in Navigation properties in RTC report. I am able to pass single parameter and unaware of passing the second parameters, can any one help me out.

I have passed single parameter as below

=

“dynamicsnav:////runreport?report=50024&filter=Item.%22Product Group Code%22:” +Fields!Product_Group_Code.Value

and want to pass the second parameter from Value Entry.“Source No”

Thanks

John

2

What problem are you facing in adding second parameter?

what link did you try?

3

Hi Mohana,

I dont know how to add second parameter, need the syntax for multiple parameters, could not find aywhere

Thanks

4

Try

DynamicsNAV:////runreport?report=104&filter=Customer.City:M*&filter=Customer.Name:A*

5

Hi Mohana,

Tried following but with error : “The Filter string contains Invalid Parameters”

=“dynamicsnav:////runreport?report=50024&filter=Item.%22Product Group Code%22:&filter=Value Entry.%22Source No.%22:” +Fields!Product_Group_Code.Value + Fields!ValueEntryBuffer__Source_No__.Value

6

I am not sure whether we can pass filters to multiple dataitems or not…but we can pass multiple filters to one dataitem… the syntax is =“dynamicsnav:////runreport?report=50024&filter=Item.%22Product Group Code%22:”+Fields!Product_Group_Code.Value +"&filter=Value Entry.%22Source No.%22:" Fields!ValueEntryBuffer__Source_No__.Value

7

Hi Mohana,

It works with Multiple Dataitems as well, Thanks a Lot.

8

Thanks for confirming…