Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cross Tab calculation in Individual column-Crystal Report

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
Not what you were looking for? View more on this topic or Ask a question