My company is in the transition of changing from Crystal reports over to SQL Reporting Services and needless to say, its hectic on me.
In Crystal you can create Running Totals. I have one set up as follows:
Field to Summarize: PatientID
Type of Summary: Distinct Count
Evaluate on Use of Formula: ObsValue = "1"
Reset on Change of Group: Race/Ethnicity
I found this link, but I am at a loss at how I set my Running Value up correct.
In Crystal you can create Running Totals. I have one set up as follows:
Field to Summarize: PatientID
Type of Summary: Distinct Count
Evaluate on Use of Formula: ObsValue = "1"
Reset on Change of Group: Race/Ethnicity
I found this link, but I am at a loss at how I set my Running Value up correct.