Sunday, October 20, 2013

How Create linked Reports in NAV 2013/RTC

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

  • 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






2 comments:

  1. Have you been able to apply a filter on a decimal field? I cannot do it.

    ReplyDelete
  2. Have you been able to apply a filter on a decimal field? I cannot do it.

    ReplyDelete