Hi
I want to make a hierarchical report by selecting 2 dimensions (like dimension detail in NAV Standard). Also I want the new dimension whenever added to NAV to be updated in the Jet Report by refreshing.
Is it possible with Jet Reports? If it's possible, can someone please suggest some hints?
Thanks in advance.
AS
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi aryus,
I am a little confused as to what you are asking for. Jet Express created tables of information or static GL reports. If you are using the Table Builder to create your report and are listing out dimensions from NAV, if you add a new dimension value, the next time you run the report it will appear. It might help us to if we could see the report you have and what you want it to look like - I feel like I might be missing something from your post. -
Jet Reports Historic Posts I am not exactly sure what you mean, but here is my interpretation of your question…
If you want to be able to select the various dimensions, you need to select them from the DIMENSION VALUE table.
Inside this table there are 2 key fields:
The DIMENSION CODE field which is the user defined name of Global Dimension 1, Global Dimension 2, Shortcut Dimension 3 etc.
The CODE field which is the actual dimension value for any given dimension.
There can be any number of CODE records for each DIMENSION CODE.
I hope this helps. -
Jet Reports Historic Posts Seems its possible using table builder. My requirement is to prepare a report using G/L Account, Global Dimension 1 and Global Dimension 2. Below is the structure
Account_______________________________________Net Change
=======================================================
G/L Account
____Global Dimension 1 Code
________Global Dimension 2 Code
Making static report is no issue for me. Global Dimension 2 values are added frequently by NAV users and this should also appear in Jet Reports dynamically. I hope my question is now more clear. Thanks. -
Jet Reports Historic Posts I appears that you are trying to create what is commonly referred to as a "Grouping Report" (list all the GD1 codes related to the account then list all the GD2 codes related to both of those, etc.).
You can create an NL(Table) that returns all the information you need from the records (account numbers, GD1 codes, GD2 codes, etc) and then create a pivot table based on the Excel table that is returned [by that NL(Table)] and in the pivot table you can group the items as desired.
I hope that gets you pointed in the right direction.
You may want to also take a look at the video tutorials on the Jet Express Resource Center http://jetexpress.jetreports.com/index.php
Please sign in to leave a comment.