6897d6f2-df6a-4382-8237-734f40188fce
SQL
Data Source=ASHWIN;Initial Catalog=MPNetMD1
11in
String
true
true
Enter Date (dd/mm/yyyy)
true
8.5in
0.25cm
true
2.5cm
2.5cm
2.5cm
49c7fa78-8ee6-4f33-8c1b-3f469cdf9c22
21cm
Received Patient Name
System.String
Received NHI
System.String
DoctorName
System.String
DateFilled
System.String
Patient Name
System.String
NHI
System.String
RECORD EXISTS
System.String
MPNetMD1
SELECT PartyData.Column2 AS 'Received Patient Name', PartyData.Column3 AS 'Received NHI', PartyData.Column7 AS DoctorName, convert(varchar(10),datepart(yy,dbo.PartyData.EndDate))+'-'+convert(varchar(10),datepart(mm,dbo.PartyData.EndDate))+'-'+convert(varchar(10),datepart(dd,dbo.PartyData.EndDate)) AS DateFilled
,Case LEN(PartyData.Column10) When 36 then (SELECT Person.LastName + ', ' + Person.FirstName FROM Person ,Record where Person.PartyGUID = Record.SubjectGUID AND CONVERT(varchar(50), PartyData.Column10) = Record.RecordGUID) else '' end AS 'Patient Name'
,Case LEN(PartyData.Column10) When 36 then (SELECT Person.NationalRegistration FROM Person ,Record where Person.PartyGUID = Record.SubjectGUID AND CONVERT(varchar(50), PartyData.Column10) = Record.RecordGUID) else '' end AS 'NHI'
,Case RecordData.RecordDataGUID When RecordData.RecordDataGUID then 'FOUND' else 'NOT FOUND' end AS 'RECORD EXISTS'
FROM Partydata
left JOIN
RecordData ON CONVERT(varchar(50), PartyData.PartyDataGUID) = RecordData.Column10
WHERE (PartyData.UseTypeID = 100034) AND (PartyData.FormatTypeID = 100045) AND (PartyData.EndDate IS NOT NULL)
AND
(dbo.PartyData.EndDate=convert(varchar(20), datepart(yyyy,convert(datetime,@DateFilled,103)))+'-'+convert(varchar(20), datepart(m,convert(datetime,@DateFilled,103)))+'-'+convert(varchar(20), datepart(d,convert(datetime,@DateFilled,103)))+' '+'00:00:00' ) order by DoctorName,'Received Patient Name'
=Parameters!DateFilled.Value
true
25.75cm
1cm
textbox1
12.69841cm
1
true
0.91429cm
Filed Results
MPNetMD1
0.91429cm
25.25cm
Received_Patient_Name
6
true
=Fields!Received_Patient_Name.Value
NHI
5
true
=Fields!NHI.Value
DoctorName
4
true
=Fields!DoctorName.Value
DateFilled
3
true
=Fields!DateFilled.Value
Patient_Name
2
true
=Fields!Patient_Name.Value
NHI_1
1
true
=Fields!NHI.Value
RECORD_EXISTS
true
=Fields!RECORD_EXISTS.Value
0.53333cm
textbox2
13
true
Received Patient Name
textbox3
12
true
Received NHI
textbox4
11
true
Doctor Name
textbox5
10
true
Date Filed
textbox6
9
true
Patient Name
textbox7
8
true
NHI
textbox8
7
true
Record Exists
0.55873cm
true
5cm
3.25cm
3.75cm
3.25cm
4.75cm
2cm
3.25cm
2.00635cm
en-US
2.5cm
29.7cm