Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

report+Navision 5.0

Posted on 2011-09-02
4
Medium Priority
?
912 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

722 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