Hello,
So I created a report where the end user is looking for price changes on their item. Using Microsoft Dynamics NAV, I pulled the information via table builder using the following tables: Price History, Item, and Change Log Entry. The most needed info comes from the change log entry table where I need the 'old' and 'new' value. I was able to get the new value from a different table but is having a slight problem with the 'old' value. Because in NAV, that value is a general number, when it is generated in the report, it does so as a general number and will not allow me to change it to reflect that it's a currency.
I've tried using a pivot table but it's the same outcome. Can someone shed some light on what I may be doing wrong/right?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hello StacyF.
In a Table Builder report, the data is always displayed based on the "type" of data it is (as defined within the database).
In the example you talk about, your "old" value is defined within the database as being a general number… not currency. Thus, it will always appear as such in the results of an NL(Table) function.
You could, instead, build a report using NL(Rows) and other Jet functions to return the same data. You would then be able to change the format of various cells to reflect how you wanted the data to appear in your report.
I hope that helps. -
Jet Reports Historic Posts I figured that would be the other option, using the Function wizard. That definitely helped as it confirmed my suspicions.
Thank you
Please sign in to leave a comment.