<?xml version="1.0" encoding="utf-8"?> | |
<Report MustUnderstand="df" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:df="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily"> | |
<rd:ReportUnitType>Inch</rd:ReportUnitType> | |
<rd:ReportID>ff2be9e0-f921-42f0-a3f0-8862da7aaf1f</rd:ReportID> | |
<df:DefaultFontFamily>Segoe UI</df:DefaultFontFamily> | |
<AutoRefresh>0</AutoRefresh> | |
<DataSources> | |
<DataSource Name="DataSource1"> | |
<rd:SecurityType>DataBase</rd:SecurityType> | |
<ConnectionProperties> | |
<DataProvider>SQLAZURE</DataProvider> | |
<ConnectString>Server=mine.database.windows.net,1433;Initial Catalog=db;</ConnectString> | |
<rd:DataProviderID>SQLAZURE.1</rd:DataProviderID> | |
</ConnectionProperties> | |
<rd:DataSourceID>ead30a77-3e6d-40ea-bb89-f21d81fe6add</rd:DataSourceID> | |
</DataSource> | |
</DataSources> | |
<DataSets> | |
<DataSet Name="DataSet1"> | |
<Query> | |
<DataSourceName>DataSource1</DataSourceName> | |
<CommandText>SELECT SYSTEM_USER as [User]</CommandText> | |
</Query> | |
<Fields> | |
<Field Name="User"> | |
<rd:TypeName>System.String</rd:TypeName> | |
<DataField>User</DataField> | |
</Field> | |
</Fields> | |
</DataSet> | |
</DataSets> | |
<ReportSections> | |
<ReportSection> | |
<Body> | |
<ReportItems> | |
<Textbox Name="ReportTitle"> | |
<rd:WatermarkTextbox>Title</rd:WatermarkTextbox> | |
<rd:DefaultName>ReportTitle</rd:DefaultName> | |
<CanGrow>true</CanGrow> | |
<KeepTogether>true</KeepTogether> | |
<Paragraphs> | |
<Paragraph> | |
<TextRuns> | |
<TextRun> | |
<Value>Ran As</Value> | |
<Style> | |
<FontFamily>Segoe UI Light</FontFamily> | |
<FontSize>28pt</FontSize> | |
</Style> | |
</TextRun> | |
</TextRuns> | |
<Style /> | |
</Paragraph> | |
</Paragraphs> | |
<Height>0.5in</Height> | |
<Width>5.5in</Width> | |
<Style> | |
<Border> | |
<Style>None</Style> | |
</Border> | |
<PaddingLeft>2pt</PaddingLeft> | |
<PaddingRight>2pt</PaddingRight> | |
<PaddingTop>2pt</PaddingTop> | |
<PaddingBottom>2pt</PaddingBottom> | |
</Style> | |
</Textbox> | |
<Textbox Name="User"> | |
<rd:DefaultName>User</rd:DefaultName> | |
<CanGrow>true</CanGrow> | |
<KeepTogether>true</KeepTogether> | |
<Paragraphs> | |
<Paragraph> | |
<TextRuns> | |
<TextRun> | |
<Value>=First(Fields!User.Value, "DataSet1")</Value> | |
<Style /> | |
</TextRun> | |
</TextRuns> | |
<Style /> | |
</Paragraph> | |
</Paragraphs> | |
<Top>0.705in</Top> | |
<Left>0.21333in</Left> | |
<Height>0.25in</Height> | |
<Width>1in</Width> | |
<ZIndex>1</ZIndex> | |
<Style> | |
<Border> | |
<Style>None</Style> | |
</Border> | |
<PaddingLeft>2pt</PaddingLeft> | |
<PaddingRight>2pt</PaddingRight> | |
<PaddingTop>2pt</PaddingTop> | |
<PaddingBottom>2pt</PaddingBottom> | |
</Style> | |
</Textbox> | |
</ReportItems> | |
<Height>2.25in</Height> | |
<Style> | |
<Border> | |
<Style>None</Style> | |
</Border> | |
</Style> | |
</Body> | |
<Width>6in</Width> | |
<Page> | |
<PageFooter> | |
<Height>0.45in</Height> | |
<PrintOnFirstPage>true</PrintOnFirstPage> | |
<PrintOnLastPage>true</PrintOnLastPage> | |
<ReportItems> | |
<Textbox Name="ExecutionTime"> | |
<rd:DefaultName>ExecutionTime</rd:DefaultName> | |
<CanGrow>true</CanGrow> | |
<KeepTogether>true</KeepTogether> | |
<Paragraphs> | |
<Paragraph> | |
<TextRuns> | |
<TextRun> | |
<Value>=Globals!ExecutionTime</Value> | |
<Style /> | |
</TextRun> | |
</TextRuns> | |
<Style> | |
<TextAlign>Right</TextAlign> | |
</Style> | |
</Paragraph> | |
</Paragraphs> | |
<Top>0.2in</Top> | |
<Left>4in</Left> | |
<Height>0.25in</Height> | |
<Width>2in</Width> | |
<Style> | |
<Border> | |
<Style>None</Style> | |
</Border> | |
<PaddingLeft>2pt</PaddingLeft> | |
<PaddingRight>2pt</PaddingRight> | |
<PaddingTop>2pt</PaddingTop> | |
<PaddingBottom>2pt</PaddingBottom> | |
</Style> | |
</Textbox> | |
</ReportItems> | |
<Style> | |
<Border> | |
<Style>None</Style> | |
</Border> | |
</Style> | |
</PageFooter> | |
<LeftMargin>1in</LeftMargin> | |
<RightMargin>1in</RightMargin> | |
<TopMargin>1in</TopMargin> | |
<BottomMargin>1in</BottomMargin> | |
<Style /> | |
</Page> | |
</ReportSection> | |
</ReportSections> | |
<ReportParametersLayout> | |
<GridLayoutDefinition> | |
<NumberOfColumns>4</NumberOfColumns> | |
<NumberOfRows>2</NumberOfRows> | |
</GridLayoutDefinition> | |
</ReportParametersLayout> | |
</Report> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment