<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"> <dd:Name xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">Cost.rdlx</dd:Name> <Body> <Height>29.7cm</Height> <ReportItems> <List Name="List1"> <DataSetName>dsImages</DataSetName> <DataSetParameters xmlns="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition"> <Parameter Name="idx"> <Value>=Globals!PageNumberInSection</Value> </Parameter> </DataSetParameters> <Height>29.6cm</Height> <ReportItems> <Image Name="Image1"> <DataElementName>Image1</DataElementName> <Height>29.2cm</Height> <Left>0.2cm</Left> <Sizing>Fit</Sizing> <Source>External</Source> <Top>0.2cm</Top> <Value>=Fields!Field1.Value</Value> <Width>20.5698cm</Width> </Image> </ReportItems> <Width>21cm</Width> </List> </ReportItems> </Body> <PageHeight>29.7cm</PageHeight> <PageWidth>21cm</PageWidth> <Width>21cm</Width> <ReportParameters> <ReportParameter Name="SiteId"> <DataType>Integer</DataType> <Prompt>SiteId</Prompt> <DefaultValue> <Values> <Value>102</Value> </Values> </DefaultValue> </ReportParameter> <ReportParameter Name="Year"> <DataType>String</DataType> <Prompt>Year</Prompt> <DefaultValue> <Values> <Value>2020</Value> </Values> </DefaultValue> </ReportParameter> <ReportParameter Name="Month"> <DataType>String</DataType> <Prompt>Month</Prompt> <DefaultValue> <Values> <Value>07</Value> </Values> </DefaultValue> </ReportParameter> <ReportParameter Name="ApiUrl"> <DataType>String</DataType> <Prompt>ApiUrl</Prompt> <DefaultValue> <Values> <Value>http://localhost:9090/api</Value> </Values> </DefaultValue> </ReportParameter> </ReportParameters> <DataSources> <DataSource Name="JsonDataSource"> <ConnectionProperties> <ConnectString>="jsondoc=" & Parameters!ApiUrl.Value & "/app/MonthlyReport/GetJson?siteId=" & Parameters!SiteId.Value & "&addDate=" & Parameters!Year.Value & "-" & Parameters!Month.Value & "&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> <DataProvider>JSON</DataProvider> </ConnectionProperties> </DataSource> </DataSources> <DataSets> <DataSet Name="dsImages"> <Fields> <Field Name="Field1"> <DataField>Field1</DataField> </Field> </Fields> <Query> <CommandText>$.Images[*]</CommandText> <DataSourceName>JsonDataSource</DataSourceName> </Query> </DataSet> <DataSet Name="dsApprover"> <Fields> <Field Name="GroupNm0"> <DataField>Approver[0].GroupNm</DataField> </Field> <Field Name="Date0"> <DataField>Approver[0].Date</DataField> </Field> <Field Name="image0"> <DataField>Approver[0].image</DataField> </Field> <Field Name="GroupNm1"> <DataField>Approver[1].GroupNm</DataField> </Field> <Field Name="Date1"> <DataField>Approver[1].Date</DataField> </Field> <Field Name="image1"> <DataField>Approver[1].image</DataField> </Field> <Field Name="GroupNm2"> <DataField>Approver[2].GroupNm</DataField> </Field> <Field Name="Date2"> <DataField>Approver[2].Date</DataField> </Field> <Field Name="image2"> <DataField>Approver[2].image</DataField> </Field> </Fields> <Query> <CommandText>$</CommandText> <DataSourceName>JsonDataSource</DataSourceName> </Query> </DataSet> </DataSets> </Report>