Crystal Reports is grouping by default

1
votes

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.

  • EDITED

Below is how i arrived at the TOTAL Formulas

O/S BALANCE := amount - collected.

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

COLLECTED TOTAL := SUM({colection})

2
crystal-reports
give the formulas you placed in report and also where did you palced the total and detail feilds – Siva
Thank you SIva. I use formulas for the collected and OS BALANCE total as above. Thank you – Nuru Salihu
where did you place OSBalance and Collection in report. – Siva
The report file is the first image sir. You can see OSBALANCE is in the second column while the OSBALANCE total in the 2nd column and thrid row. The collection is placed in the third column collected. The image is there sir. Thank you – Nuru Salihu
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 – Siva

2 Answers

1
votes

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.

0
votes

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