123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127 |
- <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
- <dd:Name xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">NextMonthPriorityWork.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=NextMonthPriorityWork;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>
|