CODEWITHSUNDEEP
crystal-reports
Nuru Salihu
Nuru Salihu

Reputation: 4928

Crystal Reports is grouping by default

I have a crystal report with three columns. I want to display all the records and a total in the last row. However, my crystal report is grouping by default. I am confused

This is how I do it in the CR.

This is how it shows

Thi sis how i wanted

I want everything in a single table and a one toal for each. Why is it grouping this way? Any help would be appreciated.

Below is how i arrived at the TOTAL Formulas

O/S BALANCE := amount - collected.

OSBALANCE TOTAL := SUM{@O?S BALANCE});

COLLECTED TOTAL := SUM({colection})

Upvotes: 1

Views: 102

Answers (2)

craig
craig

Reputation: 26262

Add a cross-tab object to the report's footer section. Use the OS BALANCE field for the rows field and the COLLECTED for the summarized field.

Upvotes: 1

Siva
Siva

Reputation: 9091

See that is where it makes the difference in crystal reports. I will suggest one thing place OSBalance in detail and put the total in report footer and let me know the result

Upvotes: 0

Related Questions