Solved

report+Navision 5.0

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

706 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now