DailiyReportWork.rdlx 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242
  1. <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
  2. <dd:Name xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">DailiyReportWork.rdlx</dd:Name>
  3. <PageHeader>
  4. <Height>0.4cm</Height>
  5. <PrintOnFirstPage>true</PrintOnFirstPage>
  6. <PrintOnLastPage>true</PrintOnLastPage>
  7. </PageHeader>
  8. <Body>
  9. <Height>0.8cm</Height>
  10. <ReportItems>
  11. <Table Name="Table1">
  12. <DataSetName>WorkList</DataSetName>
  13. <Details>
  14. <TableRows>
  15. <TableRow>
  16. <Height>0.75cm</Height>
  17. <TableCells>
  18. <TableCell>
  19. <dd:AutoMerge xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:AutoMerge>
  20. <dd:AutoMergeMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">Always</dd:AutoMergeMode>
  21. <ReportItems>
  22. <Textbox Name="TextBox2">
  23. <KeepTogether>false</KeepTogether>
  24. <Value>=Parameters!BusinessFieldName.Value</Value>
  25. <Style>
  26. <PaddingBottom>2pt</PaddingBottom>
  27. <PaddingLeft>2pt</PaddingLeft>
  28. <PaddingRight>2pt</PaddingRight>
  29. <PaddingTop>2pt</PaddingTop>
  30. <TextAlign>Center</TextAlign>
  31. <VerticalAlign>Middle</VerticalAlign>
  32. <dd:WrapMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">WordWrap</dd:WrapMode>
  33. <BorderStyle>
  34. <Default>Solid</Default>
  35. </BorderStyle>
  36. </Style>
  37. </Textbox>
  38. </ReportItems>
  39. </TableCell>
  40. <TableCell>
  41. <ReportItems>
  42. <Textbox Name="TextBox1">
  43. <CanGrow>true</CanGrow>
  44. <Value>=Fields!WorkTypeName.Value</Value>
  45. <Style>
  46. <PaddingBottom>2pt</PaddingBottom>
  47. <PaddingLeft>2pt</PaddingLeft>
  48. <PaddingRight>2pt</PaddingRight>
  49. <PaddingTop>2pt</PaddingTop>
  50. <TextAlign>Center</TextAlign>
  51. <VerticalAlign>Middle</VerticalAlign>
  52. <dd:WrapMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">WordWrap</dd:WrapMode>
  53. <BorderStyle>
  54. <Default>Solid</Default>
  55. </BorderStyle>
  56. </Style>
  57. </Textbox>
  58. </ReportItems>
  59. </TableCell>
  60. <TableCell>
  61. <ReportItems>
  62. <Textbox Name="TextBox8">
  63. <CanGrow>true</CanGrow>
  64. <Value>=Fields!WorkProgressName.Value</Value>
  65. <Style>
  66. <PaddingBottom>2pt</PaddingBottom>
  67. <PaddingLeft>2pt</PaddingLeft>
  68. <PaddingRight>2pt</PaddingRight>
  69. <PaddingTop>2pt</PaddingTop>
  70. <TextAlign>Center</TextAlign>
  71. <VerticalAlign>Middle</VerticalAlign>
  72. <dd:WrapMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">WordWrap</dd:WrapMode>
  73. <BorderStyle>
  74. <Default>Solid</Default>
  75. </BorderStyle>
  76. </Style>
  77. </Textbox>
  78. </ReportItems>
  79. </TableCell>
  80. <TableCell>
  81. <ReportItems>
  82. <Textbox Name="TextBox10">
  83. <CanGrow>true</CanGrow>
  84. <Value>=Fields!Title.Value</Value>
  85. <Style>
  86. <PaddingBottom>2pt</PaddingBottom>
  87. <PaddingLeft>2pt</PaddingLeft>
  88. <PaddingRight>2pt</PaddingRight>
  89. <PaddingTop>2pt</PaddingTop>
  90. <TextAlign>Center</TextAlign>
  91. <VerticalAlign>Middle</VerticalAlign>
  92. <dd:WrapMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">WordWrap</dd:WrapMode>
  93. <BorderStyle>
  94. <Default>Solid</Default>
  95. </BorderStyle>
  96. </Style>
  97. </Textbox>
  98. </ReportItems>
  99. </TableCell>
  100. </TableCells>
  101. </TableRow>
  102. </TableRows>
  103. </Details>
  104. <Height>0.75cm</Height>
  105. <TableColumns>
  106. <TableColumn>
  107. <Width>3.894625cm</Width>
  108. </TableColumn>
  109. <TableColumn>
  110. <Width>3.894625cm</Width>
  111. </TableColumn>
  112. <TableColumn>
  113. <Width>3.894625cm</Width>
  114. </TableColumn>
  115. <TableColumn>
  116. <Width>6.816126cm</Width>
  117. </TableColumn>
  118. </TableColumns>
  119. <Width>18.5cm</Width>
  120. </Table>
  121. </ReportItems>
  122. </Body>
  123. <PageHeight>29.7cm</PageHeight>
  124. <PageWidth>21cm</PageWidth>
  125. <Width>18.5cm</Width>
  126. <ReportParameters>
  127. <ReportParameter Name="BusinessFieldId">
  128. <DataType>String</DataType>
  129. <Prompt>BusinessFieldId</Prompt>
  130. <DefaultValue>
  131. <Values>
  132. <Value>1</Value>
  133. </Values>
  134. </DefaultValue>
  135. </ReportParameter>
  136. <ReportParameter Name="SiteId">
  137. <DataType>String</DataType>
  138. <Prompt>SiteId</Prompt>
  139. <DefaultValue>
  140. <Values>
  141. <Value>117</Value>
  142. </Values>
  143. </DefaultValue>
  144. </ReportParameter>
  145. <ReportParameter Name="ApiUrl">
  146. <DataType>String</DataType>
  147. <Prompt>ApiUrl</Prompt>
  148. <DefaultValue>
  149. <Values>
  150. <Value>http://localhost:9090/api</Value>
  151. </Values>
  152. </DefaultValue>
  153. </ReportParameter>
  154. <ReportParameter Name="Date">
  155. <DataType>String</DataType>
  156. <Prompt>Date</Prompt>
  157. <DefaultValue>
  158. <Values>
  159. <Value>2020-07-17</Value>
  160. </Values>
  161. </DefaultValue>
  162. </ReportParameter>
  163. <ReportParameter Name="BusinessFieldName">
  164. <DataType>String</DataType>
  165. <Prompt>BusinessFieldName</Prompt>
  166. <DefaultValue>
  167. <Values>
  168. <Value>default</Value>
  169. </Values>
  170. </DefaultValue>
  171. </ReportParameter>
  172. </ReportParameters>
  173. <DataSources>
  174. <DataSource Name="FMS">
  175. <ConnectionProperties>
  176. <ConnectString>="jsondoc=" &amp; Parameters!ApiUrl.Value &amp; "/DailyReport/GetJson/" &amp; Parameters!SiteId.Value &amp; "/" &amp; Parameters!Date.Value</ConnectString>
  177. <DataProvider>JSON</DataProvider>
  178. </ConnectionProperties>
  179. </DataSource>
  180. </DataSources>
  181. <DataSets>
  182. <DataSet Name="WorkList">
  183. <Fields>
  184. <Field Name="WorkRequestId">
  185. <DataField>WorkRequestId</DataField>
  186. </Field>
  187. <Field Name="BusinessFieldId">
  188. <DataField>BusinessFieldId</DataField>
  189. </Field>
  190. <Field Name="WorkProgressId">
  191. <DataField>WorkProgressId</DataField>
  192. </Field>
  193. <Field Name="WorkProgressName">
  194. <DataField>WorkProgressName</DataField>
  195. </Field>
  196. <Field Name="WorkTypeId">
  197. <DataField>WorkTypeId</DataField>
  198. </Field>
  199. <Field Name="WorkTypeName">
  200. <DataField>WorkTypeName</DataField>
  201. </Field>
  202. <Field Name="RequestDate">
  203. <DataField>RequestDate</DataField>
  204. </Field>
  205. <Field Name="Title">
  206. <DataField>Title</DataField>
  207. </Field>
  208. <Field Name="WorkUsers">
  209. <DataField>WorkUsers</DataField>
  210. </Field>
  211. <Field Name="WorkPartnerId">
  212. <DataField>WorkPartnerId</DataField>
  213. </Field>
  214. <Field Name="WorkPartnerName">
  215. <DataField>WorkPartnerName</DataField>
  216. </Field>
  217. <Field Name="StartDate">
  218. <DataField>StartDate</DataField>
  219. </Field>
  220. <Field Name="EndDate">
  221. <DataField>EndDate</DataField>
  222. </Field>
  223. <Field Name="CheckItems">
  224. <DataField>CheckItems</DataField>
  225. </Field>
  226. <Field Name="CheckDate">
  227. <DataField>CheckItems[*].CheckDate</DataField>
  228. </Field>
  229. <Field Name="TextResult">
  230. <DataField>CheckItems[*].TextResult</DataField>
  231. </Field>
  232. <Field Name="rowNum">
  233. <DataField>rowNum</DataField>
  234. </Field>
  235. </Fields>
  236. <Query>
  237. <CommandText>="$.Datas.Works[?(@.BusinessFieldId==" + Parameters!BusinessFieldId.Value + ")].List[*]"</CommandText>
  238. <DataSourceName>FMS</DataSourceName>
  239. </Query>
  240. </DataSet>
  241. </DataSets>
  242. </Report>