Produced by Araxis Merge on 10/18/2017 8:22:14 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 | EventTypeReport.rdl | Wed Oct 18 12:48:38 2017 UTC |
2 | RAMS.zip\RAMS\UI\R2.1\Reports | EventTypeReport.rdl | Wed Oct 18 13:02:10 2017 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 1580 |
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.21875in </Width> | |
10 | </Tablix Column> | |
11 | <TablixC olumn> | |
12 | <Width >2.01042in </Width> | |
13 | </Tablix Column> | |
14 | <TablixC olumn> | |
15 | <Width >2.17708in </Width> | |
16 | </Tablix Column> | |
17 | <TablixC olumn> | |
18 | <Width >2.375in</ Width> | |
19 | </Tablix Column> | |
20 | <TablixC olumn> | |
21 | <Width >2.20833in </Width> | |
22 | </Tablix Column> | |
23 | <TablixC olumn> | |
24 | <Width >2.28125in </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>Stu dy ID</Val ue> | |
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>Stu dy Title</ 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 ox7"> | |
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>Pri ncipal Inv estigator< /Value> | |
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 xtbox7</rd :DefaultNa me> | |
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 ox4"> | |
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>App lication T ype</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 xtbox4</rd :DefaultNa me> | |
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 ox5"> | |
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>Fac ility Look up</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 xtbox5</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 ox6"> | |
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>Com mittees Lo okup</Valu e> | |
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 xtbox6</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="Study _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!Study _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>St udy_ID</rd :DefaultNa me> | |
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="Princ ipal_Inves tigator"> | |
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!Princ ipal_Inves tigator.Va lue</Value > | |
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>Pr incipal_In vestigator </rd:Defau ltName> | |
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="Appli cation_Typ e"> | |
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>=Fi elds!Appli cation_Typ e.Value</V alue> | |
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>Ap plication_ Type</rd:D efaultName > | |
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="Facil ity_Lookup "> | |
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!Facil ity_Lookup .Value</Va lue> | |
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>Fa cility_Loo kup</rd:De faultName> | |
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="Commi ttees_Look up"> | |
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!Commi ttees_Look up.Value</ Value> | |
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>Co mmittees_L ookup</rd: DefaultNam e> | |
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 >DataSet1< /DataSetNa me> | |
479 | <T op>0.36in< /Top> | |
480 | <H eight>0.43 in</Height > | |
481 | <W idth>13.27 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>Study: Event Type Report</V alue> | |
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 | </Paragrap h> | |
502 | </ Paragraphs > | |
503 | <r d:DefaultN ame>textbo x1</rd:Def aultName> | |
504 | <H eight>0.36 in</Height > | |
505 | <W idth>5in</ Width> | |
506 | <Z Index>1</Z Index> | |
507 | <S tyle> | |
508 | <PaddingLe ft>2pt</Pa ddingLeft> | |
509 | <PaddingRi ght>2pt</P addingRigh t> | |
510 | <PaddingTo p>2pt</Pad dingTop> | |
511 | <PaddingBo ttom>2pt</ PaddingBot tom> | |
512 | </ Style> | |
513 | </Te xtbox> | |
514 | </Repo rtItems> | |
515 | <Heigh t>0.79in</ Height> | |
516 | <Style /> | |
517 | </Body> | |
518 | <Width>1 3.27083in< /Width> | |
519 | <Page> | |
520 | <LeftM argin>1in< /LeftMargi n> | |
521 | <Right Margin>1in </RightMar gin> | |
522 | <TopMa rgin>1in</ TopMargin> | |
523 | <Botto mMargin>1i n</BottomM argin> | |
524 | <Style /> | |
525 | </Page> | |
526 | <AutoRef resh>0</Au toRefresh> | |
527 | <DataSou rces> | |
528 | <DataS ource Name ="RAMS_SP" > | |
529 | <Con nectionPro perties> | |
530 | <D ataProvide r>SHAREPOI NTLIST</Da taProvider > | |
531 | <ConnectSt ring>http: //vaww.ide v.ram.msp. DNS /sites/IRB Applicatio ns/</Conne ctString> | |
532 | <I ntegratedS ecurity>tr ue</Integr atedSecuri ty> | |
533 | </Co nnectionPr operties> | |
534 | <rd: SecurityTy pe>Integra ted</rd:Se curityType > | |
535 | <rd: DataSource ID>2a38a82 1-6daf-44b 3-91f5-154 8f88da17f< /rd:DataSo urceID> | |
536 | </Data Source> | |
537 | </DataSo urces> | |
538 | <DataSet s> | |
539 | <DataS et Name="D ataSet1"> | |
540 | <Que ry> | |
541 | <D ataSourceN ame>RAMS_S P</DataSou rceName> | |
542 | <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" > | |
543 | <List Name>Ap plication& lt;/ListNa me> | |
544 | <View Fields> | |
545 | <Fi eldRef Nam e="Study_I D" /> | |
546 | <Fi eldRef Nam e="StudyTi tle" /> | |
547 | <Fi eldRef Nam e="Princip alInvestig ator" /> ; | |
548 | <Fi eldRef Nam e="Applica tionType" /> | |
549 | <Fi eldRef Nam e="Facilit yLookup" / > | |
550 | <Fi eldRef Nam e="Committ eesLookup" /> | |
551 | </Vie wFields> ; | |
552 | <Quer y> | |
553 | <Wh ere> | |
554 | < IsNotNull& gt; | |
555 | &l t;FieldRef Name="App licationTy pe" /> | |
556 | < /IsNotNull > | |
557 | </W here> | |
558 | </Que ry> | |
559 | </RSSha rePointLis t></Com mandText> | |
560 | <r d:Designer State> | |
561 | <QueryDefi nition xml ns="http:/ /schemas.m icrosoft.c om/Reporti ngServices /QueryDefi nition/Rel ational"> | |
562 | <Selecte dColumns> | |
563 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Study_ID" /> | |
564 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" StudyTitle " /> | |
565 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" PrincipalI nvestigato r" /> | |
566 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Applicatio nType" /> | |
567 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" FacilityLo okup" /> | |
568 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Committees Lookup" /> | |
569 | </Select edColumns> | |
570 | <Filters > | |
571 | <Filte r Operator ="!="> | |
572 | <Col umnExpress ion Column Owner="App lication" ColumnName ="Applicat ionType" / > | |
573 | <Nul l /> | |
574 | </Filt er> | |
575 | </Filter s> | |
576 | </QueryDef inition> | |
577 | </ rd:Designe rState> | |
578 | </Qu ery> | |
579 | <Fie lds> | |
580 | <F ield Name= "Study_ID" > | |
581 | <DataField >Study_ID< /DataField > | |
582 | <rd:TypeNa me>System. String</rd :TypeName> | |
583 | </ Field> | |
584 | <F ield Name= "Study_Tit le"> | |
585 | <DataField >StudyTitl e</DataFie ld> | |
586 | <rd:TypeNa me>System. String</rd :TypeName> | |
587 | </ Field> | |
588 | <F ield Name= "Applicati on_Type"> | |
589 | <DataField >Applicati onType</Da taField> | |
590 | <rd:TypeNa me>System. String</rd :TypeName> | |
591 | </ Field> | |
592 | <F ield Name= "Principal _Investiga tor"> | |
593 | <DataField >Principal Investigat or</DataFi eld> | |
594 | <rd:TypeNa me>System. String</rd :TypeName> | |
595 | </ Field> | |
596 | <F ield Name= "Facility_ Lookup"> | |
597 | <DataField >FacilityL ookup</Dat aField> | |
598 | <rd:TypeNa me>System. String</rd :TypeName> | |
599 | </ Field> | |
600 | <F ield Name= "Committee s_Lookup"> | |
601 | <DataField >Committee sLookup</D ataField> | |
602 | <rd:TypeNa me>System. String</rd :TypeName> | |
603 | </ Field> | |
604 | </Fi elds> | |
605 | <Fil ters> | |
606 | <F ilter> | |
607 | <FilterExp ression>=F ields!Appl ication_Ty pe.Value</ FilterExpr ession> | |
608 | <Operator> Equal</Ope rator> | |
609 | <FilterVal ues> | |
610 | <FilterV alue>=Para meters!App licationTy pePara.Val ue</Filter Value> | |
611 | </FilterVa lues> | |
612 | </ Filter> | |
613 | <F ilter> | |
614 | <FilterExp ression>=F ields!Faci lity_Looku p.Value</F ilterExpre ssion> | |
615 | <Operator> Equal</Ope rator> | |
616 | <FilterVal ues> | |
617 | <FilterV alue>=Para meters!Fac ilityPara. Value</Fil terValue> | |
618 | </FilterVa lues> | |
619 | </ Filter> | |
620 | </Fi lters> | |
621 | </Data Set> | |
622 | <DataS et Name="D ataSet2"> | |
623 | <Que ry> | |
624 | <D ataSourceN ame>RAMS_S P</DataSou rceName> | |
625 | <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" > | |
626 | <List Name>Ap plication& lt;/ListNa me> | |
627 | <View Fields> | |
628 | <Fi eldRef Nam e="Applica tionType" /> | |
629 | </Vie wFields> ; | |
630 | <Quer y> | |
631 | <Wh ere> | |
632 | < IsNotNull& gt; | |
633 | &l t;FieldRef Name="App licationTy pe" /> | |
634 | < /IsNotNull > | |
635 | </W here> | |
636 | </Que ry> | |
637 | </RSSha rePointLis t></Com mandText> | |
638 | <r d:Designer State> | |
639 | <QueryDefi nition xml ns="http:/ /schemas.m icrosoft.c om/Reporti ngServices /QueryDefi nition/Rel ational"> | |
640 | <Selecte dColumns> | |
641 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" Applicatio nType" /> | |
642 | </Select edColumns> | |
643 | <Filters > | |
644 | <Filte r Operator ="!="> | |
645 | <Col umnExpress ion Column Owner="App lication" ColumnName ="Applicat ionType" / > | |
646 | <Nul l /> | |
647 | </Filt er> | |
648 | </Filter s> | |
649 | </QueryDef inition> | |
650 | </ rd:Designe rState> | |
651 | <r d:UseGener icDesigner >true</rd: UseGeneric Designer> | |
652 | </Qu ery> | |
653 | <Fie lds> | |
654 | <F ield Name= "Applicati on_Type"> | |
655 | <DataField >Applicati onType</Da taField> | |
656 | <rd:TypeNa me>System. String</rd :TypeName> | |
657 | </ Field> | |
658 | </Fi elds> | |
659 | </Data Set> | |
660 | <DataS et Name="D ataSet3"> | |
661 | <Que ry> | |
662 | <D ataSourceN ame>RAMS_S P</DataSou rceName> | |
663 | <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" > | |
664 | <List Name>Ap plication& lt;/ListNa me> | |
665 | <View Fields> | |
666 | <Fi eldRef Nam e="Facilit yLookup" / > | |
667 | </Vie wFields> ; | |
668 | <Quer y> | |
669 | <Wh ere> | |
670 | < IsNotNull& gt; | |
671 | &l t;FieldRef Name="Fac ilityLooku p" /> | |
672 | < /IsNotNull > | |
673 | </W here> | |
674 | </Que ry> | |
675 | </RSSha rePointLis t></Com mandText> | |
676 | <r d:Designer State> | |
677 | <QueryDefi nition xml ns="http:/ /schemas.m icrosoft.c om/Reporti ngServices /QueryDefi nition/Rel ational"> | |
678 | <Selecte dColumns> | |
679 | <Colum nExpressio n ColumnOw ner="Appli cation" Co lumnName=" FacilityLo okup" /> | |
680 | </Select edColumns> | |
681 | <Filters > | |
682 | <Filte r Operator ="!="> | |
683 | <Col umnExpress ion Column Owner="App lication" ColumnName ="Facility Lookup" /> | |
684 | <Nul l /> | |
685 | </Filt er> | |
686 | </Filter s> | |
687 | </QueryDef inition> | |
688 | </ rd:Designe rState> | |
689 | </Qu ery> | |
690 | <Fie lds> | |
691 | <F ield Name= "Facility_ Lookup"> | |
692 | <DataField >FacilityL ookup</Dat aField> | |
693 | <rd:TypeNa me>System. String</rd :TypeName> | |
694 | </ Field> | |
695 | </Fi elds> | |
696 | </Data Set> | |
697 | </DataSe ts> | |
698 | <ReportP arameters> | |
699 | <Repor tParameter Name="Dum yPara"> | |
700 | <Dat aType>Stri ng</DataTy pe> | |
701 | <Def aultValue> | |
702 | <D ataSetRefe rence> | |
703 | <DataSetNa me>DataSet 2</DataSet Name> | |
704 | <ValueFiel d>Applicat ion_Type</ ValueField > | |
705 | </ DataSetRef erence> | |
706 | </De faultValue > | |
707 | <Pro mpt>DumyPa ra</Prompt > | |
708 | <Hid den>true</ Hidden> | |
709 | <Val idValues> | |
710 | <D ataSetRefe rence> | |
711 | <DataSetNa me>DataSet 2</DataSet Name> | |
712 | <ValueFiel d>Applicat ion_Type</ ValueField > | |
713 | <LabelFiel d>Applicat ion_Type</ LabelField > | |
714 | </ DataSetRef erence> | |
715 | </Va lidValues> | |
716 | <Mul tiValue>tr ue</MultiV alue> | |
717 | </Repo rtParamete r> | |
718 | <Repor tParameter Name="App licationTy pePara"> | |
719 | <Dat aType>Stri ng</DataTy pe> | |
720 | <Def aultValue> | |
721 | <V alues> | |
722 | <Value>=Co de.RemoveD uplicates( Parameters !DumyPara) </Value> | |
723 | </ Values> | |
724 | </De faultValue > | |
725 | <Pro mpt>Applic ation Type </Prompt> | |
726 | <Val idValues> | |
727 | <P arameterVa lues> | |
728 | <Parameter Value> | |
729 | <Value>= Code.Remov eDuplicate s(Paramete rs!DumyPar a)</Value> | |
730 | <Label>= Code.Remov eDuplicate s(Paramete rs!DumyPar a)</Label> | |
731 | </Paramete rValue> | |
732 | </ ParameterV alues> | |
733 | </Va lidValues> | |
734 | </Repo rtParamete r> | |
735 | <Repor tParameter Name="Dum yFacility" > | |
736 | <Dat aType>Stri ng</DataTy pe> | |
737 | <Def aultValue> | |
738 | <D ataSetRefe rence> | |
739 | <DataSetNa me>DataSet 3</DataSet Name> | |
740 | <ValueFiel d>Facility _Lookup</V alueField> | |
741 | </ DataSetRef erence> | |
742 | </De faultValue > | |
743 | <Pro mpt>DumyFa cility</Pr ompt> | |
744 | <Hid den>true</ Hidden> | |
745 | <Val idValues> | |
746 | <D ataSetRefe rence> | |
747 | <DataSetNa me>DataSet 3</DataSet Name> | |
748 | <ValueFiel d>Facility _Lookup</V alueField> | |
749 | <LabelFiel d>Facility _Lookup</L abelField> | |
750 | </ DataSetRef erence> | |
751 | </Va lidValues> | |
752 | <Mul tiValue>tr ue</MultiV alue> | |
753 | </Repo rtParamete r> | |
754 | <Repor tParameter Name="Fac ilityPara" > | |
755 | <Dat aType>Stri ng</DataTy pe> | |
756 | <Def aultValue> | |
757 | <V alues> | |
758 | <Value>=Co de.RemoveD uplicates( Parameters !DumyFacil ity)</Valu e> | |
759 | </ Values> | |
760 | </De faultValue > | |
761 | <Pro mpt>Facili ty Name</P rompt> | |
762 | <Val idValues> | |
763 | <P arameterVa lues> | |
764 | <Parameter Value> | |
765 | <Value>= Code.Remov eDuplicate s(Paramete rs!DumyFac ility)</Va lue> | |
766 | <Label>= Code.Remov eDuplicate s(Paramete rs!DumyFac ility)</La bel> | |
767 | </Paramete rValue> | |
768 | </ ParameterV alues> | |
769 | </Va lidValues> | |
770 | </Repo rtParamete r> | |
771 | </Report Parameters > | |
772 | <Code>Pu blic Share d Function RemoveDup licates(pa rameter As Parameter ) As Strin g() | |
773 | Dim items As Object( ) = parame ter.Value | |
774 | System.Arr ay.Sort(it ems) | |
775 | Dim k As I nteger = 0 | |
776 | For i As I nteger = 0 To items. Length - 1 | |
777 | If i > 0 AndAlso items(i).E quals(item s(i - 1)) Then | |
778 | Continue F or | |
779 | End If | |
780 | items(k) = items(i) | |
781 | k += 1 | |
782 | Next | |
783 | Dim unique As [Strin g]() = New [String]( k - 1) {} | |
784 | System.Arr ay.Copy(it ems, 0, un ique, 0, k ) | |
785 | Return uni que | |
786 | End Functi on</Code> | |
787 | <Languag e>en-US</L anguage> | |
788 | <Consume ContainerW hitespace> true</Cons umeContain erWhitespa ce> | |
789 | <rd:Repo rtUnitType >Inch</rd: ReportUnit Type> | |
790 | <rd:Repo rtID>56a92 91f-952e-4 7f9-a65a-b 0c4c4c5231 e</rd:Repo rtID> | |
791 | </Report> |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.