Cross Tab calculation in Individual column-Crystal Report

[Former Member]

Hi experts

I am preparing a report in Crystal report 2008. Report template is Cross Tab.

Structure of report is

Cardname-Row, DocType-Columnd, DocTotal-Summarize field.

Result of this report is

IN(Invoice) RC(Incoming Payment) Total

XYZ 1000 -500 500

ABC 2000 -1000 1000

Total 3000 -1500 1500

I have inserted a column using calculated member. I want to Calculate in that column with BP opening balance

eg. OCRD.Balance-DocTotal when I do this it give first value to all column rows, i.e (consider XYZ opng Balance is 1500, I have calculate month opening balance which meance Current Opening Balance-Current month Order bookings=Month opening balance)

IN(Invoice) RC(Inc Pmt) Total Opng Balance

XYZ 1000 -500 500 500

ABC 2000 -1000 1000 500

Total 3000 -1500 1500 500

I want to calculate Opng Balance for each CardName but it gives first Customers opning balance to all customers.

Give me solution.

Thanks in Advance

[Former Member]

Hi

I think you can do calculation based on the formula .On the cross tab ,there is :

X -selection - row

Y - selection -column

Z - summary

You can also use formula on cross tab to do that function and insert into summary section .

Hope this helps .

Bishal