7bc11145-2faa-409b-b053-d59a0a2858c3
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
2c4a2db2-8702-4468-9927-141d10fe0567
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 null AND LEN(PartyData.Column10)>1
order by DoctorName,'Received Patient Name'
=Parameters!DateFilledFrom.Value
=Parameters!DateFilledTo.Value
true
37.5cm
1cm
textbox1
30.47619cm
1
true
0.91429cm
Filed Results
MPNetMD1
0.91429cm
33.07936cm
Received_Patient_Name
7
true
=Fields!Received_Patient_Name.Value
Received_NHI
6
true
=Fields!Received_NHI.Value
DoctorName
5
true
=Fields!DoctorName.Value
DateFilled
4
true
=Fields!DateFilled.Value
Patient_Name
3
true
=Fields!Patient_Name.Value
NHI
2
true
=Fields!NHI.Value
Results
1
true
=Fields!Results.Value
RECORD_EXISTS
true
=Fields!RECORD_EXISTS.Value
0.53333cm
textbox2
15
true
Received Patient Name
textbox3
14
true
Received NHI
textbox4
13
true
Doctor Name
textbox5
12
true
Date Filed
textbox6
11
true
Patient Name
textbox7
10
true
NHI
textbox12
9
true
Results
textbox8
8
true
Record Exists
0.55873cm
true
5cm
3.25cm
4.25cm
2.53968cm
5.5cm
2.53968cm
6.25cm
3.75cm
2.00635cm
en-US
2.5cm
29.7cm