SSRS Detailed Trial Balance

(0) Share

Report

Posted on by Community Member

I'm trying to add a total column of debits and credits in the Financial Trial Balance report. The result is 0.000 when I add a calculation of debit + credit fields. I also tried entering the <<exp>> of each field in the calculation but received an error. Has anyone else addressed this and found a resolution? Thanks in advance, debi

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

RE: SSRS Detailed Trial Balance

Create a expression field with you count function and added it into the report footer.

ex: Count(TableValue.Value, "Total Debit")

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SSRS Detailed Trial Balance

Soma, I'm not sure why you are suggesting to use count but I tried the following expression Count(TableValue.Debitamt, TableValue.Creditamt, "Amount") and received an error that the expression contains a lookup value, running total or other. Is this what you meant?

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: SSRS Detailed Trial Balance

Sorry, I was misunderstanding you question. I was think "you need total number of debit and credit rows". Now I am clear about your question.

1. Add a new column in that report.

2. In the new column right click and select expression (fx).

3. Then Choose Field in Left side pane.

4. Right side pane will shows available fields in that report. Double click debit amt then type "+" in Edit Expression window and then double click credit amt.

5. Click OK and run the report.

Hope this helps!!!

Was this reply helpful? Yes No
Kimberley Stevens 720 on at

Like (0)

Report

RE: SSRS Detailed Trial Balance

Hi Debi,

I think you're trying to add a running balance to this report. Is that correct? I've been fiddling with this for a couple of hours, and have DR - CR working, but the Beginning Balance only adds in on the first line.

Just wondering if you were able to resolve this.

Cheers!

Kimberley

Was this reply helpful? Yes No
Suggested answer

Kimberley Stevens 720 on at

Like (0)

Report

RE: SSRS Detailed Trial Balance

Hi Debi,

I got a running balance to work in the SSRS Financial Trial Balance Detail report by adding a column at the end, and including the following formula on the data row for this column:

= iif(Fields!ACCTTYPE.Value = 2, Format(RunningValue((Sum(Fields!Beg_Bal.Value)+Sum(Fields!DEBITAMTD.Value)-Sum(Fields!CRDTAMNTD.Value)), sum, "AccountNumber"), "N"), Format(RunningValue((Sum(Fields!Beg_Bal.Value)+Sum(Fields!DEBITAMTD.Value)-Sum(Fields!CRDTAMNTD.Value)), sum, "AccountNumber"), "C"))

I had to add another sort criteria (JRNENTRY) on the 'tbl_Main_Details_Group' group in order to get the transactions to appear in order. Otherwise the beginning balance pulls in on the first day, but not necessarily on the first line.

I made a number of other formatting changes as well, but the instructions above will give you a running balance.

Hope this helps you or someone else out there!

Kimberley

Was this reply helpful? Yes No