Crystal Reports one to many selection

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: one to many selection
	<< Prev Page of 2

Author	Message
TorLang Groupie Joined: 13 Jun 2012 Location: United States Online Status: Offline Posts: 50	Posted: 08 Aug 2013 at 6:35am
	{TPM311_VISIT_PAYOR.pyr_seq_no} = 4981 payer sequence number, i.e. rank number. 4981 is rank number for Primary Ins. Keeping this select in the group select, removes all sec. and tert. insurances from the screen, but the record count remains the same. Edited by TorLang - 08 Aug 2013 at 6:44am
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 08 Aug 2013 at 6:43am
	what are the other possible values (code for secondary and tertiary)? And you cannot have quaternary or more correct?
	IP Logged

TorLang Groupie Joined: 13 Jun 2012 Location: United States Online Status: Offline Posts: 50	Posted: 08 Aug 2013 at 6:47am
	Primary Insurance - 4981 Secondary Insurance - 4978 Tertiary Insurance - 4980 I know, the rank numbers really don't make sense, but I didn't build it :-) We never use quaternary ins. Don't know if this helps, but: When keeping the data on a detail line, I have: (if the patient has 3 insurances) One record with just the tertiary ins. Next record with secondary and tertiary ins. Next record with primary, secondary and tertiary ins. This is without the group select entered in... Edited by TorLang - 08 Aug 2013 at 7:01am
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 08 Aug 2013 at 7:28am
	you have to use a group condition in the group select to make it include or exclude the whole group in this case the group is a client your condition is that you want clients with only a primary insurance if you insert a summary of the insurance type at the client group level you can use the to find what you want. Minimum(insurancetype,client) any clinet group that has the value of 4981 meets your condition use that in the group select Minimum(insurancetype,client)=4981 Edited by DBlank - 08 Aug 2013 at 7:29am
	IP Logged

TorLang Groupie Joined: 13 Jun 2012 Location: United States Online Status: Offline Posts: 50	Posted: 08 Aug 2013 at 9:04am
	yayy, that worked. thanks :-))
	IP Logged

TorLang Groupie Joined: 13 Jun 2012 Location: United States Online Status: Offline Posts: 50	Posted: 11 Sep 2013 at 2:46am
	This statement in the group select worked: Minimum ({TPM311_VISIT_PAYOR.pyr_seq_no}, {TPM300_PAT_VISIT.vst_ext_id}) = 4981.00 So can I use a similar group select to exclude patients with MEDICAID insurance? Not using Minimum of course, but something like: not {insurance}, {client} = "MEDICAID" I am sure the NOT statement syntax above is wrong though. How would you formulate a statement that would exclude records with MEDICAID as primary, secondary or tertiary.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 11 Sep 2013 at 3:48am
	create another formula to 'flag' the records you want if insurance=medicaid and type in (primary, secondary, tertiary) then 1 else 0 sum this at the group level sum(flag,client) now any client with a sum>0 needs to be excluded so you use that in the group select sum(flag,client)=0
	IP Logged

TorLang Groupie Joined: 13 Jun 2012 Location: United States Online Status: Offline Posts: 50	Posted: 11 Sep 2013 at 6:26am
	Results look good. I just have to spot check against real patient data. Thanks again.
	IP Logged

<< Prev Page of 2

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.