Options

NAV 2013 R2 Standard Customer Statament Report 116

abz_tecmanabz_tecman Member Posts: 27
edited 2014-06-28 in NAV Three Tier
Replicateable in Cronus 2013 R2, Run Customer Statement 116 for customer 10000 Canon Group or 61000 Fairway Sound with the following parameters:

Start Date 01/01/2011

End Date 27/06/2015

Show Overdue Entries = YES

Include All Customers with a Balance = YES

Aging Band Period Length = 1M + CM

Aging Band by: DUE DATE

Log interactions = Yes

2844.Customer-Statement-000.jpg

We get error:

0435.Customer-Statement-001.jpg

An error occured during local report processing.

The Hidden expresison for the text box 'textbox3' uses an aggregate function with an expression that returned a data type not valid for the aggregate function.

The Hidden expresison for the text box 'textbox3' uses an aggregate function with an expression that returned a data type not valid for the aggregate function.



Textbox3 has an expression

=(Fields!TotalCaption.Value) &Fields!CurrencyCode4_CustLedgEntry2.Value

with a hidden expression of

=iif(Sum(Fields!RemainAmt_CustLedgEntry2) <> 0 , true, false)

If the renderer can calculate a sum that is not equal to zero then show the data in textbox3.



To overcome this error i've had to remove the show/hide visibility expression completely and set it to always show.

It's working for now but I would like some opinions/better suggestions if possible.
Abz

Comments

  • Options
    KishormKishorm Member Posts: 921
    It's a problem with the hidden expression - you need to change it from...

    =iif(Sum(Fields!RemainAmt_CustLedgEntry2) <> 0 , true, false)

    ...to...

    =iif(Sum(Fields!RemainAmt_CustLedgEntry2.value) <> 0 , true, false)
Sign In or Register to comment.