Solved

report+Navision 5.0

Posted on 2011-09-02
4
904 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

680 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