Produced by Araxis Merge on 10/18/2017 8:22:15 AM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | RAMS.zip\RAMS\UI\R2.1\Reports | Study State Counts Report.rdl | Wed Oct 18 12:48:38 2017 UTC |
2 | RAMS.zip\RAMS\UI\R2.1\Reports | Study State Counts Report.rdl | Wed Oct 18 13:02:13 2017 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 664 |
Changed | 1 | 2 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | <?xml vers ion="1.0" encoding=" utf-8"?> | |
2 | <Report xm lns="http: //schemas. microsoft. com/sqlser ver/report ing/2008/0 1/reportde finition" xmlns:rd=" http://sch emas.micro soft.com/S QLServer/r eporting/r eportdesig ner"> | |
3 | <Body> | |
4 | <Repor tItems> | |
5 | <Tab lix Name=" table1"> | |
6 | <T ablixBody> | |
7 | <TablixCol umns> | |
8 | <TablixC olumn> | |
9 | <Width >2.04167in </Width> | |
10 | </Tablix Column> | |
11 | <TablixC olumn> | |
12 | <Width >1.57292in </Width> | |
13 | </Tablix Column> | |
14 | </TablixCo lumns> | |
15 | <TablixRow s> | |
16 | <TablixR ow> | |
17 | <Heigh t>0.22in</ Height> | |
18 | <Tabli xCells> | |
19 | <Tab lixCell> | |
20 | <C ellContent s> | |
21 | <Textbox N ame="textb ox2"> | |
22 | <CanGrow >true</Can Grow> | |
23 | <KeepTog ether>true </KeepToge ther> | |
24 | <Paragra phs> | |
25 | <Parag raph> | |
26 | <Tex tRuns> | |
27 | <T extRun> | |
28 | <Value>Stu dy State</ Value> | |
29 | <Style> | |
30 | <FontFam ily>Tahoma </FontFami ly> | |
31 | <FontSiz e>11pt</Fo ntSize> | |
32 | <FontWei ght>Bold</ FontWeight > | |
33 | <Color>W hite</Colo r> | |
34 | </Style> | |
35 | </ TextRun> | |
36 | </Te xtRuns> | |
37 | <Sty le> | |
38 | <T extAlign>C enter</Tex tAlign> | |
39 | </St yle> | |
40 | </Para graph> | |
41 | </Paragr aphs> | |
42 | <rd:Defa ultName>te xtbox2</rd :DefaultNa me> | |
43 | <Style> | |
44 | <Borde r> | |
45 | <Col or>LightGr ey</Color> | |
46 | <Sty le>Solid</ Style> | |
47 | </Bord er> | |
48 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
49 | <Paddi ngLeft>2pt </PaddingL eft> | |
50 | <Paddi ngRight>2p t</Padding Right> | |
51 | <Paddi ngTop>2pt< /PaddingTo p> | |
52 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
53 | </Style> | |
54 | </Textbox> | |
55 | </ CellConten ts> | |
56 | </Ta blixCell> | |
57 | <Tab lixCell> | |
58 | <C ellContent s> | |
59 | <Textbox N ame="textb ox3"> | |
60 | <CanGrow >true</Can Grow> | |
61 | <KeepTog ether>true </KeepToge ther> | |
62 | <Paragra phs> | |
63 | <Parag raph> | |
64 | <Tex tRuns> | |
65 | <T extRun> | |
66 | <Value>Num ber Of Stu dies</Valu e> | |
67 | <Style> | |
68 | <FontFam ily>Tahoma </FontFami ly> | |
69 | <FontSiz e>11pt</Fo ntSize> | |
70 | <FontWei ght>Bold</ FontWeight > | |
71 | <Color>W hite</Colo r> | |
72 | </Style> | |
73 | </ TextRun> | |
74 | </Te xtRuns> | |
75 | <Sty le> | |
76 | <T extAlign>C enter</Tex tAlign> | |
77 | </St yle> | |
78 | </Para graph> | |
79 | </Paragr aphs> | |
80 | <rd:Defa ultName>te xtbox3</rd :DefaultNa me> | |
81 | <Style> | |
82 | <Borde r> | |
83 | <Col or>LightGr ey</Color> | |
84 | <Sty le>Solid</ Style> | |
85 | </Bord er> | |
86 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
87 | <Paddi ngLeft>2pt </PaddingL eft> | |
88 | <Paddi ngRight>2p t</Padding Right> | |
89 | <Paddi ngTop>2pt< /PaddingTo p> | |
90 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
91 | </Style> | |
92 | </Textbox> | |
93 | </ CellConten ts> | |
94 | </Ta blixCell> | |
95 | </Tabl ixCells> | |
96 | </Tablix Row> | |
97 | <TablixR ow> | |
98 | <Heigh t>0.21in</ Height> | |
99 | <Tabli xCells> | |
100 | <Tab lixCell> | |
101 | <C ellContent s> | |
102 | <Textbox N ame="Name" > | |
103 | <CanGrow >true</Can Grow> | |
104 | <KeepTog ether>true </KeepToge ther> | |
105 | <Paragra phs> | |
106 | <Parag raph> | |
107 | <Tex tRuns> | |
108 | <T extRun> | |
109 | <Value>=Fi elds!Name. Value</Val ue> | |
110 | <Style> | |
111 | <FontFam ily>Tahoma </FontFami ly> | |
112 | </Style> | |
113 | </ TextRun> | |
114 | </Te xtRuns> | |
115 | <Sty le> | |
116 | <T extAlign>C enter</Tex tAlign> | |
117 | </St yle> | |
118 | </Para graph> | |
119 | </Paragr aphs> | |
120 | <rd:Defa ultName>Na me</rd:Def aultName> | |
121 | <Style> | |
122 | <Borde r> | |
123 | <Col or>LightGr ey</Color> | |
124 | <Sty le>Solid</ Style> | |
125 | </Bord er> | |
126 | <Paddi ngLeft>2pt </PaddingL eft> | |
127 | <Paddi ngRight>2p t</Padding Right> | |
128 | <Paddi ngTop>2pt< /PaddingTo p> | |
129 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
130 | </Style> | |
131 | </Textbox> | |
132 | </ CellConten ts> | |
133 | </Ta blixCell> | |
134 | <Tab lixCell> | |
135 | <C ellContent s> | |
136 | <Textbox N ame="Numbe rOfStudies "> | |
137 | <CanGrow >true</Can Grow> | |
138 | <KeepTog ether>true </KeepToge ther> | |
139 | <Paragra phs> | |
140 | <Parag raph> | |
141 | <Tex tRuns> | |
142 | <T extRun> | |
143 | <Value>=Fi elds!Numbe rOfStudies .Value</Va lue> | |
144 | <Style> | |
145 | <FontFam ily>Tahoma </FontFami ly> | |
146 | </Style> | |
147 | </ TextRun> | |
148 | </Te xtRuns> | |
149 | <Sty le> | |
150 | <T extAlign>C enter</Tex tAlign> | |
151 | </St yle> | |
152 | </Para graph> | |
153 | </Paragr aphs> | |
154 | <rd:Defa ultName>Nu mberOfStud ies</rd:De faultName> | |
155 | <Style> | |
156 | <Borde r> | |
157 | <Col or>LightGr ey</Color> | |
158 | <Sty le>Solid</ Style> | |
159 | </Bord er> | |
160 | <Paddi ngLeft>2pt </PaddingL eft> | |
161 | <Paddi ngRight>2p t</Padding Right> | |
162 | <Paddi ngTop>2pt< /PaddingTo p> | |
163 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
164 | </Style> | |
165 | </Textbox> | |
166 | </ CellConten ts> | |
167 | </Ta blixCell> | |
168 | </Tabl ixCells> | |
169 | </Tablix Row> | |
170 | </TablixRo ws> | |
171 | </ TablixBody > | |
172 | <T ablixColum nHierarchy > | |
173 | <TablixMem bers> | |
174 | <TablixM ember /> | |
175 | <TablixM ember /> | |
176 | </TablixMe mbers> | |
177 | </ TablixColu mnHierarch y> | |
178 | <T ablixRowHi erarchy> | |
179 | <TablixMem bers> | |
180 | <TablixM ember> | |
181 | <KeepW ithGroup>A fter</Keep WithGroup> | |
182 | <Repea tOnNewPage >true</Rep eatOnNewPa ge> | |
183 | <KeepT ogether>tr ue</KeepTo gether> | |
184 | </Tablix Member> | |
185 | <TablixM ember> | |
186 | <Group Name="tab le1_Detail s_Group"> | |
187 | <Dat aElementNa me>Detail< /DataEleme ntName> | |
188 | </Grou p> | |
189 | <Tabli xMembers> | |
190 | <Tab lixMember /> | |
191 | </Tabl ixMembers> | |
192 | <DataE lementName >Detail_Co llection</ DataElemen tName> | |
193 | <DataE lementOutp ut>Output< /DataEleme ntOutput> | |
194 | <KeepT ogether>tr ue</KeepTo gether> | |
195 | </Tablix Member> | |
196 | </TablixMe mbers> | |
197 | </ TablixRowH ierarchy> | |
198 | <D ataSetName >DataSet1< /DataSetNa me> | |
199 | <T op>0.36in< /Top> | |
200 | <H eight>0.43 in</Height > | |
201 | <W idth>3.614 58in</Widt h> | |
202 | <S tyle /> | |
203 | </Ta blix> | |
204 | <Tex tbox Name= "textbox1" > | |
205 | <C anGrow>tru e</CanGrow > | |
206 | <K eepTogethe r>true</Ke epTogether > | |
207 | <P aragraphs> | |
208 | <Paragraph > | |
209 | <TextRun s> | |
210 | <TextR un> | |
211 | <Val ue>Study S tate Count s Report - Year To D ate</Value > | |
212 | <Sty le> | |
213 | <F ontFamily> Tahoma</Fo ntFamily> | |
214 | <F ontSize>20 pt</FontSi ze> | |
215 | <F ontWeight> Bold</Font Weight> | |
216 | <C olor>Steel Blue</Colo r> | |
217 | </St yle> | |
218 | </Text Run> | |
219 | </TextRu ns> | |
220 | <Style> | |
221 | <TextA lign>Cente r</TextAli gn> | |
222 | </Style> | |
223 | </Paragrap h> | |
224 | </ Paragraphs > | |
225 | <r d:DefaultN ame>textbo x1</rd:Def aultName> | |
226 | <H eight>0.36 in</Height > | |
227 | <W idth>6.197 92in</Widt h> | |
228 | <Z Index>1</Z Index> | |
229 | <S tyle> | |
230 | <PaddingLe ft>2pt</Pa ddingLeft> | |
231 | <PaddingRi ght>2pt</P addingRigh t> | |
232 | <PaddingTo p>2pt</Pad dingTop> | |
233 | <PaddingBo ttom>2pt</ PaddingBot tom> | |
234 | </ Style> | |
235 | </Te xtbox> | |
236 | </Repo rtItems> | |
237 | <Heigh t>0.79in</ Height> | |
238 | <Style /> | |
239 | </Body> | |
240 | <Width>6 .51042in</ Width> | |
241 | <Page> | |
242 | <LeftM argin>1in< /LeftMargi n> | |
243 | <Right Margin>1in </RightMar gin> | |
244 | <TopMa rgin>1in</ TopMargin> | |
245 | <Botto mMargin>1i n</BottomM argin> | |
246 | <Style /> | |
247 | </Page> | |
248 | <AutoRef resh>0</Au toRefresh> | |
249 | <DataSou rces> | |
250 | <DataS ource Name ="RAMS_DB" > | |
251 | <Con nectionPro perties> | |
252 | <D ataProvide r>SQL</Dat aProvider> | |
253 | <ConnectSt ring>Data Source= DNS SQLRAM804; Initial Ca talog=RAMS </ConnectS tring> | |
254 | <I ntegratedS ecurity>tr ue</Integr atedSecuri ty> | |
255 | </Co nnectionPr operties> | |
256 | <rd: SecurityTy pe>Integra ted</rd:Se curityType > | |
257 | <rd: DataSource ID>2d844b4 1-b40f-455 5-8f42-a82 9111ee8cc< /rd:DataSo urceID> | |
258 | </Data Source> | |
259 | </DataSo urces> | |
260 | <DataSet s> | |
261 | <DataS et Name="D ataSet1"> | |
262 | <Que ry> | |
263 | <D ataSourceN ame>RAMS_D B</DataSou rceName> | |
264 | <Q ueryParame ters> | |
265 | <QueryPara meter Name ="Facility "> | |
266 | <Value>= CStr(Param eters!Faci lity.Value )</Value> | |
267 | <rd:User Defined>tr ue</rd:Use rDefined> | |
268 | </QueryPar ameter> | |
269 | </ QueryParam eters> | |
270 | <C ommandType >StoredPro cedure</Co mmandType> | |
271 | <C ommandText >StudyStat eCountsRep ort</Comma ndText> | |
272 | <r d:UseGener icDesigner >true</rd: UseGeneric Designer> | |
273 | </Qu ery> | |
274 | <Fie lds> | |
275 | <F ield Name= "Name"> | |
276 | <DataField >Name</Dat aField> | |
277 | <rd:TypeNa me>System. String</rd :TypeName> | |
278 | </ Field> | |
279 | <F ield Name= "NumberOfS tudies"> | |
280 | <DataField >NumberOfS tudies</Da taField> | |
281 | <rd:TypeNa me>System. Int32</rd: TypeName> | |
282 | </ Field> | |
283 | </Fi elds> | |
284 | </Data Set> | |
285 | <DataS et Name="F acilityLis t"> | |
286 | <Que ry> | |
287 | <D ataSourceN ame>RAMS_D B</DataSou rceName> | |
288 | <C ommandText >with CTE | |
289 | AS | |
290 | (select SS .StudiesID , SS.Updat edAt, SS.S tudystates ID,S.Name | |
291 | FROM Study _Status SS | |
292 | inner joi n (Select StudiesID, MAX(Updat edAt) as M axStudyDat e | |
293 | FROM Stu dy_Status | |
294 | GROUP BY StudiesID ) A | |
295 | ON SS.Stud iesID = A. StudiesID | |
296 | join Study _States S on SS.Stud yStatesID = S.StudyS tatesID | |
297 | AND SS.Upd atedAt = A .MaxStudyD ate) , CTE 2 AS | |
298 | ||
299 | (SELECT S.Stu diesID, QR .Response | |
300 | FROM dbo.Stud ies AS S I NNER JOIN | |
301 | dbo.Stud y_Status A S SS ON S. StudiesID = SS.Studi esID INNER JOIN | |
302 | dbo.Ques tions_Resp onses AS Q R ON QR.St udyStatusI D = SS.Stu dyStatusID | |
303 | WHER E ( QR.Questio nsID IN (1 4144))) | |
304 | ||
305 | select dis tinct conv ert(varcha r(100),CTE 2.Response ) AS Facil ityName | |
306 | from CTE2< /CommandTe xt> | |
307 | </Qu ery> | |
308 | <Fie lds> | |
309 | <F ield Name= "FacilityN ame"> | |
310 | <DataField >FacilityN ame</DataF ield> | |
311 | <rd:TypeNa me>System. String</rd :TypeName> | |
312 | </ Field> | |
313 | </Fi elds> | |
314 | </Data Set> | |
315 | </DataSe ts> | |
316 | <ReportP arameters> | |
317 | <Repor tParameter Name="Fac ility"> | |
318 | <Dat aType>Stri ng</DataTy pe> | |
319 | <Pro mpt>Choose Facility< /Prompt> | |
320 | <Val idValues> | |
321 | <D ataSetRefe rence> | |
322 | <DataSetNa me>Facilit yList</Dat aSetName> | |
323 | <ValueFiel d>Facility Name</Valu eField> | |
324 | <LabelFiel d>Facility Name</Labe lField> | |
325 | </ DataSetRef erence> | |
326 | </Va lidValues> | |
327 | </Repo rtParamete r> | |
328 | </Report Parameters > | |
329 | <Languag e>en-US</L anguage> | |
330 | <Consume ContainerW hitespace> true</Cons umeContain erWhitespa ce> | |
331 | <rd:Repo rtUnitType >Inch</rd: ReportUnit Type> | |
332 | <rd:Repo rtID>a2d23 7a7-738c-4 308-833e-8 dc3592384e 6</rd:Repo rtID> | |
333 | </Report> |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.