0

Monthly Mgt Report

Jet Reports Historic Posts

April 06, 2009 02:29

None

Follow

I am working on a report
I need it to produce a consolidated sheet for Global Dim 1 and then for each code in Global Dim 2 a seperate sheet.
The report works however I cannot get it to produce a sheet for the GD2 if it has no income - and obviously if it has expenses I still need it to show.
Any suggestions?

I am using Cronus Aust Pty Ltd, Jet Reports 7.1.2 and Excel 07

• Cronus Management report 090406.xls

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts April 06, 2009 06:55

  In the G/L Entry table you will only find information that was posted. In this case, if you build your report on the G/L Entry table you will only get Dimensions that were posted.
  
  Hence, he Dimensions that were not posted will not be found in this table. You need to use the table in which your Dimensions were setup to create your sheets. This is the Dimension Value table.
  
  In Dynamics NAV you may find it in the Financial Mgt menu -> Setup -> Dimensions -> Dimensions.
  Select the row which describes your Global Dimension 2.
  Select Dimension menu buttion -> Dimension Values.
  
  The Jet Reports function to create Sheets could be like this:
  =NL("Sheets","Dimension Value","Code","Dimension Code,"Name of Dimension 2","Dimension Value Type","Standard")