Produced by Araxis Merge on 7/17/2018 6:16:26 PM Eastern 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-2.3.0.zip\RAMS-2.3.0\Reports\CIRB Reports | CIRB_LSIClosedWithdrawn.rdl | Mon May 14 01:50:40 2018 UTC |
2 | RAMS-2.3.0.zip\RAMS-2.3.0\Reports\CIRB Reports | CIRB_LSIClosedWithdrawn.rdl | Tue Jul 17 20:44:31 2018 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 1334 |
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 >1.42292in </Width> | |
10 | </Tablix Column> | |
11 | <TablixC olumn> | |
12 | <Width >5.12083in </Width> | |
13 | </Tablix Column> | |
14 | <TablixC olumn> | |
15 | <Width >2.61042in </Width> | |
16 | </Tablix Column> | |
17 | <TablixC olumn> | |
18 | <Width >2.80833in </Width> | |
19 | </Tablix Column> | |
20 | <TablixC olumn> | |
21 | <Width >2.25625in </Width> | |
22 | </Tablix Column> | |
23 | </TablixCo lumns> | |
24 | <TablixRow s> | |
25 | <TablixR ow> | |
26 | <Heigh t>0.22in</ Height> | |
27 | <Tabli xCells> | |
28 | <Tab lixCell> | |
29 | <C ellContent s> | |
30 | <Textbox N ame="textb ox2"> | |
31 | <CanGrow >true</Can Grow> | |
32 | <UserSor t> | |
33 | <SortE xpression> =Fields!CI RB_ID.Valu e</SortExp ression> | |
34 | </UserSo rt> | |
35 | <KeepTog ether>true </KeepToge ther> | |
36 | <Paragra phs> | |
37 | <Parag raph> | |
38 | <Tex tRuns> | |
39 | <T extRun> | |
40 | <Value>CIR B Number</ Value> | |
41 | <Style> | |
42 | <FontFam ily>Tahoma </FontFami ly> | |
43 | <FontSiz e>11pt</Fo ntSize> | |
44 | <FontWei ght>Bold</ FontWeight > | |
45 | <Color>W hite</Colo r> | |
46 | </Style> | |
47 | </ TextRun> | |
48 | </Te xtRuns> | |
49 | <Sty le /> | |
50 | </Para graph> | |
51 | </Paragr aphs> | |
52 | <rd:Defa ultName>te xtbox2</rd :DefaultNa me> | |
53 | <Style> | |
54 | <Borde r> | |
55 | <Col or>LightGr ey</Color> | |
56 | <Sty le>Solid</ Style> | |
57 | </Bord er> | |
58 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
59 | <Paddi ngLeft>2pt </PaddingL eft> | |
60 | <Paddi ngRight>2p t</Padding Right> | |
61 | <Paddi ngTop>2pt< /PaddingTo p> | |
62 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
63 | </Style> | |
64 | </Textbox> | |
65 | </ CellConten ts> | |
66 | </Ta blixCell> | |
67 | <Tab lixCell> | |
68 | <C ellContent s> | |
69 | <Textbox N ame="textb ox3"> | |
70 | <CanGrow >true</Can Grow> | |
71 | <UserSor t> | |
72 | <SortE xpression> =Fields!St udy_Title. Value</Sor tExpressio n> | |
73 | </UserSo rt> | |
74 | <KeepTog ether>true </KeepToge ther> | |
75 | <Paragra phs> | |
76 | <Parag raph> | |
77 | <Tex tRuns> | |
78 | <T extRun> | |
79 | <Value>Pro tocolTitle </Value> | |
80 | <Style> | |
81 | <FontFam ily>Tahoma </FontFami ly> | |
82 | <FontSiz e>11pt</Fo ntSize> | |
83 | <FontWei ght>Bold</ FontWeight > | |
84 | <Color>W hite</Colo r> | |
85 | </Style> | |
86 | </ TextRun> | |
87 | </Te xtRuns> | |
88 | <Sty le /> | |
89 | </Para graph> | |
90 | </Paragr aphs> | |
91 | <rd:Defa ultName>te xtbox3</rd :DefaultNa me> | |
92 | <Style> | |
93 | <Borde r> | |
94 | <Col or>LightGr ey</Color> | |
95 | <Sty le>Solid</ Style> | |
96 | </Bord er> | |
97 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
98 | <Paddi ngLeft>2pt </PaddingL eft> | |
99 | <Paddi ngRight>2p t</Padding Right> | |
100 | <Paddi ngTop>2pt< /PaddingTo p> | |
101 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
102 | </Style> | |
103 | </Textbox> | |
104 | </ CellConten ts> | |
105 | </Ta blixCell> | |
106 | <Tab lixCell> | |
107 | <C ellContent s> | |
108 | <Textbox N ame="Textb ox11"> | |
109 | <CanGrow >true</Can Grow> | |
110 | <UserSor t> | |
111 | <SortE xpression> =Fields!Fa cilities_L ookup.Valu e</SortExp ression> | |
112 | </UserSo rt> | |
113 | <KeepTog ether>true </KeepToge ther> | |
114 | <Paragra phs> | |
115 | <Parag raph> | |
116 | <Tex tRuns> | |
117 | <T extRun> | |
118 | <Value>LSI Location< /Value> | |
119 | <Style> | |
120 | <FontFam ily>Tahoma </FontFami ly> | |
121 | <FontSiz e>11pt</Fo ntSize> | |
122 | <FontWei ght>Bold</ FontWeight > | |
123 | <Color>W hite</Colo r> | |
124 | </Style> | |
125 | </ TextRun> | |
126 | </Te xtRuns> | |
127 | <Sty le /> | |
128 | </Para graph> | |
129 | </Paragr aphs> | |
130 | <rd:Defa ultName>Te xtbox11</r d:DefaultN ame> | |
131 | <Style> | |
132 | <Borde r> | |
133 | <Col or>LightGr ey</Color> | |
134 | <Sty le>Solid</ Style> | |
135 | </Bord er> | |
136 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
137 | <Paddi ngLeft>2pt </PaddingL eft> | |
138 | <Paddi ngRight>2p t</Padding Right> | |
139 | <Paddi ngTop>2pt< /PaddingTo p> | |
140 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
141 | </Style> | |
142 | </Textbox> | |
143 | </ CellConten ts> | |
144 | </Ta blixCell> | |
145 | <Tab lixCell> | |
146 | <C ellContent s> | |
147 | <Textbox N ame="Textb ox4"> | |
148 | <CanGrow >true</Can Grow> | |
149 | <UserSor t> | |
150 | <SortE xpression> =Fields!Pa rticipatin g_Site_Inv estigator. Value</Sor tExpressio n> | |
151 | </UserSo rt> | |
152 | <KeepTog ether>true </KeepToge ther> | |
153 | <Paragra phs> | |
154 | <Parag raph> | |
155 | <Tex tRuns> | |
156 | <T extRun> | |
157 | <Value>Loc al Site In vestigator </Value> | |
158 | <Style> | |
159 | <FontFam ily>Tahoma </FontFami ly> | |
160 | <FontSiz e>11pt</Fo ntSize> | |
161 | <FontWei ght>Bold</ FontWeight > | |
162 | <Color>W hite</Colo r> | |
163 | </Style> | |
164 | </ TextRun> | |
165 | </Te xtRuns> | |
166 | <Sty le /> | |
167 | </Para graph> | |
168 | </Paragr aphs> | |
169 | <rd:Defa ultName>Te xtbox4</rd :DefaultNa me> | |
170 | <Style> | |
171 | <Borde r> | |
172 | <Col or>LightGr ey</Color> | |
173 | <Sty le>Solid</ Style> | |
174 | </Bord er> | |
175 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
176 | <Paddi ngLeft>2pt </PaddingL eft> | |
177 | <Paddi ngRight>2p t</Padding Right> | |
178 | <Paddi ngTop>2pt< /PaddingTo p> | |
179 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
180 | </Style> | |
181 | </Textbox> | |
182 | </ CellConten ts> | |
183 | </Ta blixCell> | |
184 | <Tab lixCell> | |
185 | <C ellContent s> | |
186 | <Textbox N ame="Textb ox13"> | |
187 | <CanGrow >true</Can Grow> | |
188 | <KeepTog ether>true </KeepToge ther> | |
189 | <Paragra phs> | |
190 | <Parag raph> | |
191 | <Tex tRuns> | |
192 | <T extRun> | |
193 | <Value>Dat e Closed</ Value> | |
194 | <Style> | |
195 | <FontFam ily>Tahoma </FontFami ly> | |
196 | <FontSiz e>11pt</Fo ntSize> | |
197 | <FontWei ght>Bold</ FontWeight > | |
198 | <Color>W hite</Colo r> | |
199 | </Style> | |
200 | </ TextRun> | |
201 | </Te xtRuns> | |
202 | <Sty le /> | |
203 | </Para graph> | |
204 | </Paragr aphs> | |
205 | <rd:Defa ultName>Te xtbox13</r d:DefaultN ame> | |
206 | <Style> | |
207 | <Borde r> | |
208 | <Col or>LightGr ey</Color> | |
209 | <Sty le>Solid</ Style> | |
210 | </Bord er> | |
211 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
212 | <Paddi ngLeft>2pt </PaddingL eft> | |
213 | <Paddi ngRight>2p t</Padding Right> | |
214 | <Paddi ngTop>2pt< /PaddingTo p> | |
215 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
216 | </Style> | |
217 | </Textbox> | |
218 | </ CellConten ts> | |
219 | </Ta blixCell> | |
220 | </Tabl ixCells> | |
221 | </Tablix Row> | |
222 | <TablixR ow> | |
223 | <Heigh t>0.21in</ Height> | |
224 | <Tabli xCells> | |
225 | <Tab lixCell> | |
226 | <C ellContent s> | |
227 | <Textbox N ame="CIRB_ ID"> | |
228 | <CanGrow >true</Can Grow> | |
229 | <KeepTog ether>true </KeepToge ther> | |
230 | <Paragra phs> | |
231 | <Parag raph> | |
232 | <Tex tRuns> | |
233 | <T extRun> | |
234 | <Value>=Fi elds!CIRB_ ID.Value</ Value> | |
235 | <Style> | |
236 | <FontFam ily>Tahoma </FontFami ly> | |
237 | </Style> | |
238 | </ TextRun> | |
239 | </Te xtRuns> | |
240 | <Sty le /> | |
241 | </Para graph> | |
242 | </Paragr aphs> | |
243 | <rd:Defa ultName>CI RB_ID</rd: DefaultNam e> | |
244 | <Style> | |
245 | <Borde r> | |
246 | <Col or>LightGr ey</Color> | |
247 | <Sty le>Solid</ Style> | |
248 | </Bord er> | |
249 | <Paddi ngLeft>2pt </PaddingL eft> | |
250 | <Paddi ngRight>2p t</Padding Right> | |
251 | <Paddi ngTop>2pt< /PaddingTo p> | |
252 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
253 | </Style> | |
254 | </Textbox> | |
255 | </ CellConten ts> | |
256 | </Ta blixCell> | |
257 | <Tab lixCell> | |
258 | <C ellContent s> | |
259 | <Textbox N ame="Study _Title"> | |
260 | <CanGrow >true</Can Grow> | |
261 | <KeepTog ether>true </KeepToge ther> | |
262 | <Paragra phs> | |
263 | <Parag raph> | |
264 | <Tex tRuns> | |
265 | <T extRun> | |
266 | <Value>=Fi elds!Study _Title.Val ue</Value> | |
267 | <Style> | |
268 | <FontFam ily>Tahoma </FontFami ly> | |
269 | </Style> | |
270 | </ TextRun> | |
271 | </Te xtRuns> | |
272 | <Sty le /> | |
273 | </Para graph> | |
274 | </Paragr aphs> | |
275 | <rd:Defa ultName>St udy_Title< /rd:Defaul tName> | |
276 | <Style> | |
277 | <Borde r> | |
278 | <Col or>LightGr ey</Color> | |
279 | <Sty le>Solid</ Style> | |
280 | </Bord er> | |
281 | <Paddi ngLeft>2pt </PaddingL eft> | |
282 | <Paddi ngRight>2p t</Padding Right> | |
283 | <Paddi ngTop>2pt< /PaddingTo p> | |
284 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
285 | </Style> | |
286 | </Textbox> | |
287 | </ CellConten ts> | |
288 | </Ta blixCell> | |
289 | <Tab lixCell> | |
290 | <C ellContent s> | |
291 | <Textbox N ame="Facil ities_Look up"> | |
292 | <CanGrow >true</Can Grow> | |
293 | <KeepTog ether>true </KeepToge ther> | |
294 | <Paragra phs> | |
295 | <Parag raph> | |
296 | <Tex tRuns> | |
297 | <T extRun> | |
298 | <Value>=Fi elds!Facil ities_Look up.Value</ Value> | |
299 | <Style> | |
300 | <FontFam ily>Tahoma </FontFami ly> | |
301 | </Style> | |
302 | </ TextRun> | |
303 | </Te xtRuns> | |
304 | <Sty le /> | |
305 | </Para graph> | |
306 | </Paragr aphs> | |
307 | <rd:Defa ultName>Fa cilities_L ookup</rd: DefaultNam e> | |
308 | <Style> | |
309 | <Borde r> | |
310 | <Col or>LightGr ey</Color> | |
311 | <Sty le>Solid</ Style> | |
312 | </Bord er> | |
313 | <Paddi ngLeft>2pt </PaddingL eft> | |
314 | <Paddi ngRight>2p t</Padding Right> | |
315 | <Paddi ngTop>2pt< /PaddingTo p> | |
316 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
317 | </Style> | |
318 | </Textbox> | |
319 | </ CellConten ts> | |
320 | </Ta blixCell> | |
321 | <Tab lixCell> | |
322 | <C ellContent s> | |
323 | <Textbox N ame="Parti cipating_S ite_Invest igator1"> | |
324 | <CanGrow >true</Can Grow> | |
325 | <KeepTog ether>true </KeepToge ther> | |
326 | <Paragra phs> | |
327 | <Parag raph> | |
328 | <Tex tRuns> | |
329 | <T extRun> | |
330 | <Value>=Fi elds!Parti cipating_S ite_Invest igator.Val ue</Value> | |
331 | <Style> | |
332 | <FontFam ily>Tahoma </FontFami ly> | |
333 | </Style> | |
334 | </ TextRun> | |
335 | </Te xtRuns> | |
336 | <Sty le /> | |
337 | </Para graph> | |
338 | </Paragr aphs> | |
339 | <rd:Defa ultName>Pa rticipatin g_Site_Inv estigator1 </rd:Defau ltName> | |
340 | <Style> | |
341 | <Borde r> | |
342 | <Col or>LightGr ey</Color> | |
343 | <Sty le>Solid</ Style> | |
344 | </Bord er> | |
345 | <Paddi ngLeft>2pt </PaddingL eft> | |
346 | <Paddi ngRight>2p t</Padding Right> | |
347 | <Paddi ngTop>2pt< /PaddingTo p> | |
348 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
349 | </Style> | |
350 | </Textbox> | |
351 | </ CellConten ts> | |
352 | </Ta blixCell> | |
353 | <Tab lixCell> | |
354 | <C ellContent s> | |
355 | <Textbox N ame="Textb ox14"> | |
356 | <CanGrow >true</Can Grow> | |
357 | <KeepTog ether>true </KeepToge ther> | |
358 | <Paragra phs> | |
359 | <Parag raph> | |
360 | <Tex tRuns> | |
361 | <T extRun> | |
362 | <Value>="N /A"</Value > | |
363 | <Style> | |
364 | <FontFam ily>Tahoma </FontFami ly> | |
365 | </Style> | |
366 | </ TextRun> | |
367 | </Te xtRuns> | |
368 | <Sty le /> | |
369 | </Para graph> | |
370 | </Paragr aphs> | |
371 | <rd:Defa ultName>Te xtbox14</r d:DefaultN ame> | |
372 | <Style> | |
373 | <Borde r> | |
374 | <Col or>LightGr ey</Color> | |
375 | <Sty le>Solid</ Style> | |
376 | </Bord er> | |
377 | <Paddi ngLeft>2pt </PaddingL eft> | |
378 | <Paddi ngRight>2p t</Padding Right> | |
379 | <Paddi ngTop>2pt< /PaddingTo p> | |
380 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
381 | </Style> | |
382 | </Textbox> | |
383 | </ CellConten ts> | |
384 | </Ta blixCell> | |
385 | </Tabl ixCells> | |
386 | </Tablix Row> | |
387 | </TablixRo ws> | |
388 | </ TablixBody > | |
389 | <T ablixColum nHierarchy > | |
390 | <TablixMem bers> | |
391 | <TablixM ember /> | |
392 | <TablixM ember /> | |
393 | <TablixM ember /> | |
394 | <TablixM ember /> | |
395 | <TablixM ember /> | |
396 | </TablixMe mbers> | |
397 | </ TablixColu mnHierarch y> | |
398 | <T ablixRowHi erarchy> | |
399 | <TablixMem bers> | |
400 | <TablixM ember> | |
401 | <KeepW ithGroup>A fter</Keep WithGroup> | |
402 | <Repea tOnNewPage >true</Rep eatOnNewPa ge> | |
403 | <KeepT ogether>tr ue</KeepTo gether> | |
404 | </Tablix Member> | |
405 | <TablixM ember> | |
406 | <Group Name="tab le1_Detail s_Group"> | |
407 | <Dat aElementNa me>Detail< /DataEleme ntName> | |
408 | </Grou p> | |
409 | <Tabli xMembers> | |
410 | <Tab lixMember /> | |
411 | </Tabl ixMembers> | |
412 | <DataE lementName >Detail_Co llection</ DataElemen tName> | |
413 | <DataE lementOutp ut>Output< /DataEleme ntOutput> | |
414 | <KeepT ogether>tr ue</KeepTo gether> | |
415 | </Tablix Member> | |
416 | </TablixMe mbers> | |
417 | </ TablixRowH ierarchy> | |
418 | <D ataSetName >RAMSSP_DS </DataSetN ame> | |
419 | <T op>0.41556 in</Top> | |
420 | <H eight>0.43 in</Height > | |
421 | <W idth>14.21 875in</Wid th> | |
422 | <S tyle /> | |
423 | </Ta blix> | |
424 | <Tex tbox Name= "textbox1" > | |
425 | <C anGrow>tru e</CanGrow > | |
426 | <K eepTogethe r>true</Ke epTogether > | |
427 | <P aragraphs> | |
428 | <Paragraph > | |
429 | <TextRun s> | |
430 | <TextR un> | |
431 | <Val ue> L SI Closed and Withdr awn</Value > | |
432 | <Sty le> | |
433 | <F ontFamily> Tahoma</Fo ntFamily> | |
434 | <F ontSize>20 pt</FontSi ze> | |
435 | <F ontWeight> Bold</Font Weight> | |
436 | <C olor>Steel Blue</Colo r> | |
437 | </St yle> | |
438 | </Text Run> | |
439 | </TextRu ns> | |
440 | <Style> | |
441 | <TextA lign>Cente r</TextAli gn> | |
442 | </Style> | |
443 | </Paragrap h> | |
444 | <Paragraph > | |
445 | <TextRun s> | |
446 | <TextR un> | |
447 | <Val ue xml:spa ce="preser ve"> </Valu e> | |
448 | <Sty le> | |
449 | <F ontFamily> Tahoma</Fo ntFamily> | |
450 | <F ontSize>11 pt</FontSi ze> | |
451 | <C olor>Steel Blue</Colo r> | |
452 | </St yle> | |
453 | </Text Run> | |
454 | <TextR un> | |
455 | <Lab el>Date</L abel> | |
456 | <Val ue>=DateAd d("d", 0, now())</Va lue> | |
457 | <Sty le> | |
458 | <F ontFamily> Tahoma</Fo ntFamily> | |
459 | <F ontSize>11 pt</FontSi ze> | |
460 | <C olor>Steel Blue</Colo r> | |
461 | </St yle> | |
462 | </Text Run> | |
463 | </TextRu ns> | |
464 | <Style> | |
465 | <TextA lign>Cente r</TextAli gn> | |
466 | </Style> | |
467 | </Paragrap h> | |
468 | </ Paragraphs > | |
469 | <r d:DefaultN ame>textbo x1</rd:Def aultName> | |
470 | <H eight>0.36 in</Height > | |
471 | <W idth>14.21 875in</Wid th> | |
472 | <Z Index>1</Z Index> | |
473 | <S tyle> | |
474 | <PaddingLe ft>2pt</Pa ddingLeft> | |
475 | <PaddingRi ght>2pt</P addingRigh t> | |
476 | <PaddingTo p>2pt</Pad dingTop> | |
477 | <PaddingBo ttom>2pt</ PaddingBot tom> | |
478 | </ Style> | |
479 | </Te xtbox> | |
480 | </Repo rtItems> | |
481 | <Heigh t>0.84556i n</Height> | |
482 | <Style /> | |
483 | </Body> | |
484 | <Width>1 4.21875in< /Width> | |
485 | <Page> | |
486 | <LeftM argin>1in< /LeftMargi n> | |
487 | <Right Margin>1in </RightMar gin> | |
488 | <TopMa rgin>1in</ TopMargin> | |
489 | <Botto mMargin>1i n</BottomM argin> | |
490 | <Style /> | |
491 | </Page> | |
492 | <AutoRef resh>0</Au toRefresh> | |
493 | <DataSou rces> | |
494 | <DataS ource Name ="RAMS_SP" > | |
495 | <Dat aSourceRef erence>RAM S_SP</Data SourceRefe rence> | |
496 | <rd: SecurityTy pe>None</r d:Security Type> | |
497 | <rd: DataSource ID>c0c279b 8-bdc9-43d 4-957b-163 1dffd2926< /rd:DataSo urceID> | |
498 | </Data Source> | |
499 | <DataS ource Name ="RAMS_DB" > | |
500 | <Con nectionPro perties> | |
501 | <D ataProvide r>SQL</Dat aProvider> | |
502 | <ConnectSt ring>Data Source= DN S ;Initial C atalog=RAM S</Connect String> | |
503 | <I ntegratedS ecurity>tr ue</Integr atedSecuri ty> | |
504 | </Co nnectionPr operties> | |
505 | <rd: SecurityTy pe>Integra ted</rd:Se curityType > | |
506 | <rd: DataSource ID>86c36a1 c-d323-4eb c-b0b8-1fa 8c42cb8c3< /rd:DataSo urceID> | |
507 | </Data Source> | |
508 | </DataSo urces> | |
509 | <DataSet s> | |
510 | <DataS et Name="R AMSSP_DS"> | |
511 | <Que ry> | |
512 | <D ataSourceN ame>RAMS_S P</DataSou rceName> | |
513 | <C ommandText ><RSSha rePointLis t xmlns:xs i="http:// www.w3.org /2001/XMLS chema-inst ance" xmln s:xsd="htt p://www.w3 .org/2001/ XMLSchema" > | |
514 | <List Name>Ap plication& lt;/ListNa me> | |
515 | <View Fields> | |
516 | <Fi eldRef Nam e="CIRB_ID " /> | |
517 | <Fi eldRef Nam e="StudyTi tle" /> | |
518 | <Fi eldRef Nam e="Princip alInvestig ator" /> ; | |
519 | <Fi eldRef Nam e="Assigne dIRBAdmini strator" / > | |
520 | <Fi eldRef Nam e="ID" /&g t; | |
521 | <Fi eldRef Nam e="CIRB" / > | |
522 | <Fi eldRef Nam e="Partici patingSite Investigat or" /> | |
523 | <Fi eldRef Nam e="Applica tionStatus " /> | |
524 | <Fi eldRef Nam e="Facilit iesLookup" /> | |
525 | </Vie wFields> ; | |
526 | <Quer y> | |
527 | <Wh ere> | |
528 | < And> | |
529 | &l t;And> | |
530 | <And> ; | |
531 | <Eq&g t; | |
532 | <Fi eldRef Nam e="CIRB" / > | |
533 | <Va lue Type=" Text">Y es</Val ue> | |
534 | </Eq& gt; | |
535 | <Cont ains> | |
536 | <Fi eldRef Nam e="StudyTi tle" /> | |
537 | <Va lue Type=" Text">L ocal Site Applicatio n</Valu e> | |
538 | </Con tains> | |
539 | </And&g t; | |
540 | <Contai ns> | |
541 | <Fiel dRef Name= "Applicati onStatus" /> | |
542 | <Valu e Type="Te xt">App roved</ Value> | |
543 | </Conta ins> | |
544 | &l t;/And> | |
545 | &l t;Contains > | |
546 | <FieldR ef Name="S tudyTitle" /> | |
547 | <Value Type="Text ">Close out</Va lue> | |
548 | &l t;/Contain s> | |
549 | < /And> | |
550 | </W here> | |
551 | </Que ry> | |
552 | </RSSha rePointLis t></Com mandText> | |
553 | <r d:Designer State> | |
554 | <QueryDefi nition xml ns="http:/ /schemas.m icrosoft.c om/Reporti ngServices /QueryDefi nition/Rel ational"> | |
555 | <Selecte dColumns> | |
556 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" CIRB_ID" / > | |
557 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" StudyTitle " /> | |
558 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" PrincipalI nvestigato r" /> | |
559 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" AssignedIR BAdministr ator" /> | |
560 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" ID" /> | |
561 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" CIRB" /> | |
562 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Participat ingSiteInv estigator" /> | |
563 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Applicatio nStatus" / > | |
564 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Facilities Lookup" /> | |
565 | </Select edColumns> | |
566 | <Filters > | |
567 | <Filte r Operator ="="> | |
568 | <Col umnExpress ion Column Owner="App lication" ColumnName ="CIRB" /> | |
569 | <Fil terValue>Y es</Filter Value> | |
570 | </Filt er> | |
571 | <Filte r Operator ="CONTAINS "> | |
572 | <Col umnExpress ion Column Owner="App lication" ColumnName ="StudyTit le" /> | |
573 | <Fil terValue>L ocal Site Applicatio n</FilterV alue> | |
574 | </Filt er> | |
575 | <Filte r Operator ="CONTAINS "> | |
576 | <Col umnExpress ion Column Owner="App lication" ColumnName ="Applicat ionStatus" /> | |
577 | <Fil terValue>A pproved</F ilterValue > | |
578 | </Filt er> | |
579 | <Filte r Operator ="CONTAINS "> | |
580 | <Col umnExpress ion Column Owner="App lication" ColumnName ="StudyTit le" /> | |
581 | <Fil terValue>C loseout</F ilterValue > | |
582 | </Filt er> | |
583 | </Filter s> | |
584 | </QueryDef inition> | |
585 | </ rd:Designe rState> | |
586 | </Qu ery> | |
587 | <Fie lds> | |
588 | <F ield Name= "CIRB_ID"> | |
589 | <DataField >CIRB_ID</ DataField> | |
590 | <rd:TypeNa me>System. String</rd :TypeName> | |
591 | </ Field> | |
592 | <F ield Name= "Study_Tit le"> | |
593 | <DataField >StudyTitl e</DataFie ld> | |
594 | <rd:TypeNa me>System. String</rd :TypeName> | |
595 | </ Field> | |
596 | <F ield Name= "Principal _Investiga tor"> | |
597 | <DataField >Principal Investigat or</DataFi eld> | |
598 | <rd:TypeNa me>System. String</rd :TypeName> | |
599 | </ Field> | |
600 | <F ield Name= "Assigned_ IRB_Admini strator"> | |
601 | <DataField >AssignedI RBAdminist rator</Dat aField> | |
602 | <rd:TypeNa me>System. String</rd :TypeName> | |
603 | </ Field> | |
604 | <F ield Name= "ID"> | |
605 | <DataField >ID</DataF ield> | |
606 | <rd:TypeNa me>System. Int32</rd: TypeName> | |
607 | </ Field> | |
608 | <F ield Name= "CIRB"> | |
609 | <DataField >CIRB</Dat aField> | |
610 | <rd:TypeNa me>System. String</rd :TypeName> | |
611 | </ Field> | |
612 | <F ield Name= "Participa ting_Site_ Investigat or"> | |
613 | <DataField >Participa tingSiteIn vestigator </DataFiel d> | |
614 | <rd:TypeNa me>System. String</rd :TypeName> | |
615 | </ Field> | |
616 | <F ield Name= "Facilitie s_Lookup"> | |
617 | <DataField >Facilitie sLookup</D ataField> | |
618 | <rd:TypeNa me>System. String</rd :TypeName> | |
619 | </ Field> | |
620 | <F ield Name= "Applicati on_Status" > | |
621 | <DataField >Applicati onStatus</ DataField> | |
622 | <rd:TypeNa me>System. String</rd :TypeName> | |
623 | </ Field> | |
624 | </Fi elds> | |
625 | </Data Set> | |
626 | <DataS et Name="R AMSDB_DS"> | |
627 | <Que ry> | |
628 | <D ataSourceN ame>RAMS_D B</DataSou rceName> | |
629 | <C ommandText >SELECT S.Upd atedAt, B. SPListItem | |
630 | FROM (SEL ECT StudiesID , MAX(Stag eCounter) AS stageco unter | |
631 | FROM Study_St atus | |
632 | WHER E ( StudyState sID in ( 4,6,7)) | |
633 | GROU P BY Studi esID) AS A INNER JOI N | |
634 | Study _Status AS S ON A.St udiesID = S.StudiesI D AND A.st agecounter = S.Stage Counter IN NER JOIN | |
635 | Studi es AS B ON A.Studies ID = B.Stu diesID</Co mmandText> | |
636 | </Qu ery> | |
637 | <Fie lds> | |
638 | <F ield Name= "UpdatedAt "> | |
639 | <DataField >UpdatedAt </DataFiel d> | |
640 | <rd:TypeNa me>System. DateTime</ rd:TypeNam e> | |
641 | </ Field> | |
642 | <F ield Name= "SPListIte m"> | |
643 | <DataField >SPListIte m</DataFie ld> | |
644 | <rd:TypeNa me>System. Int32</rd: TypeName> | |
645 | </ Field> | |
646 | </Fi elds> | |
647 | </Data Set> | |
648 | </DataSe ts> | |
649 | <Code>Pu blic Share d Function RemoveDup licates(pa rameter As Parameter ) As Strin g() | |
650 | Dim items As Object( ) = parame ter.Value | |
651 | System.Arr ay.Sort(it ems) | |
652 | Dim k As I nteger = 0 | |
653 | For i As I nteger = 0 To items. Length - 1 | |
654 | If i > 0 AndAlso items(i).E quals(item s(i - 1)) Then | |
655 | Continue F or | |
656 | End If | |
657 | items(k) = items(i) | |
658 | k += 1 | |
659 | Next | |
660 | Dim unique As [Strin g]() = New [String]( k - 1) {} | |
661 | System.Arr ay.Copy(it ems, 0, un ique, 0, k ) | |
662 | Return uni que | |
663 | End Functi on</Code> | |
664 | <Languag e>en-US</L anguage> | |
665 | <Consume ContainerW hitespace> true</Cons umeContain erWhitespa ce> | |
666 | <rd:Repo rtUnitType >Inch</rd: ReportUnit Type> | |
667 | <rd:Repo rtID>8c1b1 dbc-72d9-4 492-a8f3-e ba8e8430a7 d</rd:Repo rtID> | |
668 | </Report> |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.