Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Show Data based on Query of another table

Posted on 2011-10-27
9
Medium Priority
?
299 Views
Last Modified: 2012-05-12
I want crystal to show patient detail from one table if the patient does not exist for the same date in another table.  

So a patient has a contact date in one table.  I need crystal to check the other table(ie subreport maybe?) and if there is no matching patient for that date, then show the patient detail from current table.
0
Comment
Question by:Becky Edwards
  • 5
  • 3
8 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 37042553
Are you doing any summaries or other analysis of the data?
If not simply suppressing the records you don't want would work

SOmething like this

Add both tables to the report
Link (Left Outer Join) them on PatientId and DateofVisit

Suppress the details with
Not IsNull({OtherTable.DateField})

mlmcc
0
 

Author Comment

by:Becky Edwards
ID: 37045859
Why do I get an error that "A boolean is required here"?

  I put the following in detail row suppression in section expert:

Date({HSP_TRANSACTIONS.SERVICE_DATE})
0
 

Author Comment

by:Becky Edwards
ID: 37045862
I also tried just
{HSP_TRANSACTIONS.SERVICE_DATE}
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:Becky Edwards
ID: 37045915
Here are the other filters I need to get just the information I want to compare. I only want to look at yesterday and only at charges and charge reversals, for a specific location.

{CLARITY_TDL_TRAN.ORIG_SERVICE_DATE} in CurrentDate-1 and
//only look at yesterday
{CLARITY_TDL_TRAN.DETAIL_TYPE} in [1, 10] and
//this is because I only want charges and void charges
{CLARITY_LOC.LOC_NAME} = "San Antonio Clinic"
//this says only give me charges if they are for a specific location
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 37045934
Did you try what I suggested

Not IsNull({HSP_TRANSACTIONS.SERVICE_DATE} )

mlmcc
0
 

Author Comment

by:Becky Edwards
ID: 37046274
I did get results back!  I will try to validate.  This may take a while.  Thank you.
0
 

Author Comment

by:Becky Edwards
ID: 37066021
Still checking.  Need to add another piece to the report in order to validate.  (see open question).
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 37205963
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

575 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question