1.78563cm
1.76864cm
0.6cm
true
true
=Switch(Fields!Age.Value <=6,"1-6",
(Fields!Age.Value >=7 And Fields!Age.Value <=17),"7-17",
(Fields!Age.Value >=18 And Fields!Age.Value <=64),"18-64",
Fields!Age.Value >=65,"65+")
Textbox32
#4c68a2
2pt
2pt
2pt
2pt
true
true
Grand Total
Textbox33
#4c68a2
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Age1
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox27
#9eb6e4
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Textbox29
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox30
#9eb6e4
2pt
2pt
2pt
2pt
=Switch(Fields!Age.Value <=6,1,
(Fields!Age.Value >=7 And Fields!Age.Value <=17),2,
(Fields!Age.Value >=18 And Fields!Age.Value <=64),3,
Fields!Age.Value >=65,4)
=Fields!Age.Value
5.40005cm
true
true
Drug Groups
Textbox31
#4c68a2
2pt
2pt
2pt
2pt
After
=Fields!DrugName.Value
5.40005cm
true
true
=Fields!DrugName.Value
DrugName1
2pt
2pt
2pt
2pt
5.40005cm
true
true
Grand Total
Textbox28
#9eb6e4
2pt
2pt
2pt
2pt
Before
dsAntibiotics
2.74849cm
0.29071cm
1.8cm
8.95432cm
true
true
Antibiotics Prescribed from
=Parameters!ReportStartDate.Value
to
=Parameters!ReportEndDate.Value
Textbox13
0.54335cm
0.3175cm
0.97042cm
14.32564cm
1
#4c68a2
2pt
2pt
2pt
2pt
true
true
Count by Age Band
Textbox13
1.96328cm
0.29072cm
0.60882cm
5.40005cm
2
#4c68a2
2pt
2pt
2pt
2pt
1.75884cm
1.76864cm
0.6cm
true
true
=Microsoft.VisualBasic.Interaction.Switch(Fields!Age.Value <= 6, "1-6", (Fields!Age.Value >= 7 And Fields!Age.Value <= 17), "7-17", (Fields!Age.Value >= 18 And Fields!Age.Value <= 64), "18-64", Fields!Age.Value >= 65, "65+")
Textbox32
#4c68a2
2pt
2pt
2pt
2pt
true
true
Grand Total
Textbox33
#4c68a2
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Age1
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox27
#9eb6e4
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Textbox29
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox30
#9eb6e4
2pt
2pt
2pt
2pt
=Switch(Fields!Age.Value <=6,1,
(Fields!Age.Value >=7 And Fields!Age.Value <=17),2,
(Fields!Age.Value >=18 And Fields!Age.Value <=64),3,
Fields!Age.Value >=65,4)
=Fields!Age.Value
5.40005cm
true
true
Sex
Textbox31
#4c68a2
2pt
2pt
2pt
2pt
After
=Fields!Sex.Value
5.40005cm
true
true
=Fields!Sex.Value
DrugName1
2pt
2pt
2pt
2pt
5.40005cm
true
true
Grand Total
Textbox28
#9eb6e4
2pt
2pt
2pt
2pt
Before
dsAntibiotics
9.25573cm
0.3175cm
1.8cm
8.92753cm
3
true
true
Count by Sex
Textbox13
8.47052cm
0.3175cm
0.60882cm
5.40005cm
4
#4c68a2
2pt
2pt
2pt
2pt
true
true
Count of Antibiotic
Textbox13
18.41691cm
0.31751cm
0.60882cm
5.40005cm
5
#4c68a2
2pt
2pt
2pt
2pt
true
true
Ethnicity Name
Textbox77
#4c68a2
2pt
2pt
2pt
2pt
true
true
Drug Name
Textbox84
#4c68a2
2pt
2pt
2pt
2pt
1.81208cm
1.78563cm
0.6cm
true
true
=CountRows()
Textbox76
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox82
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Textbox100
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox101
#9eb6e4
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Textbox104
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox105
#9eb6e4
2pt
2pt
2pt
2pt
=Switch(Fields!Age.Value <=6,1,
(Fields!Age.Value >=7 And Fields!Age.Value <=17),2,
(Fields!Age.Value >=18 And Fields!Age.Value <=64),3,
Fields!Age.Value >=65,4)
0.6cm
true
true
=Microsoft.VisualBasic.Interaction.Switch(Fields!Age.Value <= 6, "1-6", (Fields!Age.Value >= 7 And Fields!Age.Value <= 17), "7-17", (Fields!Age.Value >= 18 And Fields!Age.Value <= 64), "18-64", Fields!Age.Value >= 65, "65+")
Textbox75
#4c68a2
2pt
2pt
2pt
2pt
0.6cm
true
true
Grand Total
Textbox81
#4c68a2
2pt
2pt
2pt
2pt
=Fields!EthnicityName.Value
=Fields!EthnicityName.Value
3.35553cm
true
true
=Fields!EthnicityName.Value
EthnicityName1
2pt
2pt
2pt
2pt
=Fields!DrugName.Value
=Fields!DrugName.Value
3.75991cm
true
true
=Fields!DrugName.Value
DrugName4
2pt
2pt
2pt
2pt
3.75991cm
true
true
Total
Textbox99
#9eb6e4
2pt
2pt
2pt
2pt
Before
3.35553cm
true
true
Grand Total
Textbox102
#9eb6e4
2pt
2pt
2pt
2pt
3.75991cm
true
true
Textbox103
#9eb6e4
2pt
2pt
2pt
2pt
Before
dsAntibiotics
19.16684cm
0.31751cm
2.4cm
10.71315cm
6
1.75884cm
1.76864cm
0.6cm
true
true
=Microsoft.VisualBasic.Interaction.Switch(Fields!Age.Value <= 6, "1-6", (Fields!Age.Value >= 7 And Fields!Age.Value <= 17), "7-17", (Fields!Age.Value >= 18 And Fields!Age.Value <= 64), "18-64", Fields!Age.Value >= 65, "65+")
Textbox32
#4c68a2
2pt
2pt
2pt
2pt
true
true
Grand Total
Textbox33
#4c68a2
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Age1
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox27
#9eb6e4
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Textbox29
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox30
#9eb6e4
2pt
2pt
2pt
2pt
=Switch(Fields!Age.Value <=6,1,
(Fields!Age.Value >=7 And Fields!Age.Value <=17),2,
(Fields!Age.Value >=18 And Fields!Age.Value <=64),3,
Fields!Age.Value >=65,4)
=Fields!Age.Value
5.40005cm
true
true
Practitioner
Textbox31
#4c68a2
2pt
2pt
2pt
2pt
After
=Fields!PractitionerName.Value
5.40005cm
true
true
=Fields!PractitionerName.Value
DrugName1
2pt
2pt
2pt
2pt
5.40005cm
true
true
Grand Total
Textbox28
#9eb6e4
2pt
2pt
2pt
2pt
Before
dsAntibiotics
12.62917cm
0.3175cm
1.8cm
8.92753cm
7
true
true
Count by Practitioner
Textbox13
11.84396cm
0.31751cm
0.60882cm
5.40005cm
8
#4c68a2
2pt
2pt
2pt
2pt
1.75883cm
1.76864cm
0.6cm
true
true
=Microsoft.VisualBasic.Interaction.Switch(Fields!Age.Value <= 6, "1-6", (Fields!Age.Value >= 7 And Fields!Age.Value <= 17), "7-17", (Fields!Age.Value >= 18 And Fields!Age.Value <= 64), "18-64", Fields!Age.Value >= 65, "65+")
Textbox32
#4c68a2
2pt
2pt
2pt
2pt
true
true
Grand Total
Textbox33
#4c68a2
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Age1
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox27
#9eb6e4
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()
Textbox29
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=CountRows()
Textbox30
#9eb6e4
2pt
2pt
2pt
2pt
=Switch(Fields!Age.Value <=6,1,
(Fields!Age.Value >=7 And Fields!Age.Value <=17),2,
(Fields!Age.Value >=18 And Fields!Age.Value <=64),3,
Fields!Age.Value >=65,4)
=Fields!Age.Value
5.40005cm
true
true
Quintile
Textbox31
#4c68a2
2pt
2pt
2pt
2pt
After
=Fields!Quintile.Value
=Fields!Quintile.Value
5.40005cm
true
true
="Quintile: "+Fields!Quintile.Value
DrugName1
2pt
2pt
2pt
2pt
5.40005cm
true
true
Grand Total
Textbox28
#9eb6e4
2pt
2pt
2pt
2pt
Before
dsAntibiotics
15.9647cm
0.31751cm
1.8cm
8.92752cm
9
true
true
Count by Quintile
Textbox13
15.17949cm
0.31752cm
0.60882cm
5.40005cm
10
#4c68a2
2pt
2pt
2pt
2pt
3.01156cm
3.37815cm
2.82005cm
1.49548cm
1.1355cm
2.74946cm
1.50592cm
0.6cm
true
=Fields!PractitionerName.Value
true
Practitioner Name
Textbox126
#4c68a2
2pt
2pt
2pt
2pt
true
=Fields!DrugName.Value
true
Drug Name
Textbox128
#4c68a2
2pt
2pt
2pt
2pt
true
=Fields!PatientName.Value
true
Patient Name
Textbox130
#4c68a2
2pt
2pt
2pt
2pt
true
=Fields!Age.Value
true
Age
Textbox133
#4c68a2
2pt
2pt
2pt
2pt
true
=Fields!Sex.Value
true
Sex
Textbox135
#4c68a2
2pt
2pt
2pt
2pt
true
=Fields!EthnicityName.Value
true
Ethnicity Name
Textbox139
#4c68a2
2pt
2pt
2pt
2pt
true
=Fields!Quintile.Value
true
Quintile
Textbox137
#4c68a2
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!PractitionerName.Value
PractitionerName
2pt
2pt
2pt
2pt
true
true
=Fields!DrugName.Value
DrugName
2pt
2pt
2pt
2pt
true
true
=Fields!PatientName.Value
PatientName
2pt
2pt
2pt
2pt
true
true
=Fields!Age.Value
Age
2pt
2pt
2pt
2pt
true
true
=Fields!Sex.Value
Sex
2pt
2pt
2pt
2pt
true
true
=Fields!EthnicityName.Value
EthnicityName
2pt
2pt
2pt
2pt
true
true
=Fields!Quintile.Value
Quintile
2pt
2pt
2pt
2pt
After
dsAntibiotics
=Fields!PractitionerName.Value
22.9362cm
0.31752cm
1.2cm
16.09612cm
11
true
true
Table of Patients
Textbox13
22.01498cm
0.31752cm
0.60882cm
5.40005cm
12
#4c68a2
2pt
2pt
2pt
2pt
1.75882cm
1.76864cm
0.6cm
true
true
=Microsoft.VisualBasic.Interaction.Switch(Fields!Age.Value <= 6, "1-6", (Fields!Age.Value >= 7 And Fields!Age.Value <= 17), "7-17", (Fields!Age.Value >= 18 And Fields!Age.Value <= 64), "18-64", Fields!Age.Value >= 65, "65+")
Textbox2
#4c68a2
2pt
2pt
2pt
2pt
true
true
Grand Total
Textbox3
#4c68a2
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()/CountRows("tblEthnicity")
Age1
2pt
2pt
2pt
2pt
true
true
=CountRows()/CountRows("tblEthnicity")
Textbox27
#9eb6e4
2pt
2pt
2pt
2pt
0.6cm
true
true
=CountRows()/CountRows("tblEthnicity")
Textbox29
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=CountRows()/CountRows("tblEthnicity")
Textbox30
#9eb6e4
2pt
2pt
2pt
2pt
=Switch(Fields!Age.Value <=6,1,
(Fields!Age.Value >=7 And Fields!Age.Value <=17),2,
(Fields!Age.Value >=18 And Fields!Age.Value <=64),3,
Fields!Age.Value >=65,4)
=Fields!Age.Value
5.40005cm
true
true
Ethnicities
Textbox31
#4c68a2
2pt
2pt
2pt
2pt
After
=Fields!EthnicityName.Value
5.40005cm
true
true
=Fields!EthnicityName.Value
DrugName1
2pt
2pt
2pt
2pt
5.40005cm
true
true
Grand Total
Textbox28
#9eb6e4
2pt
2pt
2pt
2pt
Before
dsAntibiotics
6.0675cm
0.31752cm
1.8cm
8.92751cm
13
true
true
Count by Ethnicity
Textbox13
5.28229cm
0.31753cm
0.60882cm
5.40005cm
14
#4c68a2
2pt
2pt
2pt
2pt
10.24099in
6.59811in
29.7cm
21cm
2cm
2cm
2cm
2cm
0.13cm
0
System.Data.DataSet
/* Local Connection */
bba9139a-fe61-4093-958f-d7e81042fb56
dsAntibiotics
SELECT DISTINCT p.Partyguid
,p.FirstName + ' ' + p.LastName AS PatientName
,dg.Druggroupid
,dg.AtcCode
,dg.Name As DrugName
,dbo.GetAge(p.DOB, GetDate()) AS Age
,p.Sex
,(
SELECT EthnicityName
FROM dbo.GetEthnicity(p.partyGUid)
) AS EthnicityName
,prac.FirstName + ' ' + prac.LastName AS PractitionerName
,pdq.Column10 As Quintile
FROM recorddata rd
INNER JOIN lookupngnet.dbo.dgroup dg ON rd.column2 = Convert(NVARCHAR(50), dg.druggroupid)
INNER JOIN patients p ON p.recordguid = rd.recordguid
INNER JOIN complaint c ON c.complaintguid = rd.complaintguid
INNER JOIN encounter e ON e.encounterguid = c.encounterguid
INNER JOIN person prac ON prac.partyguid = e.authorguid
LEFT OUTER JOIN partydata pdq ON p.partyguid = pdq.partyguid
AND pdq.usetypeid = 100003
AND pdq.formattypeid = 100000
AND pdq.RemovedDate is null
WHERE rd.usetypeid = 100022
AND dg.atccode LIKE 'J%'
AND rd.removeddate IS NULL
AND rd.startdate >= @ReportStartDate
AND rd.startDate < DateAdd(day,1,@ReportEndDate)
Partyguid
System.Guid
PatientName
System.String
Druggroupid
System.Int32
AtcCode
System.String
DrugName
System.String
Age
System.Int32
EthnicityName
System.String
PractitionerName
System.String
Sex
System.String
Quintile
System.String
dsAntibiotics
E:\Working\Test Projects\Simple Report\Simple Report\AntibioticsPrescribed\dsAntibiotics.xsd
DataTable1
Fill
GetData
DataTable1TableAdapter
DateTime
Report Start Date
DateTime
Report End Date
Cm
65be8eb7-1d1b-4c4d-b46f-29263055125e