RentalManagement.rdlx
<Height>29.7cm</Height> <ReportItems> <DataSetName>dsImages</DataSetName> <Value>=Globals!PageNumberInSection</Value> <Height>29.6cm</Height> <ReportItems> <DataElementName>Image1</DataElementName> <Height>29.2cm</Height> <Left>0.2cm</Left> <Sizing>Fit</Sizing> External <Top>0.2cm</Top> <Value>=Fields!Field1.Value</Value> <Width>20.5698cm</Width> </ReportItems> <Width>21cm</Width> </ReportItems>
<PageHeight>29.7cm</PageHeight> <PageWidth>21cm</PageWidth> <Width>21cm</Width> <ReportParameters> <DataType>Integer</DataType> <Prompt>SiteId</Prompt> <DefaultValue> <Values> <Value>102</Value> </Values> </DefaultValue> <DataType>String</DataType> <Prompt>Year</Prompt> <DefaultValue> <Values> <Value>2020</Value> </Values> </DefaultValue> <DataType>String</DataType> <Prompt>Month</Prompt> <DefaultValue> <Values> <Value>07</Value> </Values> </DefaultValue> <DataType>String</DataType> <Prompt>ApiUrl</Prompt> <DefaultValue> <Values> <Value>http://localhost:9090/api</Value> </Values> </DefaultValue> </ReportParameters> <DataSources> <ConnectionProperties> <ConnectString>="jsondoc=" & Parameters!ApiUrl.Value & "/app/MonthlyReport/GetJson?siteId=" & Parameters!SiteId.Value & "&addDate=" & Parameters!Year.Value & "-" & Parameters!Month.Value & "&tabName=RentalManagement;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> </DataSources> <DataSets> <Fields> <DataField>Field1</DataField> </Fields> <Query> <CommandText>$.Images[*]</CommandText> <DataSourceName>JsonDataSource</DataSourceName> </Query> <Fields> <DataField>Approver[0].GroupNm</DataField> <DataField>Approver[0].Date</DataField> <DataField>Approver[0].image</DataField> <DataField>Approver[1].GroupNm</DataField> <DataField>Approver[1].Date</DataField> <DataField>Approver[1].image</DataField> <DataField>Approver[2].GroupNm</DataField> <DataField>Approver[2].Date</DataField> <DataField>Approver[2].image</DataField> </Fields> <Query> <CommandText>$</CommandText> <DataSourceName>JsonDataSource</DataSourceName> </Query> </DataSets>