d64efefd-7281-44e4-b367-e70cf0dc29a0
SQL
Data Source=ASHWIN;Initial Catalog=MPNetMD1
11in
String
true
true
From Date (dd/mm/yyyy)
String
true
true
To Date (dd/mm/yyyy)
true
8.5in
0.25cm
true
2.5cm
2.5cm
2.5cm
fba94ed3-ed0b-455e-b6e7-09fd22d690c9
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
singlelinedata
System.String
column5
System.String
memo
System.String
Results
System.String
partydataguid
System.Guid
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',recorddata.singlelinedata,recorddata.column5,partydata.memo,
REPLACE(SUBSTRING(PartyData.Memo,CHARINDEX('<TestTypeDescription>',PartyData.Memo),CHARINDEX('</TestTypeDescription>',PartyData.Memo)-(CHARINDEX('<TestTypeDescription>',PartyData.Memo))),'<TestTypeDescription>','') AS 'Results',partydataguid
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,@DateFilledFrom,103)))+'-'+convert(varchar(20), datepart(m,convert(datetime,@DateFilledFrom,103)))+'-'+convert(varchar(20), datepart(d,convert(datetime,@DateFilledFrom,103))))
AND (dbo.PartyData.EndDate<=convert(varchar(20), datepart(yyyy,convert(datetime,@DateFilledTo,103)))+'-'+convert(varchar(20), datepart(m,convert(datetime,@DateFilledTo,103)))+'-'+convert(varchar(20), datepart(d,convert(datetime,@DateFilledTo,103))))
AND RecordData.RecordDataGUID is not null AND LEN(PartyData.Column10)>1
order by DoctorName,'Received Patient Name'
=Parameters!DateFilledFrom.Value
=Parameters!DateFilledTo.Value
true
36.25cm
1cm
textbox1
30.47619cm
1
true
0.91429cm
Filed Results
MPNetMD1
0.91429cm
24.53968cm
Received_Patient_Name
5
true
=Fields!Received_Patient_Name.Value
Received_NHI
4
true
=Fields!Received_NHI.Value
DoctorName
3
true
=Fields!DoctorName.Value
DateFilled
2
true
=Fields!DateFilled.Value
Patient_Name
1
true
=Fields!Patient_Name.Value
NHI
true
=Fields!NHI.Value
0.53333cm
textbox2
11
true
Received Patient Name
textbox3
10
true
Received NHI
textbox4
9
true
Doctor Name
textbox5
8
true
Date Filled
textbox6
7
true
Patient Name
textbox7
6
true
NHI
0.55873cm
true
5.5cm
3.5cm
5cm
2.75cm
5.25cm
2.53968cm
2.00635cm
en-US
2.5cm
29.7cm