0

Drilldown Error

Jet Reports Historic Posts

May 28, 2009 00:16

None

Follow

Hi,

When trying to drill down on a cell in a report, I get this message"Jet Reports does not know the drilldown form for table "FA Depreciation Book".

The report is a summary of FA movements during the period. If we need more detail, I want to be able to drilldown to the entries which make up the movements. Report attached

Thanks

Stuart

• FA Mvmts.xlsx

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts May 28, 2009 13:41

  The table FA Depreciation book does not have a drilldownform in Navision (5.1)
  You also try to get the value from flowfields. If there was a drilldownform for this table big chance its the listform of the depreciation book and you want the ledger entries I presume.
  You can ask your programmer but this is easier:
  Try to use instead of the NF for the flowfield for example NL("Sum";"FA Ledger Entry";"Amount";"FA No."; $C5 ; "Depreciation Book Code";filterreference;"FA Posting Date";datefilterreference). The FA Ledger Entry has a drilldownform so should work.
  Maybe your report takes longer time and you have to set more filters in this formula but should work.
  
  See also help JET Reports–> Drilldown
  
  Other little things
  try not to use column B in your report only for Jet instructions like conditional hides.
  In your option menu use Option instead of Options and put Title Value and Lookup in row 1.
  succes
  
  Greetings
  Hans D.

• 0
  
  Jet Reports Historic Posts May 29, 2009 00:33

  The table FA Depreciation book does not have a drilldownform in Navision (5.1)
  You also try to get the value from flowfields. If there was a drilldownform for this table big chance its the listform of the depreciation book and you want the ledger entries I presume.
  You can ask your programmer but this is easier:
  Try to use instead of the NF for the flowfield for example NL("Sum";"FA Ledger Entry";"Amount";"FA No."; $C5 ; "Depreciation Book Code";filterreference;"FA Posting Date";datefilterreference). The FA Ledger Entry has a drilldownform so should work.
  Maybe your report takes longer time and you have to set more filters in this formula but should work.
  
  See also help JET Reports–> Drilldown
  
  Other little things
  try not to use column B in your report only for Jet instructions like conditional hides.
  In your option menu use Option instead of Options and put Title Value and Lookup in row 1.
  succes
  
  Greetings
  Hans D.

  
  
  Excellent! Thanks Hans, works just how I want it to :)