DailiyReportEnergy.rdlx 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220
  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">dailiyRepoartEnergy.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>EnergyList</DataSetName>
  13. <Details>
  14. <TableRows>
  15. <TableRow>
  16. <Height>0.75cm</Height>
  17. <TableCells>
  18. <TableCell>
  19. <ReportItems>
  20. <Textbox Name="TextBox4">
  21. <CanGrow>true</CanGrow>
  22. <Value>=Fields!Name.Value</Value>
  23. <Style>
  24. <BackgroundColor>LightSteelBlue</BackgroundColor>
  25. <PaddingBottom>2pt</PaddingBottom>
  26. <PaddingLeft>2pt</PaddingLeft>
  27. <PaddingRight>2pt</PaddingRight>
  28. <PaddingTop>2pt</PaddingTop>
  29. <TextAlign>Center</TextAlign>
  30. <VerticalAlign>Middle</VerticalAlign>
  31. <BorderStyle>
  32. <Default>Solid</Default>
  33. </BorderStyle>
  34. </Style>
  35. </Textbox>
  36. </ReportItems>
  37. </TableCell>
  38. <TableCell>
  39. <ReportItems>
  40. <Textbox Name="TextBox5">
  41. <CanGrow>true</CanGrow>
  42. <Value>=Fields!Today.Value</Value>
  43. <Style>
  44. <PaddingBottom>2pt</PaddingBottom>
  45. <PaddingLeft>2pt</PaddingLeft>
  46. <PaddingRight>2pt</PaddingRight>
  47. <PaddingTop>2pt</PaddingTop>
  48. <TextAlign>Right</TextAlign>
  49. <VerticalAlign>Middle</VerticalAlign>
  50. <BorderStyle>
  51. <Default>Solid</Default>
  52. </BorderStyle>
  53. </Style>
  54. </Textbox>
  55. </ReportItems>
  56. </TableCell>
  57. <TableCell>
  58. <ReportItems>
  59. <Textbox Name="TextBox6">
  60. <CanGrow>true</CanGrow>
  61. <Value>=Fields!DayBefore.Value</Value>
  62. <Style>
  63. <PaddingBottom>2pt</PaddingBottom>
  64. <PaddingLeft>2pt</PaddingLeft>
  65. <PaddingRight>2pt</PaddingRight>
  66. <PaddingTop>2pt</PaddingTop>
  67. <TextAlign>Right</TextAlign>
  68. <VerticalAlign>Middle</VerticalAlign>
  69. <BorderStyle>
  70. <Default>Solid</Default>
  71. </BorderStyle>
  72. </Style>
  73. </Textbox>
  74. </ReportItems>
  75. </TableCell>
  76. <TableCell>
  77. <ReportItems>
  78. <Textbox Name="TextBox8">
  79. <CanGrow>true</CanGrow>
  80. <Value>=Fields!DailyUsage.Value</Value>
  81. <Style>
  82. <PaddingBottom>2pt</PaddingBottom>
  83. <PaddingLeft>2pt</PaddingLeft>
  84. <PaddingRight>2pt</PaddingRight>
  85. <PaddingTop>2pt</PaddingTop>
  86. <TextAlign>Right</TextAlign>
  87. <VerticalAlign>Middle</VerticalAlign>
  88. <BorderStyle>
  89. <Default>Solid</Default>
  90. </BorderStyle>
  91. </Style>
  92. </Textbox>
  93. </ReportItems>
  94. </TableCell>
  95. <TableCell>
  96. <ReportItems>
  97. <Textbox Name="TextBox10">
  98. <CanGrow>true</CanGrow>
  99. <Value>=Fields!MonthUsage.Value</Value>
  100. <Style>
  101. <PaddingBottom>2pt</PaddingBottom>
  102. <PaddingLeft>2pt</PaddingLeft>
  103. <PaddingRight>2pt</PaddingRight>
  104. <PaddingTop>2pt</PaddingTop>
  105. <TextAlign>Right</TextAlign>
  106. <VerticalAlign>Middle</VerticalAlign>
  107. <BorderStyle>
  108. <Default>Solid</Default>
  109. </BorderStyle>
  110. </Style>
  111. </Textbox>
  112. </ReportItems>
  113. </TableCell>
  114. </TableCells>
  115. </TableRow>
  116. </TableRows>
  117. </Details>
  118. <Height>0.75cm</Height>
  119. <TableColumns>
  120. <TableColumn>
  121. <Width>3.7cm</Width>
  122. </TableColumn>
  123. <TableColumn>
  124. <Width>3.7cm</Width>
  125. </TableColumn>
  126. <TableColumn>
  127. <Width>3.7cm</Width>
  128. </TableColumn>
  129. <TableColumn>
  130. <Width>3.7cm</Width>
  131. </TableColumn>
  132. <TableColumn>
  133. <Width>3.7cm</Width>
  134. </TableColumn>
  135. </TableColumns>
  136. <Width>18.5cm</Width>
  137. </Table>
  138. </ReportItems>
  139. </Body>
  140. <PageHeight>29.7cm</PageHeight>
  141. <PageWidth>21cm</PageWidth>
  142. <Width>18.5cm</Width>
  143. <ReportParameters>
  144. <ReportParameter Name="FacilityTypeId">
  145. <DataType>String</DataType>
  146. <Prompt>FacilityTypeId</Prompt>
  147. <DefaultValue>
  148. <Values>
  149. <Value>=""</Value>
  150. </Values>
  151. </DefaultValue>
  152. </ReportParameter>
  153. <ReportParameter Name="SiteId">
  154. <DataType>String</DataType>
  155. <Prompt>SiteId</Prompt>
  156. <DefaultValue>
  157. <Values>
  158. <Value>117</Value>
  159. </Values>
  160. </DefaultValue>
  161. </ReportParameter>
  162. <ReportParameter Name="ApiUrl">
  163. <DataType>String</DataType>
  164. <Prompt>ApiUrl</Prompt>
  165. <DefaultValue>
  166. <Values>
  167. <Value>http://localhost:9090/api</Value>
  168. </Values>
  169. </DefaultValue>
  170. </ReportParameter>
  171. <ReportParameter Name="Date">
  172. <DataType>String</DataType>
  173. <Prompt>Date</Prompt>
  174. <DefaultValue>
  175. <Values>
  176. <Value>2020-07-17</Value>
  177. </Values>
  178. </DefaultValue>
  179. </ReportParameter>
  180. </ReportParameters>
  181. <DataSources>
  182. <DataSource Name="FMS">
  183. <ConnectionProperties>
  184. <ConnectString>="jsondoc=" &amp; Parameters!ApiUrl.Value &amp; "/DailyReport/GetJson/" &amp; Parameters!SiteId.Value &amp; "/" &amp; Parameters!Date.Value</ConnectString>
  185. <DataProvider>JSON</DataProvider>
  186. </ConnectionProperties>
  187. </DataSource>
  188. </DataSources>
  189. <DataSets>
  190. <DataSet Name="EnergyList">
  191. <Fields>
  192. <Field Name="FacilityCode">
  193. <DataField>FacilityCode</DataField>
  194. </Field>
  195. <Field Name="PropertyId">
  196. <DataField>PropertyId</DataField>
  197. </Field>
  198. <Field Name="Name">
  199. <DataField>Name</DataField>
  200. </Field>
  201. <Field Name="Today">
  202. <DataField>Today</DataField>
  203. </Field>
  204. <Field Name="DayBefore">
  205. <DataField>DayBefore</DataField>
  206. </Field>
  207. <Field Name="DailyUsage">
  208. <DataField>DailyUsage</DataField>
  209. </Field>
  210. <Field Name="MonthUsage">
  211. <DataField>MonthUsage</DataField>
  212. </Field>
  213. </Fields>
  214. <Query>
  215. <CommandText>="$.Datas.Energies[?(@.FacilityTypeId==" + Parameters!FacilityTypeId.Value + ")].List[*]"</CommandText>
  216. <DataSourceName>FMS</DataSourceName>
  217. </Query>
  218. </DataSet>
  219. </DataSets>
  220. </Report>