Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Report Services - help with a Running Total

Status
Not open for further replies.

JBourne77

IS-IT--Management
Jan 21, 2008
153
US
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top