Print Page | Close Window

selection according db row data

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9790
Printed Date: 01 May 2024 at 4:32am


Topic: selection according db row data
Posted By: Vertex
Subject: selection according db row data
Date Posted: 22 Apr 2010 at 11:19am
if {ssCardiac.PatientID}={?Patient Selection} then
{ssCardiac.InspectionDateTime}.row  ={ssCardiac.PatientID}={?Patient Selection};

like if pateint Selection is "2" then i need all {ssCardiac.InspectionDateTime} having PatientId =2 in row (PatientId is not my primary key in db it is multiple times for same patient)


thanks for support me !


-------------
Hi Peoples


Replies:
Posted By: lockwelle
Date Posted: 23 Apr 2010 at 3:11am

sounds like a grouping issue or a filter issue...due to the fact that it is a parameter, I would filter out all records that don't meet your requirements.

Posted By: Vertex
Date Posted: 24 Apr 2010 at 6:58am
i want  to select all the records having patientId "2".. so what cna i do for this ??


-------------
Hi Peoples

Posted By: lockwelle
Date Posted: 26 Apr 2010 at 3:18am
in report/selection formulas/record
 
{table.patientid}=2
 
only patients with an id of 2 will be in the report.


Print Page | Close Window