123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242 |
- <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
- <dd:Name xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">DailiyReportWork.rdlx</dd:Name>
- <PageHeader>
- <Height>0.4cm</Height>
- <PrintOnFirstPage>true</PrintOnFirstPage>
- <PrintOnLastPage>true</PrintOnLastPage>
- </PageHeader>
- <Body>
- <Height>0.8cm</Height>
- <ReportItems>
- <Table Name="Table1">
- <DataSetName>WorkList</DataSetName>
- <Details>
- <TableRows>
- <TableRow>
- <Height>0.75cm</Height>
- <TableCells>
- <TableCell>
- <dd:AutoMerge xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:AutoMerge>
- <dd:AutoMergeMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">Always</dd:AutoMergeMode>
- <ReportItems>
- <Textbox Name="TextBox2">
- <KeepTogether>false</KeepTogether>
- <Value>=Parameters!BusinessFieldName.Value</Value>
- <Style>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Center</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <dd:WrapMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">WordWrap</dd:WrapMode>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- <TableCell>
- <ReportItems>
- <Textbox Name="TextBox1">
- <CanGrow>true</CanGrow>
- <Value>=Fields!WorkTypeName.Value</Value>
- <Style>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Center</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <dd:WrapMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">WordWrap</dd:WrapMode>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- <TableCell>
- <ReportItems>
- <Textbox Name="TextBox8">
- <CanGrow>true</CanGrow>
- <Value>=Fields!WorkProgressName.Value</Value>
- <Style>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Center</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <dd:WrapMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">WordWrap</dd:WrapMode>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- <TableCell>
- <ReportItems>
- <Textbox Name="TextBox10">
- <CanGrow>true</CanGrow>
- <Value>=Fields!Title.Value</Value>
- <Style>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Center</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <dd:WrapMode xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">WordWrap</dd:WrapMode>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- </TableCells>
- </TableRow>
- </TableRows>
- </Details>
- <Height>0.75cm</Height>
- <TableColumns>
- <TableColumn>
- <Width>3.894625cm</Width>
- </TableColumn>
- <TableColumn>
- <Width>3.894625cm</Width>
- </TableColumn>
- <TableColumn>
- <Width>3.894625cm</Width>
- </TableColumn>
- <TableColumn>
- <Width>6.816126cm</Width>
- </TableColumn>
- </TableColumns>
- <Width>18.5cm</Width>
- </Table>
- </ReportItems>
- </Body>
- <PageHeight>29.7cm</PageHeight>
- <PageWidth>21cm</PageWidth>
- <Width>18.5cm</Width>
- <ReportParameters>
- <ReportParameter Name="BusinessFieldId">
- <DataType>String</DataType>
- <Prompt>BusinessFieldId</Prompt>
- <DefaultValue>
- <Values>
- <Value>1</Value>
- </Values>
- </DefaultValue>
- </ReportParameter>
- <ReportParameter Name="SiteId">
- <DataType>String</DataType>
- <Prompt>SiteId</Prompt>
- <DefaultValue>
- <Values>
- <Value>117</Value>
- </Values>
- </DefaultValue>
- </ReportParameter>
- <ReportParameter Name="ApiUrl">
- <DataType>String</DataType>
- <Prompt>ApiUrl</Prompt>
- <DefaultValue>
- <Values>
- <Value>http://localhost:9090/api</Value>
- </Values>
- </DefaultValue>
- </ReportParameter>
- <ReportParameter Name="Date">
- <DataType>String</DataType>
- <Prompt>Date</Prompt>
- <DefaultValue>
- <Values>
- <Value>2020-07-17</Value>
- </Values>
- </DefaultValue>
- </ReportParameter>
- <ReportParameter Name="BusinessFieldName">
- <DataType>String</DataType>
- <Prompt>BusinessFieldName</Prompt>
- <DefaultValue>
- <Values>
- <Value>default</Value>
- </Values>
- </DefaultValue>
- </ReportParameter>
- </ReportParameters>
- <DataSources>
- <DataSource Name="FMS">
- <ConnectionProperties>
- <ConnectString>="jsondoc=" & Parameters!ApiUrl.Value & "/DailyReport/GetJson/" & Parameters!SiteId.Value & "/" & Parameters!Date.Value</ConnectString>
- <DataProvider>JSON</DataProvider>
- </ConnectionProperties>
- </DataSource>
- </DataSources>
- <DataSets>
- <DataSet Name="WorkList">
- <Fields>
- <Field Name="WorkRequestId">
- <DataField>WorkRequestId</DataField>
- </Field>
- <Field Name="BusinessFieldId">
- <DataField>BusinessFieldId</DataField>
- </Field>
- <Field Name="WorkProgressId">
- <DataField>WorkProgressId</DataField>
- </Field>
- <Field Name="WorkProgressName">
- <DataField>WorkProgressName</DataField>
- </Field>
- <Field Name="WorkTypeId">
- <DataField>WorkTypeId</DataField>
- </Field>
- <Field Name="WorkTypeName">
- <DataField>WorkTypeName</DataField>
- </Field>
- <Field Name="RequestDate">
- <DataField>RequestDate</DataField>
- </Field>
- <Field Name="Title">
- <DataField>Title</DataField>
- </Field>
- <Field Name="WorkUsers">
- <DataField>WorkUsers</DataField>
- </Field>
- <Field Name="WorkPartnerId">
- <DataField>WorkPartnerId</DataField>
- </Field>
- <Field Name="WorkPartnerName">
- <DataField>WorkPartnerName</DataField>
- </Field>
- <Field Name="StartDate">
- <DataField>StartDate</DataField>
- </Field>
- <Field Name="EndDate">
- <DataField>EndDate</DataField>
- </Field>
- <Field Name="CheckItems">
- <DataField>CheckItems</DataField>
- </Field>
- <Field Name="CheckDate">
- <DataField>CheckItems[*].CheckDate</DataField>
- </Field>
- <Field Name="TextResult">
- <DataField>CheckItems[*].TextResult</DataField>
- </Field>
- <Field Name="rowNum">
- <DataField>rowNum</DataField>
- </Field>
- </Fields>
- <Query>
- <CommandText>="$.Datas.Works[?(@.BusinessFieldId==" + Parameters!BusinessFieldId.Value + ")].List[*]"</CommandText>
- <DataSourceName>FMS</DataSourceName>
- </Query>
- </DataSet>
- </DataSets>
- </Report>
|