Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Selection forumla Post Reply Post New Topic
Author Message
kcduplessis
Newbie
Newbie
Avatar

Joined: 16 Jun 2011
Online Status: Offline
Posts: 10
Quote kcduplessis Replybullet Topic: Selection forumla
    Posted: 28 Sep 2011 at 7:18am
Hello, I am new to crystal reports and am kind of stumped here. I have a report that pulls hospital visits and professional vists, noted on the report P and H respectively. Right now I have all visits P&H from all members. I need to pull all records ( P & H ) for any member who has a hospital (H) visit. Sounds super easy to me but I am really stuck. Thanks for all of your help.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Sep 2011 at 7:36am
one way
group on memberid
create a "flag" formula to count rows of "H"
if table.field='H" then 1
SUm this at the memberid footer level
SUM(@flag,memberid)
anywhere this value is >0 you have amember that has at least one "H" row
use the sum to do a group selection
opent he select expert, expand it to the formula
change the toggle to use group selection
add your formula here
SUM(@flag,memberid)>0
IP IP Logged
kcduplessis
Newbie
Newbie
Avatar

Joined: 16 Jun 2011
Online Status: Offline
Posts: 10
Quote kcduplessis Replybullet Posted: 28 Sep 2011 at 8:15am

Thank you very much, this is exactly what I needed. I have been racking my brain for the last couple days trying to figure this out. Again, thank you very much!!

IP IP Logged
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.