(ISF) Crystal Reports questions

Hi All,

I have a Crystal Reports question that is finally coming to
a critical mass in our reporting structure. I am have a good
basic command of Crystal but I need to know how to implement
some specific selection logic.

I need to pull a set of records based upon the status of one
of those records. So as an example, we are a health center,
and we are looking to track flu symptoms, I need to pull
every encounter (record) for a patient based upon one record
having the flu diagnosis.

We are currently using Crystal 8 (I know, I know) but my
hope is that this is standard SQL logic.

Please let me know if you can help or know a resource that
may be able to help.

Thank you,

David Whitham 
Director of Information Technology 
Dimock Community Health Center 
55 Dimock St 
Roxbury, MA 02119 
617-442-8800 xt 1486 
dwhithamdimock.org 






------------------------ Yahoo! Groups Sponsor
--------------------~--> 
Get to your groups with one click. Know instantly when new
email arrives
http://us.click.yahoo.com/.7bhrC/MGxNAA/yQLSAA/26EolB/TM

------------------------------------------------------------
--------~-> 

=========================================

The Information Systems Forum is an opt-in, low-traffic,
flame-free distribution list for discussions of information
technology for nonprofit organizations.

To post a message, prepare a regular email and send it to
Information_Systems_Forum@yahoogroups.com 

To join the Information Systems Forum, send a blank email to
Information_Systems_Forum-SUBSCRIBE@yahoogroups.com 

To leave the Information System Forum, send a blank email to
Information_Systems_Forum-UNSUBSCRIBE@yahoogroups.com . 
Please note that there may be a lag (of hours or days)
between the moment that you send the command and the moment
that you stop receiving messages from this group.  Your list
administrator apologizes for this flaw in the YahooGroups
configuration, but has been unable to shorten the lag from
her end of things.  

To send a message to the list administrator (Deborah), email
it to Information_Systems_Forum-owner@yahoogroups.com .

To view the message archive, go to http://groups.yahoo.com/group/Information_Systems_Forum 

To participate in the unmoderated version of this email
distribution list, go to http://groups.yahoo.com/group/Information_Sy
stems_Forum_UNMODERATED/

To view a map of the group's membership, go to http://
www.frappr.com/informationsystemsforum

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Information_Systems_Forum/


<*> To unsubscribe from this group, send an email to:
    Information_Systems_Forum-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/
 

Hi,

Selecting certain records through a Filter is a basic
capability of Crystal. No need to learn SQL. (You are trying
to show all patient records which have a related encounter
record where flu=yes).

Here is a link to one article on filters; (this page has
links to more info too) http://www.samspublishing.com/a
rticles/article.asp?p=330330&seqNum=2&rl=1

If Crystal is the tool of choice in your organization I
STRONGLY recommend taking formal training.  It is a very
excellent and powerful tool, and it sounds like it is
important for your ability to analyze data.  Training will
put the full breadth and power of the SW in your hands.

There are also some excellent user forums online that you
may want to get involved with.  That is a great way to
supplement learning.  Google Crystal Reports Discussion
Forums.

Good Luck
Jenny Council






-----original message-----
>>I have a Crystal Reports question that is finally
coming to a critical mass in our reporting structure. I am
have a good basic command of Crystal but I need to know how
to implement some specific selection logic. I need to pull a
set of records based upon the status of one of those
records. So as an example, we are a health center, and we
are looking to track flu symptoms, I need to pull every
encounter (record) for a patient based upon one record
having the flu diagnosis. We are currently using Crystal 8
(I know, I know) but my hope is that this is standard SQL
logic.>>




------------------------ Yahoo! Groups Sponsor
--------------------~--> 
Home is just a click away.  Make Yahoo! your home page now.
http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/26EolB/TM

------------------------------------------------------------
--------~-> 

=========================================

The Information Systems Forum is an opt-in, low-traffic,
flame-free distribution list for discussions of information
technology for nonprofit organizations.

To post a message, prepare a regular email and send it to
Information_Systems_Forum@yahoogroups.com 

To join the Information Systems Forum, send a blank email to
Information_Systems_Forum-SUBSCRIBE@yahoogroups.com 

To leave the Information System Forum, send a blank email to
Information_Systems_Forum-UNSUBSCRIBE@yahoogroups.com . 
Please note that there may be a lag (of hours or days)
between the moment that you send the command and the moment
that you stop receiving messages from this group.  Your list
administrator apologizes for this flaw in the YahooGroups
configuration, but has been unable to shorten the lag from
her end of things.  

To send a message to the list administrator (Deborah), email
it to Information_Systems_Forum-owner@yahoogroups.com .

To view the message archive, go to http://groups.yahoo.com/group/Information_Systems_Forum 

To participate in the unmoderated version of this email
distribution list, go to http://groups.yahoo.com/group/Information_Sy
stems_Forum_UNMODERATED/

To view a map of the group's membership, go to http://
www.frappr.com/informationsystemsforum

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Information_Systems_Forum/


<*> To unsubscribe from this group, send an email to:
    Information_Systems_Forum-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/