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!

Suppress printing or display of sane patient with different account number

Status
Not open for further replies.

SMMDJD

IS-IT--Management
Mar 10, 2014
4
CA
I have source data on patients that have had surgery within certain dates. From this source data, I wish to identify if the same patient has returned to the operating room within the dates I have selected in the date parameter.
I am able to readily exclude any patients with a count not greater than 1.
For patients that have a count of >1 I wish to see only those patients with the same exact account number. If the patient has a different account number, I do not wish to see the patient on my output.
I am sorting by name, account, date of surgery.

Here is an example of source data. In this example, I wish to see ONLY Jones on the output they have the same account number. I am not sure if it matters, but case number is always a unique number, it never repeats.
Name Account Date CaseNo
Doe, John 912 1/3/2014 101
Smith, Bob 965 1/6/2014 145
Smith, Bob 972 1/8/2014 162
Jones, Mike 989 1/10/2014 189
Jones, Mike 989 1/16/2014 194

I am using CR10. I am thinking this might relate to some formula that uses previous in the syntax. Any suggestions or approaches to doing this would be most appreciated.
 
I believe what you are looking for can be achieved by the following steps:

Group on Name and then by Account.
Then insert a Summary
Field to summarize - Name
Calculate this summary - Count
Summary Location Group#2: Account-A

Copy Name and Account to GF2
Suppress condition for GF2
Count ({Table_.Name}, {Table.Account})<2
Suppress all other sections.

Hope this helps
 
Thank you Betty. Shortly after posting, I realized I could accomplish what I needed to do via a distinct count on account number and then selecting on count = 1.
I appreciate your response!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top