Friday, March 23, 2012

Running Total - Count Only Displayed Records

I am working on a Crystal Report right now that I am having trouble trying to figure out how to only count the records that have been displayed in the report. I do not have a whole lot of experience with Crystal. I have supressed the details section with the following formula:

//This formula suppresses the Details line
//when there are duplicate values contained in the fields.
{view_CR_Vehicle_Sales_Deals.CUS_Name} = Next({view_CR_Vehicle_Sales_Deals.CUS_Name}) And
{MajorUnitOrder.VehicleIdentificationNum} = Next({MajorUnitOrder.VehicleIdentificationNum}) And
{MajorUnitOrder.SoldDate} = Next({MajorUnitOrder.SoldDate})

The suppressed data is getting included in the running total count. Is there anyway that I can make Crystal Reports only count what is displayed on the screen?

Thanks,

JamesRight click on the column;select summary;select distinct count;place it in the report

No comments:

Post a Comment