Skip to Content
0
Former Member
Sep 23, 2014 at 04:26 PM

How to create a row in crystal report

22 Views


Hi,

I have a requirement like

I have a column with Departmentwise Actual amount grouped by Region.

Under Asia Group A,

Department Actual Amount

A 100

B 200

C 300

D 400

E 500

F A+B+C+D+E

A,B,C,D,E are coming from database. But not sure for every group all the departments(A,B,C,D,E) are present.

So, When I insert calculated member under 'E' as 'F' and 'E' value is not available in database for Department then F is also not showing. F is disabled.

So, how can I show 'F' value everytime even when either of A,B,C,D,E are not in database?

Thanks,

Sahithya