Sum of a Formula and Sum of Records Sorted by a Group Sort

[yosteevo]

Subject: Sum of a Formula and Sum of Records Sorted by a Group Sort



I am using Crystal Reports 2008.

1) I have a subreport where I need to calculate the sum of the output of a formula that outputs a numerical result.

2) In this subreport I have a group configured that sorts data by one database field. I configured the group sort to go to a new page for every single new record it reads. I need to have the ability to count how many times this group produces a new page (count the number of records the group sort reads through).


Thank You.
Stephen Waichulis

 

[IdoMillet]

Use DistinctCount() on whatever you are Grouping on.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[yosteevo]

Hello IdoMillet,

DistinctCount() also does not work. Again this is a formula I am attempting to calculate the sum of and it is a numerical result.

It seems that Crystal Reports does not allow the use of functions to be applied to formula fields within the Formula Editor.




Thanks
Stephen