Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: selection according db row data Post Reply Post New Topic
Author Message
Vertex
Newbie
Newbie
Avatar

Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
Quote Vertex Replybullet Topic: selection according db row data
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.

IP IP Logged
Vertex
Newbie
Newbie
Avatar

Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
Quote Vertex Replybullet 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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
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.063 seconds.