Hi all,
below example will show how to link a Report/Page to another report, lets assume customer summary report needs to be linked with customer trial balance, so that user clicks the amount field in customer summary report then customer detail trial balance should run automatically and show the balance
below example will show how to link a Report/Page to another report, lets assume customer summary report needs to be linked with customer trial balance, so that user clicks the amount field in customer summary report then customer detail trial balance should run automatically and show the balance
- Create a report using Customer table as data item as like below
- Go to View -> Layout
- Design the report as like bvelow
- Go to the properties of the [Balance] column -> Action -> URL
- paste below code at Select URL field , First one will run report without any filter
- ="DynamicsNAV:////runReport?Report=104
- ="DynamicsNAV:////runReport?Report=104&$filter=Customer.'No.'%20IS%20'"+Fields!CustomerNo.Value+"'"
- Save and run the report from NAV above code will run report 104 when the user clicks the amount field of newly created report
- Applicable for Dynamics NAV 2009 RTC Client/ NAV 2013
Thanks
Jerome Marshal. J
Have you been able to apply a filter on a decimal field? I cannot do it.
ReplyDeleteHave you been able to apply a filter on a decimal field? I cannot do it.
ReplyDelete