Aged Accounts Receivable

Navi_Learner · 2005-10-21

How to change the font name and font color of the field in the aged accounts receivable report? For example if the there's past due, I want to change the past due amount's font name to Arial bold and font color to red.
Thanks in advance!

kine · 2005-10-21

There is no runtime property for that. You can only prepare more sections with the data in different fonts and select the right section when printing...

Edward_Bloomfield · 2005-10-21

NB Colours do not work in Navision reports either - If you search the forum you will find some work arounds for this.

Navi_Learner · 2005-10-22

But How to create a section with different font name on the past due amount and how to write the code? Thanks

kine · 2005-10-24

You will create two sections with same fields (controls). In one section, you change the font properties (you have special toolbox for this or you can use property window). In OnPreSection trigger of both sections you add code like:

CurrReport.SHOWOUTPUT(Your condition);

in second one you will use code like:

CurrReport.SHOWOUTPUT(NOT(Your condition));

Where "Your condition" can be something like "Due Date"<TODAY etc..

Savatage · 2005-10-24

maybe he is looking for something even simpler than that. (not sure)
but anyway.

Tools->Object Designer->"Aged Accounts Receivable" report->Design->View->Sections

Right Clickon the field you want to change->Select "properties"

Scroll Down to FontName, FontSize, FontBold, FontItalic and play with those. You can also click on the property Name (ie. FontName) & hit F1 for details.

The name does say "Learner"

kine · 2005-10-25

Ah, sorry, it is my mistake (didn't read it carefully) - but there will be one problem - the color :-) You can change the color, on preview it will be OK, but on printer it will be still black... but it is normal and it will be never changed...

Navi_Learner · 2005-11-29

Thank you! Recently I tried to create two sections based on the suggestion of Kami, but it doesn't work either. In my report, there are 30 days, 60 days past due and I created the array for instance amount[1] for 30 days, amount[2] for 60 days. If I write the condition like this amount[2]>0, there's error message telling me that array doesn't work that way, and so how I can write the code using the array? Thanks in advance!

kine · 2005-11-29

It must work, if you did not forget to define the variable as array (entering Dimension in variable properties)...

Navi_Learner · 2005-11-29

Thank you, Kamil! It works perfectly.

Aged Accounts Receivable

Comments

Categories