Cost.rdlx 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127
  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">Cost.rdlx</dd:Name>
  3. <Body>
  4. <Height>29.7cm</Height>
  5. <ReportItems>
  6. <List Name="List1">
  7. <DataSetName>dsImages</DataSetName>
  8. <DataSetParameters xmlns="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">
  9. <Parameter Name="idx">
  10. <Value>=Globals!PageNumberInSection</Value>
  11. </Parameter>
  12. </DataSetParameters>
  13. <Height>29.6cm</Height>
  14. <ReportItems>
  15. <Image Name="Image1">
  16. <DataElementName>Image1</DataElementName>
  17. <Height>29.2cm</Height>
  18. <Left>0.2cm</Left>
  19. <Sizing>Fit</Sizing>
  20. <Source>External</Source>
  21. <Top>0.2cm</Top>
  22. <Value>=Fields!Field1.Value</Value>
  23. <Width>20.5698cm</Width>
  24. </Image>
  25. </ReportItems>
  26. <Width>21cm</Width>
  27. </List>
  28. </ReportItems>
  29. </Body>
  30. <PageHeight>29.7cm</PageHeight>
  31. <PageWidth>21cm</PageWidth>
  32. <Width>21cm</Width>
  33. <ReportParameters>
  34. <ReportParameter Name="SiteId">
  35. <DataType>Integer</DataType>
  36. <Prompt>SiteId</Prompt>
  37. <DefaultValue>
  38. <Values>
  39. <Value>102</Value>
  40. </Values>
  41. </DefaultValue>
  42. </ReportParameter>
  43. <ReportParameter Name="Year">
  44. <DataType>String</DataType>
  45. <Prompt>Year</Prompt>
  46. <DefaultValue>
  47. <Values>
  48. <Value>2020</Value>
  49. </Values>
  50. </DefaultValue>
  51. </ReportParameter>
  52. <ReportParameter Name="Month">
  53. <DataType>String</DataType>
  54. <Prompt>Month</Prompt>
  55. <DefaultValue>
  56. <Values>
  57. <Value>07</Value>
  58. </Values>
  59. </DefaultValue>
  60. </ReportParameter>
  61. <ReportParameter Name="ApiUrl">
  62. <DataType>String</DataType>
  63. <Prompt>ApiUrl</Prompt>
  64. <DefaultValue>
  65. <Values>
  66. <Value>http://localhost:9090/api</Value>
  67. </Values>
  68. </DefaultValue>
  69. </ReportParameter>
  70. </ReportParameters>
  71. <DataSources>
  72. <DataSource Name="JsonDataSource">
  73. <ConnectionProperties>
  74. <ConnectString>="jsondoc=" &amp; Parameters!ApiUrl.Value &amp; "/app/MonthlyReport/GetJson?siteId=" &amp; Parameters!SiteId.Value &amp; "&amp;addDate=" &amp; Parameters!Year.Value &amp; "-" &amp; Parameters!Month.Value &amp; "&amp;tabName=Cost;schemadata={ ""$schema"": ""http://json-schema.org/draft-04/schema#"", ""type"": ""object"", ""properties"": { ""Images"": { ""type"": ""array"", ""items"": { ""type"": ""string"" } }, ""Approver"": { ""type"": ""array"", ""items"": { ""type"": ""object"", ""properties"": { ""GroupNm"": { ""type"": ""string"" }, ""Date"": { ""type"": ""string"" }, ""image"": { ""type"": ""string""} } } } }}"</ConnectString>
  75. <DataProvider>JSON</DataProvider>
  76. </ConnectionProperties>
  77. </DataSource>
  78. </DataSources>
  79. <DataSets>
  80. <DataSet Name="dsImages">
  81. <Fields>
  82. <Field Name="Field1">
  83. <DataField>Field1</DataField>
  84. </Field>
  85. </Fields>
  86. <Query>
  87. <CommandText>$.Images[*]</CommandText>
  88. <DataSourceName>JsonDataSource</DataSourceName>
  89. </Query>
  90. </DataSet>
  91. <DataSet Name="dsApprover">
  92. <Fields>
  93. <Field Name="GroupNm0">
  94. <DataField>Approver[0].GroupNm</DataField>
  95. </Field>
  96. <Field Name="Date0">
  97. <DataField>Approver[0].Date</DataField>
  98. </Field>
  99. <Field Name="image0">
  100. <DataField>Approver[0].image</DataField>
  101. </Field>
  102. <Field Name="GroupNm1">
  103. <DataField>Approver[1].GroupNm</DataField>
  104. </Field>
  105. <Field Name="Date1">
  106. <DataField>Approver[1].Date</DataField>
  107. </Field>
  108. <Field Name="image1">
  109. <DataField>Approver[1].image</DataField>
  110. </Field>
  111. <Field Name="GroupNm2">
  112. <DataField>Approver[2].GroupNm</DataField>
  113. </Field>
  114. <Field Name="Date2">
  115. <DataField>Approver[2].Date</DataField>
  116. </Field>
  117. <Field Name="image2">
  118. <DataField>Approver[2].image</DataField>
  119. </Field>
  120. </Fields>
  121. <Query>
  122. <CommandText>$</CommandText>
  123. <DataSourceName>JsonDataSource</DataSourceName>
  124. </Query>
  125. </DataSet>
  126. </DataSets>
  127. </Report>