Skip to content

Instantly share code, notes, and snippets.

@Ioan-Popovici

Ioan-Popovici/SR Display Formatted Text.rdl

Created September 26, 2019 12:48
Show Gist options
  • Save Ioan-Popovici/758a60488c830ec1ac82d0c5681ff584 to your computer and use it in GitHub Desktop.
Save Ioan-Popovici/758a60488c830ec1ac82d0c5681ff584 to your computer and use it in GitHub Desktop.
Download ZIP
SEC Bitlocker Compliance and Policy.rdl subreport. Displays properly formatted text for the bitlocker policy.
Raw
SR Display Formatted Text.rdl
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
<Description>Sub report for displaying formatted text.</Description>
<Author>Ioan Popovici @ SCCM-Zone.com</Author>
<AutoRefresh>0</AutoRefresh>
<ReportSections>
<ReportSection>
<Body>
<ReportItems>
<Textbox Name="TXB_XML">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>FormattedTextString</Label>
<Value>=REPLACE(Parameters!TextString.Value, ";" ,CHR(10))</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Top>0.04167in</Top>
<Left>0.06125in</Left>
<Height>3.55014in</Height>
<Width>8.64583in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Height>9.23396cm</Height>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Body>
<Width>22.33083cm</Width>
<Page>
<PageHeader>
<Height>1.2827cm</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<ReportItems>
<Textbox Name="ReportTitle">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>ReportHeader</Label>
<Value>=Parameters!ReportHeader.Value</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>18pt</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:WatermarkTextbox>Title</rd:WatermarkTextbox>
<rd:DefaultName>ReportTitle</rd:DefaultName>
<Top>0.05in</Top>
<Left>0.05in</Left>
<Height>0.37917in</Height>
<Width>3.01042in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Line Name="Line1">
<Top>0.47375in</Top>
<Left>0.06125in</Left>
<Height>0in</Height>
<Width>8.64583in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>Solid</Style>
</Border>
</Style>
</Line>
</ReportItems>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</PageHeader>
<PageFooter>
<Height>1.143cm</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</PageFooter>
<PageHeight>29.7cm</PageHeight>
<PageWidth>21cm</PageWidth>
<LeftMargin>2.54cm</LeftMargin>
<RightMargin>2.54cm</RightMargin>
<TopMargin>2.54cm</TopMargin>
<BottomMargin>2.54cm</BottomMargin>
<ColumnSpacing>1.27cm</ColumnSpacing>
<Style />
</Page>
</ReportSection>
</ReportSections>
<ReportParameters>
<ReportParameter Name="ReportHeader">
<DataType>String</DataType>
<Prompt>ReportHeader</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="TextString">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>TextString</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rd:ReportUnitType>Cm</rd:ReportUnitType>
<rd:ReportID>be75ec2e-6dab-4f11-a77b-4e5ddd8e66d4</rd:ReportID>
</Report>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment