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_ApprovedLSIProjectBySite.rdl | Mon Mar 26 20:12:10 2018 UTC |
2 | RAMS-2.3.0.zip\RAMS-2.3.0\Reports\CIRB Reports | CIRB_ApprovedLSIProjectBySite.rdl | Tue Jul 17 20:43:26 2018 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 1602 |
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.32292in </Width> | |
10 | </Tablix Column> | |
11 | <TablixC olumn> | |
12 | <Width >3.67708in </Width> | |
13 | </Tablix Column> | |
14 | <TablixC olumn> | |
15 | <Width >1.9375in< /Width> | |
16 | </Tablix Column> | |
17 | <TablixC olumn> | |
18 | <Width >2.15625in </Width> | |
19 | </Tablix Column> | |
20 | <TablixC olumn> | |
21 | <Width >2.52083in </Width> | |
22 | </Tablix Column> | |
23 | <TablixC olumn> | |
24 | <Width >1.90625in </Width> | |
25 | </Tablix Column> | |
26 | </TablixCo lumns> | |
27 | <TablixRow s> | |
28 | <TablixR ow> | |
29 | <Heigh t>0.22in</ Height> | |
30 | <Tabli xCells> | |
31 | <Tab lixCell> | |
32 | <C ellContent s> | |
33 | <Textbox N ame="textb ox2"> | |
34 | <CanGrow >true</Can Grow> | |
35 | <KeepTog ether>true </KeepToge ther> | |
36 | <Paragra phs> | |
37 | <Parag raph> | |
38 | <Tex tRuns> | |
39 | <T extRun> | |
40 | <Value>CIR B ID</Valu e> | |
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 | <KeepTog ether>true </KeepToge ther> | |
72 | <Paragra phs> | |
73 | <Parag raph> | |
74 | <Tex tRuns> | |
75 | <T extRun> | |
76 | <Value>Pro tocolTitle </Value> | |
77 | <Style> | |
78 | <FontFam ily>Tahoma </FontFami ly> | |
79 | <FontSiz e>11pt</Fo ntSize> | |
80 | <FontWei ght>Bold</ FontWeight > | |
81 | <Color>W hite</Colo r> | |
82 | </Style> | |
83 | </ TextRun> | |
84 | </Te xtRuns> | |
85 | <Sty le /> | |
86 | </Para graph> | |
87 | </Paragr aphs> | |
88 | <rd:Defa ultName>te xtbox3</rd :DefaultNa me> | |
89 | <Style> | |
90 | <Borde r> | |
91 | <Col or>LightGr ey</Color> | |
92 | <Sty le>Solid</ Style> | |
93 | </Bord er> | |
94 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
95 | <Paddi ngLeft>2pt </PaddingL eft> | |
96 | <Paddi ngRight>2p t</Padding Right> | |
97 | <Paddi ngTop>2pt< /PaddingTo p> | |
98 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
99 | </Style> | |
100 | </Textbox> | |
101 | </ CellConten ts> | |
102 | </Ta blixCell> | |
103 | <Tab lixCell> | |
104 | <C ellContent s> | |
105 | <Textbox N ame="Textb ox11"> | |
106 | <CanGrow >true</Can Grow> | |
107 | <KeepTog ether>true </KeepToge ther> | |
108 | <Paragra phs> | |
109 | <Parag raph> | |
110 | <Tex tRuns> | |
111 | <T extRun> | |
112 | <Value>Cit y/State</V alue> | |
113 | <Style> | |
114 | <FontFam ily>Tahoma </FontFami ly> | |
115 | <FontSiz e>11pt</Fo ntSize> | |
116 | <FontWei ght>Bold</ FontWeight > | |
117 | <Color>W hite</Colo r> | |
118 | </Style> | |
119 | </ TextRun> | |
120 | </Te xtRuns> | |
121 | <Sty le /> | |
122 | </Para graph> | |
123 | </Paragr aphs> | |
124 | <rd:Defa ultName>Te xtbox11</r d:DefaultN ame> | |
125 | <Style> | |
126 | <Borde r> | |
127 | <Col or>LightGr ey</Color> | |
128 | <Sty le>Solid</ Style> | |
129 | </Bord er> | |
130 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
131 | <Paddi ngLeft>2pt </PaddingL eft> | |
132 | <Paddi ngRight>2p t</Padding Right> | |
133 | <Paddi ngTop>2pt< /PaddingTo p> | |
134 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
135 | </Style> | |
136 | </Textbox> | |
137 | </ CellConten ts> | |
138 | </Ta blixCell> | |
139 | <Tab lixCell> | |
140 | <C ellContent s> | |
141 | <Textbox N ame="Textb ox13"> | |
142 | <CanGrow >true</Can Grow> | |
143 | <KeepTog ether>true </KeepToge ther> | |
144 | <Paragra phs> | |
145 | <Parag raph> | |
146 | <Tex tRuns> | |
147 | <T extRun> | |
148 | <Value>Dat e Project Approved</ Value> | |
149 | <Style> | |
150 | <FontFam ily>Tahoma </FontFami ly> | |
151 | <FontSiz e>11pt</Fo ntSize> | |
152 | <FontWei ght>Bold</ FontWeight > | |
153 | <Color>W hite</Colo r> | |
154 | </Style> | |
155 | </ TextRun> | |
156 | </Te xtRuns> | |
157 | <Sty le /> | |
158 | </Para graph> | |
159 | </Paragr aphs> | |
160 | <rd:Defa ultName>Te xtbox13</r d:DefaultN ame> | |
161 | <Style> | |
162 | <Borde r> | |
163 | <Col or>LightGr ey</Color> | |
164 | <Sty le>Solid</ Style> | |
165 | </Bord er> | |
166 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
167 | <Paddi ngLeft>2pt </PaddingL eft> | |
168 | <Paddi ngRight>2p t</Padding Right> | |
169 | <Paddi ngTop>2pt< /PaddingTo p> | |
170 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
171 | </Style> | |
172 | </Textbox> | |
173 | </ CellConten ts> | |
174 | </Ta blixCell> | |
175 | <Tab lixCell> | |
176 | <C ellContent s> | |
177 | <Textbox N ame="Textb ox7"> | |
178 | <CanGrow >true</Can Grow> | |
179 | <KeepTog ether>true </KeepToge ther> | |
180 | <Paragra phs> | |
181 | <Parag raph> | |
182 | <Tex tRuns> | |
183 | <T extRun> | |
184 | <Value>Loc al Site PI </Value> | |
185 | <Style> | |
186 | <FontFam ily>Tahoma </FontFami ly> | |
187 | <FontSiz e>11pt</Fo ntSize> | |
188 | <FontWei ght>Bold</ FontWeight > | |
189 | <Color>W hite</Colo r> | |
190 | </Style> | |
191 | </ TextRun> | |
192 | </Te xtRuns> | |
193 | <Sty le /> | |
194 | </Para graph> | |
195 | </Paragr aphs> | |
196 | <rd:Defa ultName>Te xtbox7</rd :DefaultNa me> | |
197 | <Style> | |
198 | <Borde r> | |
199 | <Col or>LightGr ey</Color> | |
200 | <Sty le>Solid</ Style> | |
201 | </Bord er> | |
202 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
203 | <Paddi ngLeft>2pt </PaddingL eft> | |
204 | <Paddi ngRight>2p t</Padding Right> | |
205 | <Paddi ngTop>2pt< /PaddingTo p> | |
206 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
207 | </Style> | |
208 | </Textbox> | |
209 | </ CellConten ts> | |
210 | </Ta blixCell> | |
211 | <Tab lixCell> | |
212 | <C ellContent s> | |
213 | <Textbox N ame="Textb ox9"> | |
214 | <CanGrow >true</Can Grow> | |
215 | <KeepTog ether>true </KeepToge ther> | |
216 | <Paragra phs> | |
217 | <Parag raph> | |
218 | <Tex tRuns> | |
219 | <T extRun> | |
220 | <Value>IRB Manager</ Value> | |
221 | <Style> | |
222 | <FontFam ily>Tahoma </FontFami ly> | |
223 | <FontSiz e>11pt</Fo ntSize> | |
224 | <FontWei ght>Bold</ FontWeight > | |
225 | <Color>W hite</Colo r> | |
226 | </Style> | |
227 | </ TextRun> | |
228 | </Te xtRuns> | |
229 | <Sty le /> | |
230 | </Para graph> | |
231 | </Paragr aphs> | |
232 | <rd:Defa ultName>Te xtbox9</rd :DefaultNa me> | |
233 | <Style> | |
234 | <Borde r> | |
235 | <Col or>LightGr ey</Color> | |
236 | <Sty le>Solid</ Style> | |
237 | </Bord er> | |
238 | <Backg roundColor >SteelBlue </Backgrou ndColor> | |
239 | <Paddi ngLeft>2pt </PaddingL eft> | |
240 | <Paddi ngRight>2p t</Padding Right> | |
241 | <Paddi ngTop>2pt< /PaddingTo p> | |
242 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
243 | </Style> | |
244 | </Textbox> | |
245 | </ CellConten ts> | |
246 | </Ta blixCell> | |
247 | </Tabl ixCells> | |
248 | </Tablix Row> | |
249 | <TablixR ow> | |
250 | <Heigh t>0.21in</ Height> | |
251 | <Tabli xCells> | |
252 | <Tab lixCell> | |
253 | <C ellContent s> | |
254 | <Textbox N ame="CIRB_ ID"> | |
255 | <CanGrow >true</Can Grow> | |
256 | <KeepTog ether>true </KeepToge ther> | |
257 | <Paragra phs> | |
258 | <Parag raph> | |
259 | <Tex tRuns> | |
260 | <T extRun> | |
261 | <Value>=Fi elds!CIRB_ ID.Value</ Value> | |
262 | <Style> | |
263 | <FontFam ily>Tahoma </FontFami ly> | |
264 | </Style> | |
265 | </ TextRun> | |
266 | </Te xtRuns> | |
267 | <Sty le /> | |
268 | </Para graph> | |
269 | </Paragr aphs> | |
270 | <rd:Defa ultName>CI RB_ID</rd: DefaultNam e> | |
271 | <Style> | |
272 | <Borde r> | |
273 | <Col or>LightGr ey</Color> | |
274 | <Sty le>Solid</ Style> | |
275 | </Bord er> | |
276 | <Paddi ngLeft>2pt </PaddingL eft> | |
277 | <Paddi ngRight>2p t</Padding Right> | |
278 | <Paddi ngTop>2pt< /PaddingTo p> | |
279 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
280 | </Style> | |
281 | </Textbox> | |
282 | </ CellConten ts> | |
283 | </Ta blixCell> | |
284 | <Tab lixCell> | |
285 | <C ellContent s> | |
286 | <Textbox N ame="Study _Title"> | |
287 | <CanGrow >true</Can Grow> | |
288 | <KeepTog ether>true </KeepToge ther> | |
289 | <Paragra phs> | |
290 | <Parag raph> | |
291 | <Tex tRuns> | |
292 | <T extRun> | |
293 | <Value>=Fi elds!Study _Title.Val ue</Value> | |
294 | <Style> | |
295 | <FontFam ily>Tahoma </FontFami ly> | |
296 | </Style> | |
297 | </ TextRun> | |
298 | </Te xtRuns> | |
299 | <Sty le /> | |
300 | </Para graph> | |
301 | </Paragr aphs> | |
302 | <rd:Defa ultName>St udy_Title< /rd:Defaul tName> | |
303 | <Style> | |
304 | <Borde r> | |
305 | <Col or>LightGr ey</Color> | |
306 | <Sty le>Solid</ Style> | |
307 | </Bord er> | |
308 | <Paddi ngLeft>2pt </PaddingL eft> | |
309 | <Paddi ngRight>2p t</Padding Right> | |
310 | <Paddi ngTop>2pt< /PaddingTo p> | |
311 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
312 | </Style> | |
313 | </Textbox> | |
314 | </ CellConten ts> | |
315 | </Ta blixCell> | |
316 | <Tab lixCell> | |
317 | <C ellContent s> | |
318 | <Textbox N ame="Facil ity_Lookup "> | |
319 | <CanGrow >true</Can Grow> | |
320 | <KeepTog ether>true </KeepToge ther> | |
321 | <Paragra phs> | |
322 | <Parag raph> | |
323 | <Tex tRuns> | |
324 | <T extRun> | |
325 | <Value>=Fi elds!Facil ity_Lookup .Value</Va lue> | |
326 | <Style> | |
327 | <FontFam ily>Tahoma </FontFami ly> | |
328 | </Style> | |
329 | </ TextRun> | |
330 | </Te xtRuns> | |
331 | <Sty le /> | |
332 | </Para graph> | |
333 | </Paragr aphs> | |
334 | <rd:Defa ultName>Fa cility_Loo kup</rd:De faultName> | |
335 | <Style> | |
336 | <Borde r> | |
337 | <Col or>LightGr ey</Color> | |
338 | <Sty le>Solid</ Style> | |
339 | </Bord er> | |
340 | <Paddi ngLeft>2pt </PaddingL eft> | |
341 | <Paddi ngRight>2p t</Padding Right> | |
342 | <Paddi ngTop>2pt< /PaddingTo p> | |
343 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
344 | </Style> | |
345 | </Textbox> | |
346 | </ CellConten ts> | |
347 | </Ta blixCell> | |
348 | <Tab lixCell> | |
349 | <C ellContent s> | |
350 | <Textbox N ame="Textb ox14"> | |
351 | <CanGrow >true</Can Grow> | |
352 | <KeepTog ether>true </KeepToge ther> | |
353 | <Paragra phs> | |
354 | <Parag raph> | |
355 | <Tex tRuns> | |
356 | <T extRun> | |
357 | <Value>=Lo okup(Field s!ID.Value ,Fields!SP ListItem.V alue,Field s!UpdatedA t.Value,"R AMSDB_DS") </Value> | |
358 | <Style> | |
359 | <FontFam ily>Tahoma </FontFami ly> | |
360 | </Style> | |
361 | </ TextRun> | |
362 | </Te xtRuns> | |
363 | <Sty le /> | |
364 | </Para graph> | |
365 | </Paragr aphs> | |
366 | <rd:Defa ultName>Te xtbox14</r d:DefaultN ame> | |
367 | <Style> | |
368 | <Borde r> | |
369 | <Col or>LightGr ey</Color> | |
370 | <Sty le>Solid</ Style> | |
371 | </Bord er> | |
372 | <Paddi ngLeft>2pt </PaddingL eft> | |
373 | <Paddi ngRight>2p t</Padding Right> | |
374 | <Paddi ngTop>2pt< /PaddingTo p> | |
375 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
376 | </Style> | |
377 | </Textbox> | |
378 | </ CellConten ts> | |
379 | </Ta blixCell> | |
380 | <Tab lixCell> | |
381 | <C ellContent s> | |
382 | <Textbox N ame="Parti cipating_S ite_Invest igator"> | |
383 | <CanGrow >true</Can Grow> | |
384 | <KeepTog ether>true </KeepToge ther> | |
385 | <Paragra phs> | |
386 | <Parag raph> | |
387 | <Tex tRuns> | |
388 | <T extRun> | |
389 | <Value>=Fi elds!Parti cipating_S ite_Invest igator.Val ue</Value> | |
390 | <Style> | |
391 | <FontFam ily>Tahoma </FontFami ly> | |
392 | </Style> | |
393 | </ TextRun> | |
394 | </Te xtRuns> | |
395 | <Sty le /> | |
396 | </Para graph> | |
397 | </Paragr aphs> | |
398 | <rd:Defa ultName>Pa rticipatin g_Site_Inv estigator< /rd:Defaul tName> | |
399 | <Style> | |
400 | <Borde r> | |
401 | <Col or>LightGr ey</Color> | |
402 | <Sty le>Solid</ Style> | |
403 | </Bord er> | |
404 | <Paddi ngLeft>2pt </PaddingL eft> | |
405 | <Paddi ngRight>2p t</Padding Right> | |
406 | <Paddi ngTop>2pt< /PaddingTo p> | |
407 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
408 | </Style> | |
409 | </Textbox> | |
410 | </ CellConten ts> | |
411 | </Ta blixCell> | |
412 | <Tab lixCell> | |
413 | <C ellContent s> | |
414 | <Textbox N ame="Assig ned_IRB_Ad ministrato r"> | |
415 | <CanGrow >true</Can Grow> | |
416 | <KeepTog ether>true </KeepToge ther> | |
417 | <Paragra phs> | |
418 | <Parag raph> | |
419 | <Tex tRuns> | |
420 | <T extRun> | |
421 | <Value>=Fi elds!Assig ned_IRB_Ad ministrato r.Value</V alue> | |
422 | <Style> | |
423 | <FontFam ily>Tahoma </FontFami ly> | |
424 | </Style> | |
425 | </ TextRun> | |
426 | </Te xtRuns> | |
427 | <Sty le /> | |
428 | </Para graph> | |
429 | </Paragr aphs> | |
430 | <rd:Defa ultName>As signed_IRB _Administr ator</rd:D efaultName > | |
431 | <Style> | |
432 | <Borde r> | |
433 | <Col or>LightGr ey</Color> | |
434 | <Sty le>Solid</ Style> | |
435 | </Bord er> | |
436 | <Paddi ngLeft>2pt </PaddingL eft> | |
437 | <Paddi ngRight>2p t</Padding Right> | |
438 | <Paddi ngTop>2pt< /PaddingTo p> | |
439 | <Paddi ngBottom>2 pt</Paddin gBottom> | |
440 | </Style> | |
441 | </Textbox> | |
442 | </ CellConten ts> | |
443 | </Ta blixCell> | |
444 | </Tabl ixCells> | |
445 | </Tablix Row> | |
446 | </TablixRo ws> | |
447 | </ TablixBody > | |
448 | <T ablixColum nHierarchy > | |
449 | <TablixMem bers> | |
450 | <TablixM ember /> | |
451 | <TablixM ember /> | |
452 | <TablixM ember /> | |
453 | <TablixM ember /> | |
454 | <TablixM ember /> | |
455 | <TablixM ember /> | |
456 | </TablixMe mbers> | |
457 | </ TablixColu mnHierarch y> | |
458 | <T ablixRowHi erarchy> | |
459 | <TablixMem bers> | |
460 | <TablixM ember> | |
461 | <KeepW ithGroup>A fter</Keep WithGroup> | |
462 | <Repea tOnNewPage >true</Rep eatOnNewPa ge> | |
463 | <KeepT ogether>tr ue</KeepTo gether> | |
464 | </Tablix Member> | |
465 | <TablixM ember> | |
466 | <Group Name="tab le1_Detail s_Group"> | |
467 | <Dat aElementNa me>Detail< /DataEleme ntName> | |
468 | </Grou p> | |
469 | <Tabli xMembers> | |
470 | <Tab lixMember /> | |
471 | </Tabl ixMembers> | |
472 | <DataE lementName >Detail_Co llection</ DataElemen tName> | |
473 | <DataE lementOutp ut>Output< /DataEleme ntOutput> | |
474 | <KeepT ogether>tr ue</KeepTo gether> | |
475 | </Tablix Member> | |
476 | </TablixMe mbers> | |
477 | </ TablixRowH ierarchy> | |
478 | <D ataSetName >RAMSSP_DS </DataSetN ame> | |
479 | <T op>0.38778 in</Top> | |
480 | <H eight>0.43 in</Height > | |
481 | <W idth>13.52 083in</Wid th> | |
482 | <S tyle /> | |
483 | </Ta blix> | |
484 | <Tex tbox Name= "textbox1" > | |
485 | <C anGrow>tru e</CanGrow > | |
486 | <K eepTogethe r>true</Ke epTogether > | |
487 | <P aragraphs> | |
488 | <Paragraph > | |
489 | <TextRun s> | |
490 | <TextR un> | |
491 | <Val ue> Approved LSI Proje ct BySite< /Value> | |
492 | <Sty le> | |
493 | <F ontFamily> Tahoma</Fo ntFamily> | |
494 | <F ontSize>20 pt</FontSi ze> | |
495 | <F ontWeight> Bold</Font Weight> | |
496 | <C olor>Steel Blue</Colo r> | |
497 | </St yle> | |
498 | </Text Run> | |
499 | </TextRu ns> | |
500 | <Style> | |
501 | <TextA lign>Cente r</TextAli gn> | |
502 | </Style> | |
503 | </Paragrap h> | |
504 | <Paragraph > | |
505 | <TextRun s> | |
506 | <TextR un> | |
507 | <Val ue xml:spa ce="preser ve"> </Valu e> | |
508 | <Sty le> | |
509 | <F ontFamily> Tahoma</Fo ntFamily> | |
510 | <F ontSize>11 pt</FontSi ze> | |
511 | <C olor>Steel Blue</Colo r> | |
512 | </St yle> | |
513 | </Text Run> | |
514 | <TextR un> | |
515 | <Lab el>Date</L abel> | |
516 | <Val ue>=DateAd d("d", 0, now())</Va lue> | |
517 | <Sty le> | |
518 | <F ontFamily> Tahoma</Fo ntFamily> | |
519 | <F ontSize>11 pt</FontSi ze> | |
520 | <C olor>Steel Blue</Colo r> | |
521 | </St yle> | |
522 | </Text Run> | |
523 | </TextRu ns> | |
524 | <Style> | |
525 | <TextA lign>Cente r</TextAli gn> | |
526 | </Style> | |
527 | </Paragrap h> | |
528 | </ Paragraphs > | |
529 | <r d:DefaultN ame>textbo x1</rd:Def aultName> | |
530 | <H eight>0.36 in</Height > | |
531 | <W idth>13.38 542in</Wid th> | |
532 | <Z Index>1</Z Index> | |
533 | <S tyle> | |
534 | <PaddingLe ft>2pt</Pa ddingLeft> | |
535 | <PaddingRi ght>2pt</P addingRigh t> | |
536 | <PaddingTo p>2pt</Pad dingTop> | |
537 | <PaddingBo ttom>2pt</ PaddingBot tom> | |
538 | </ Style> | |
539 | </Te xtbox> | |
540 | </Repo rtItems> | |
541 | <Heigh t>0.81778i n</Height> | |
542 | <Style /> | |
543 | </Body> | |
544 | <Width>1 4.08334in< /Width> | |
545 | <Page> | |
546 | <LeftM argin>1in< /LeftMargi n> | |
547 | <Right Margin>1in </RightMar gin> | |
548 | <TopMa rgin>1in</ TopMargin> | |
549 | <Botto mMargin>1i n</BottomM argin> | |
550 | <Style /> | |
551 | </Page> | |
552 | <AutoRef resh>0</Au toRefresh> | |
553 | <DataSou rces> | |
554 | <DataS ource Name ="RAMS_SP" > | |
555 | <Dat aSourceRef erence>RAM S_SP</Data SourceRefe rence> | |
556 | <rd: SecurityTy pe>None</r d:Security Type> | |
557 | <rd: DataSource ID>c0c279b 8-bdc9-43d 4-957b-163 1dffd2926< /rd:DataSo urceID> | |
558 | </Data Source> | |
559 | <DataS ource Name ="RAMS_DB" > | |
560 | <Con nectionPro perties> | |
561 | <D ataProvide r>SQL</Dat aProvider> | |
562 | <ConnectSt ring>Data Source= DN S ;Initial C atalog=RAM S</Connect String> | |
563 | <I ntegratedS ecurity>tr ue</Integr atedSecuri ty> | |
564 | </Co nnectionPr operties> | |
565 | <rd: SecurityTy pe>Integra ted</rd:Se curityType > | |
566 | <rd: DataSource ID>86c36a1 c-d323-4eb c-b0b8-1fa 8c42cb8c3< /rd:DataSo urceID> | |
567 | </Data Source> | |
568 | </DataSo urces> | |
569 | <DataSet s> | |
570 | <DataS et Name="R AMSSP_DS"> | |
571 | <Que ry> | |
572 | <D ataSourceN ame>RAMS_S P</DataSou rceName> | |
573 | <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" > | |
574 | <List Name>Ap plication& lt;/ListNa me> | |
575 | <View Fields> | |
576 | <Fi eldRef Nam e="CIRB_ID " /> | |
577 | <Fi eldRef Nam e="StudyTi tle" /> | |
578 | <Fi eldRef Nam e="Facilit yLookup" / > | |
579 | <Fi eldRef Nam e="Princip alInvestig ator" /> ; | |
580 | <Fi eldRef Nam e="Assigne dIRBAdmini strator" / > | |
581 | <Fi eldRef Nam e="ID" /&g t; | |
582 | <Fi eldRef Nam e="CIRB" / > | |
583 | <Fi eldRef Nam e="Partici patingSite Investigat or" /> | |
584 | <Fi eldRef Nam e="Applica tionStatus " /> | |
585 | </Vie wFields> ; | |
586 | <Quer y> | |
587 | <Wh ere> | |
588 | < And> | |
589 | &l t;And> | |
590 | <Eq> | |
591 | <Fiel dRef Name= "CIRB" /&g t; | |
592 | <Valu e Type="Te xt">Yes </Value > | |
593 | </Eq> ; | |
594 | <Contai ns> | |
595 | <Fiel dRef Name= "StudyTitl e" /> | |
596 | <Valu e Type="Te xt">Loc al Site Ap plication& lt;/Value& gt; | |
597 | </Conta ins> | |
598 | &l t;/And> | |
599 | &l t;Contains > | |
600 | <FieldR ef Name="A pplication Status" /& gt; | |
601 | <Value Type="Text ">Appro ved</Va lue> | |
602 | &l t;/Contain s> | |
603 | < /And> | |
604 | </W here> | |
605 | </Que ry> | |
606 | </RSSha rePointLis t></Com mandText> | |
607 | <r d:Designer State> | |
608 | <QueryDefi nition xml ns="http:/ /schemas.m icrosoft.c om/Reporti ngServices /QueryDefi nition/Rel ational"> | |
609 | <Selecte dColumns> | |
610 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" CIRB_ID" / > | |
611 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" StudyTitle " /> | |
612 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" FacilityLo okup" /> | |
613 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" PrincipalI nvestigato r" /> | |
614 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" AssignedIR BAdministr ator" /> | |
615 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" ID" /> | |
616 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" CIRB" /> | |
617 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Participat ingSiteInv estigator" /> | |
618 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Applicatio nStatus" / > | |
619 | </Select edColumns> | |
620 | <Filters > | |
621 | <Filte r Operator ="="> | |
622 | <Col umnExpress ion Column Owner="App lication" ColumnName ="CIRB" /> | |
623 | <Fil terValue>Y es</Filter Value> | |
624 | </Filt er> | |
625 | <Filte r Operator ="CONTAINS "> | |
626 | <Col umnExpress ion Column Owner="App lication" ColumnName ="StudyTit le" /> | |
627 | <Fil terValue>L ocal Site Applicatio n</FilterV alue> | |
628 | </Filt er> | |
629 | <Filte r Operator ="CONTAINS "> | |
630 | <Col umnExpress ion Column Owner="App lication" ColumnName ="Applicat ionStatus" /> | |
631 | <Fil terValue>A pproved</F ilterValue > | |
632 | </Filt er> | |
633 | </Filter s> | |
634 | </QueryDef inition> | |
635 | </ rd:Designe rState> | |
636 | </Qu ery> | |
637 | <Fie lds> | |
638 | <F ield Name= "CIRB_ID"> | |
639 | <DataField >CIRB_ID</ DataField> | |
640 | <rd:TypeNa me>System. String</rd :TypeName> | |
641 | </ Field> | |
642 | <F ield Name= "Study_Tit le"> | |
643 | <DataField >StudyTitl e</DataFie ld> | |
644 | <rd:TypeNa me>System. String</rd :TypeName> | |
645 | </ Field> | |
646 | <F ield Name= "Facility_ Lookup"> | |
647 | <DataField >FacilityL ookup</Dat aField> | |
648 | <rd:TypeNa me>System. String</rd :TypeName> | |
649 | </ Field> | |
650 | <F ield Name= "Principal _Investiga tor"> | |
651 | <DataField >Principal Investigat or</DataFi eld> | |
652 | <rd:TypeNa me>System. String</rd :TypeName> | |
653 | </ Field> | |
654 | <F ield Name= "Assigned_ IRB_Admini strator"> | |
655 | <DataField >AssignedI RBAdminist rator</Dat aField> | |
656 | <rd:TypeNa me>System. String</rd :TypeName> | |
657 | </ Field> | |
658 | <F ield Name= "ID"> | |
659 | <DataField >ID</DataF ield> | |
660 | <rd:TypeNa me>System. Int32</rd: TypeName> | |
661 | </ Field> | |
662 | <F ield Name= "CIRB"> | |
663 | <DataField >CIRB</Dat aField> | |
664 | <rd:TypeNa me>System. String</rd :TypeName> | |
665 | </ Field> | |
666 | <F ield Name= "Participa ting_Site_ Investigat or"> | |
667 | <DataField >Participa tingSiteIn vestigator </DataFiel d> | |
668 | <rd:TypeNa me>System. String</rd :TypeName> | |
669 | </ Field> | |
670 | <F ield Name= "Applicati on_Status" > | |
671 | <DataField >Applicati onStatus</ DataField> | |
672 | <rd:TypeNa me>System. String</rd :TypeName> | |
673 | </ Field> | |
674 | </Fi elds> | |
675 | <Fil ters> | |
676 | <F ilter> | |
677 | <FilterExp ression>=F ields!Faci lity_Looku p.Value</F ilterExpre ssion> | |
678 | <Operator> Equal</Ope rator> | |
679 | <FilterVal ues> | |
680 | <FilterV alue>=Para meters!Fac ility.Valu e</FilterV alue> | |
681 | </FilterVa lues> | |
682 | </ Filter> | |
683 | </Fi lters> | |
684 | </Data Set> | |
685 | <DataS et Name="R AMSDB_DS"> | |
686 | <Que ry> | |
687 | <D ataSourceN ame>RAMS_D B</DataSou rceName> | |
688 | <C ommandText >SELECT S.Upd atedAt, B. SPListItem | |
689 | FROM (SEL ECT StudiesID , MAX(Stag eCounter) AS stageco unter | |
690 | FROM Study_St atus | |
691 | WHER E ( StudyState sID in ( 4,6,7)) | |
692 | GROU P BY Studi esID) AS A INNER JOI N | |
693 | Study _Status AS S ON A.St udiesID = S.StudiesI D AND A.st agecounter = S.Stage Counter IN NER JOIN | |
694 | Studi es AS B ON A.Studies ID = B.Stu diesID</Co mmandText> | |
695 | </Qu ery> | |
696 | <Fie lds> | |
697 | <F ield Name= "UpdatedAt "> | |
698 | <DataField >UpdatedAt </DataFiel d> | |
699 | <rd:TypeNa me>System. DateTime</ rd:TypeNam e> | |
700 | </ Field> | |
701 | <F ield Name= "SPListIte m"> | |
702 | <DataField >SPListIte m</DataFie ld> | |
703 | <rd:TypeNa me>System. Int32</rd: TypeName> | |
704 | </ Field> | |
705 | </Fi elds> | |
706 | </Data Set> | |
707 | <DataS et Name="F acilityLoo kup_DS"> | |
708 | <Que ry> | |
709 | <D ataSourceN ame>RAMS_S P</DataSou rceName> | |
710 | <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" > | |
711 | <List Name>Ap plication& lt;/ListNa me> | |
712 | <View Fields> | |
713 | <Fi eldRef Nam e="Facilit yLookup" / > | |
714 | </Vie wFields> ; | |
715 | <Quer y> | |
716 | <Wh ere> | |
717 | < IsNotNull& gt; | |
718 | &l t;FieldRef Name="Fac ilityLooku p" /> | |
719 | < /IsNotNull > | |
720 | </W here> | |
721 | </Que ry> | |
722 | </RSSha rePointLis t></Com mandText> | |
723 | <r d:Designer State> | |
724 | <QueryDefi nition xml ns="http:/ /schemas.m icrosoft.c om/Reporti ngServices /QueryDefi nition/Rel ational"> | |
725 | <Selecte dColumns> | |
726 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" FacilityLo okup" /> | |
727 | </Select edColumns> | |
728 | <Filters > | |
729 | <Filte r Operator ="!="> | |
730 | <Col umnExpress ion Column Owner="App lication" ColumnName ="Facility Lookup" /> | |
731 | <Nul l /> | |
732 | </Filt er> | |
733 | </Filter s> | |
734 | </QueryDef inition> | |
735 | </ rd:Designe rState> | |
736 | </Qu ery> | |
737 | <Fie lds> | |
738 | <F ield Name= "Facility_ Lookup"> | |
739 | <DataField >FacilityL ookup</Dat aField> | |
740 | <rd:TypeNa me>System. String</rd :TypeName> | |
741 | </ Field> | |
742 | </Fi elds> | |
743 | </Data Set> | |
744 | </DataSe ts> | |
745 | <ReportP arameters> | |
746 | <Repor tParameter Name="Dum myFacility "> | |
747 | <Dat aType>Stri ng</DataTy pe> | |
748 | <Def aultValue> | |
749 | <D ataSetRefe rence> | |
750 | <DataSetNa me>Facilit yLookup_DS </DataSetN ame> | |
751 | <ValueFiel d>Facility _Lookup</V alueField> | |
752 | </ DataSetRef erence> | |
753 | </De faultValue > | |
754 | <Pro mpt>DummyF acility</P rompt> | |
755 | <Hid den>true</ Hidden> | |
756 | <Val idValues> | |
757 | <D ataSetRefe rence> | |
758 | <DataSetNa me>Facilit yLookup_DS </DataSetN ame> | |
759 | <ValueFiel d>Facility _Lookup</V alueField> | |
760 | <LabelFiel d>Facility _Lookup</L abelField> | |
761 | </ DataSetRef erence> | |
762 | </Va lidValues> | |
763 | <Mul tiValue>tr ue</MultiV alue> | |
764 | </Repo rtParamete r> | |
765 | <Repor tParameter Name="Fac ility"> | |
766 | <Dat aType>Stri ng</DataTy pe> | |
767 | <Def aultValue> | |
768 | <V alues> | |
769 | <Value>=Co de.RemoveD uplicates( Parameters !DummyFaci lity)</Val ue> | |
770 | </ Values> | |
771 | </De faultValue > | |
772 | <Pro mpt>Select facility here: </Pr ompt> | |
773 | <Val idValues> | |
774 | <P arameterVa lues> | |
775 | <Parameter Value> | |
776 | <Value>= Code.Remov eDuplicate s(Paramete rs!DummyFa cility)</V alue> | |
777 | <Label>= Code.Remov eDuplicate s(Paramete rs!DummyFa cility)</L abel> | |
778 | </Paramete rValue> | |
779 | </ ParameterV alues> | |
780 | </Va lidValues> | |
781 | </Repo rtParamete r> | |
782 | </Report Parameters > | |
783 | <Code>Pu blic Share d Function RemoveDup licates(pa rameter As Parameter ) As Strin g() | |
784 | Dim items As Object( ) = parame ter.Value | |
785 | System.Arr ay.Sort(it ems) | |
786 | Dim k As I nteger = 0 | |
787 | For i As I nteger = 0 To items. Length - 1 | |
788 | If i > 0 AndAlso items(i).E quals(item s(i - 1)) Then | |
789 | Continue F or | |
790 | End If | |
791 | items(k) = items(i) | |
792 | k += 1 | |
793 | Next | |
794 | Dim unique As [Strin g]() = New [String]( k - 1) {} | |
795 | System.Arr ay.Copy(it ems, 0, un ique, 0, k ) | |
796 | Return uni que | |
797 | End Functi on</Code> | |
798 | <Languag e>en-US</L anguage> | |
799 | <Consume ContainerW hitespace> true</Cons umeContain erWhitespa ce> | |
800 | <rd:Repo rtUnitType >Inch</rd: ReportUnit Type> | |
801 | <rd:Repo rtID>8c1b1 dbc-72d9-4 492-a8f3-e ba8e8430a7 d</rd:Repo rtID> | |
802 | </Report> |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.