13. EPMO Open Source Coordination Office Redaction File Detail Report

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.

13.1 Files compared

# 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

13.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 2 664
Changed 1 2
Inserted 0 0
Removed 0 0

13.3 Comparison options

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

13.4 Active regular expressions

No regular expressions were active.

13.5 Comparison detail

  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>