I want to ask if there is a way to make all reports use BlankZero = Yes without needed to open them separately and change BlankZero for every numeric control.
I export some reports in text files and noticed that there were some numeric fields with BlankZero = No. Since the default value is <Yes> shouldn't I be able to write some code when finds BlankZero = No to make it Yes?
I export some reports in text files and noticed that there were some numeric fields with BlankZero = No. Since the default value is <Yes> shouldn't I be able to write some code when finds BlankZero = No to make it Yes?
Maybe this is some king of solution.
Problem is, that default values are not exported in the text. If you have somewhere No, you can do just search&replace in the text file. But you still needs to change the property BlankNumbers to "BlankZero" too...
and one thing:
The property shows you that default is yes (but only if the used variable is field from table and the property on this field is set to yes), but in on-line help you will find that:
Blank zeros and No Yes
Display zeros and No No (default)
The default value of BlankZero on the report depends on the value of this property of the table field you use in the SourceExpr. If the field has Yes, the default on the report will be Yes... but in general, this property is No by default...
Yes I know all that. If it is a field from a table then the default value is Yes but if it is a variable (decimal) the default value is No.
So I am working on Visual Basic to make a project that it will read the text file and remove all references to BlankZero. Then it will scan the whole file again collecting the fields from SourceExpr property and all the decimal variables from the end of the text file. Now scan it again from the beginning I will be able to add to all decimal fields the BlankZero=Yes and for all variables that were decimal I have the ID (TotalsDB@1420079 : Decimal;) and i will know where to put the BlankZero=Yes.
Comments
Rajesh Patel
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Maybe this is some king of solution.
Problem is, that default values are not exported in the text. If you have somewhere No, you can do just search&replace in the text file. But you still needs to change the property BlankNumbers to "BlankZero" too...
and one thing:
The property shows you that default is yes (but only if the used variable is field from table and the property on this field is set to yes), but in on-line help you will find that: Where is the truth? ;-)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
The default value of BlankZero on the report depends on the value of this property of the table field you use in the SourceExpr. If the field has Yes, the default on the report will be Yes... but in general, this property is No by default...
This make it more complicated...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
So I am working on Visual Basic to make a project that it will read the text file and remove all references to BlankZero. Then it will scan the whole file again collecting the fields from SourceExpr property and all the decimal variables from the end of the text file. Now scan it again from the beginning I will be able to add to all decimal fields the BlankZero=Yes and for all variables that were decimal I have the ID (TotalsDB@1420079 : Decimal;) and i will know where to put the BlankZero=Yes.
I think this will be a very nice utility.