How to create a row in crystal report

[Former Member]

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

[former_member292966]

Hi Sahithya,

Crystal can't create records that do not exist.  Crystal needs a reference to all the departments.  The same thing happens when trying to show consecutive dates but there are no records for a particular date.

Since you have a Department, do you also have a Department table you can add to the report?  This will give you all the departments and if you do an Outer Join you will also get the Departments with no amounts assigned to them.

Good luck,

Brian