Solved

report+Navision 5.0

Posted on 2011-09-02
4
903 Views
Last Modified: 2012-05-12
i have created a report in navision.
i have a field of type Decimal but in case the value doesn't have a decimal part i don't want to show the ".00".
1.00 ----> 1
please advise.
0
Comment
Question by:MKItani
  • 2
  • 2
4 Comments
 
LVL 2

Expert Comment

by:adrianakers
ID: 36473055
You will struggle doing this on a field in a Form or on a Page.

If you are doing this as an export in a file for example you could use the format expression.

An example would be;

MESSAGE(FORMAT(1.232423, 15, '<Precision,0:0><Standard Format,0>'));

Above would return '1'

MESSAGE(FORMAT(1.232423, 15, '<Precision,2:6><Standard Format,0>'));

Above would return '1.232423'

You could then put code on the export to identify if you have a whole (integer) or decimal value and use the correct format accordingly...
0
 

Author Comment

by:MKItani
ID: 36477531
T U adrianakers,
i have a lot of experience in .net and crystal report, but i am still new in navision so please take this into consideration.
no i want to do that on the report at design time.
in my report i have a lot of fields and on the one of fields i what to set this special format.

regards,

0
 
LVL 2

Accepted Solution

by:
adrianakers earned 500 total points
ID: 36482740
You can always use a global variable on your report and set it to the associated value. Then just make sure you are showing this variable on the report.

The global variable would be of type Text and then you could use the format expressions mentioned above.
0
 

Author Closing Comment

by:MKItani
ID: 36587118
not what i am looking for
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question