123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220 |
- <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
- <dd:Name xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">dailiyRepoartEnergy.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>EnergyList</DataSetName>
- <Details>
- <TableRows>
- <TableRow>
- <Height>0.75cm</Height>
- <TableCells>
- <TableCell>
- <ReportItems>
- <Textbox Name="TextBox4">
- <CanGrow>true</CanGrow>
- <Value>=Fields!Name.Value</Value>
- <Style>
- <BackgroundColor>LightSteelBlue</BackgroundColor>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Center</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- <TableCell>
- <ReportItems>
- <Textbox Name="TextBox5">
- <CanGrow>true</CanGrow>
- <Value>=Fields!Today.Value</Value>
- <Style>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Right</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- <TableCell>
- <ReportItems>
- <Textbox Name="TextBox6">
- <CanGrow>true</CanGrow>
- <Value>=Fields!DayBefore.Value</Value>
- <Style>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Right</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- <TableCell>
- <ReportItems>
- <Textbox Name="TextBox8">
- <CanGrow>true</CanGrow>
- <Value>=Fields!DailyUsage.Value</Value>
- <Style>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Right</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- <TableCell>
- <ReportItems>
- <Textbox Name="TextBox10">
- <CanGrow>true</CanGrow>
- <Value>=Fields!MonthUsage.Value</Value>
- <Style>
- <PaddingBottom>2pt</PaddingBottom>
- <PaddingLeft>2pt</PaddingLeft>
- <PaddingRight>2pt</PaddingRight>
- <PaddingTop>2pt</PaddingTop>
- <TextAlign>Right</TextAlign>
- <VerticalAlign>Middle</VerticalAlign>
- <BorderStyle>
- <Default>Solid</Default>
- </BorderStyle>
- </Style>
- </Textbox>
- </ReportItems>
- </TableCell>
- </TableCells>
- </TableRow>
- </TableRows>
- </Details>
- <Height>0.75cm</Height>
- <TableColumns>
- <TableColumn>
- <Width>3.7cm</Width>
- </TableColumn>
- <TableColumn>
- <Width>3.7cm</Width>
- </TableColumn>
- <TableColumn>
- <Width>3.7cm</Width>
- </TableColumn>
- <TableColumn>
- <Width>3.7cm</Width>
- </TableColumn>
- <TableColumn>
- <Width>3.7cm</Width>
- </TableColumn>
- </TableColumns>
- <Width>18.5cm</Width>
- </Table>
- </ReportItems>
- </Body>
- <PageHeight>29.7cm</PageHeight>
- <PageWidth>21cm</PageWidth>
- <Width>18.5cm</Width>
- <ReportParameters>
- <ReportParameter Name="FacilityTypeId">
- <DataType>String</DataType>
- <Prompt>FacilityTypeId</Prompt>
- <DefaultValue>
- <Values>
- <Value>=""</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>
- </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="EnergyList">
- <Fields>
- <Field Name="FacilityCode">
- <DataField>FacilityCode</DataField>
- </Field>
- <Field Name="PropertyId">
- <DataField>PropertyId</DataField>
- </Field>
- <Field Name="Name">
- <DataField>Name</DataField>
- </Field>
- <Field Name="Today">
- <DataField>Today</DataField>
- </Field>
- <Field Name="DayBefore">
- <DataField>DayBefore</DataField>
- </Field>
- <Field Name="DailyUsage">
- <DataField>DailyUsage</DataField>
- </Field>
- <Field Name="MonthUsage">
- <DataField>MonthUsage</DataField>
- </Field>
- </Fields>
- <Query>
- <CommandText>="$.Datas.Energies[?(@.FacilityTypeId==" + Parameters!FacilityTypeId.Value + ")].List[*]"</CommandText>
- <DataSourceName>FMS</DataSourceName>
- </Query>
- </DataSet>
- </DataSets>
- </Report>
|