Handling Debit / Credit columns in a table.

[Desmond]

Hi I have a problem with Telerik Reporting or a challenge ;-)

I have a report of 3 records in a table as shown below and need to display based in value, and total up based upon value...
Field name is Fields.Amount

Description                            Debit                Credit
Product X                                120.00        
Product Y                                240.00
Payment A                                                    200.00
========================================
Totals                                    360.00            200.00
Balance                                160.00


Any help appreciated.

Desmond.

[Desmond]

Just wondering..have I given enough information...always the way...last minute rush for a customer...

Cheers,

Desmond.

[Squall]

Hi, I am not sure but are you looking for the RunningValue function?
SN

[Desmond]

To suppress the values I have found that for negative values...
= IIf(Fields.Amount < 0, Null, Fields.Amount) so in the case of  - 200.00 it would NOT appear in the Debit column.
 Now for negative values on the other side...
= IIf(Fields.Amount < 0, Fields.Amount * -1, Null) which will print the value if negaive (but adjusted by -1) and nothing if INITIALLY positive.

However, the SUM(Fields.Amount) is proving tricky....

Regards,

Desmond.

[Squall]

You can combine Sum with IIF for example Sum(IIF(Fields.Amount < 0,Fields.Amount,0))*-1

[Desmond]

Excellent !!!...You're a star !!! Many thanks !!!

Now I'll be cheeky... I am trying to format a date as 27.04.2011 but have loaded up my Parameters and no matter what I do it returns the date as Wednesday,  April 27, 2011 ....and I might add that in the table (as in the transactions before) my date was Fields.Date which was 're-formattable' to 19.04.2011 (my desired format)...what must I 'EXPRESS' around the Parameters.ArrivalDate.Value

Cheers,

Desmond.

[Desmond]

Hah...Found it....the incoming Parameters were defined as String...as soon as I change the Type to DateTime then the formatting was effected on the 'Value'

Cheers,

Desmond.