'SQL Server Reporting Services (SSRS) - Text To Speech
Is it possible to add Text To Speech to the heading of a SSRS table report that is run on a webpage, if so how should you do it?
Here is an example of one of the reports we need Text To Speech on.
The whole XML for the report is 30.000 lines, so I just post some of it, if you are missing some information please let me know and I will post it.
<TablixRow>
<Height>1.64657cm</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="txtDateHeader">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>
=IIF(Parameters!GroupData.Value, "", Switch(
Parameters!ReportStyle.Value = 0, Code.GetDateFormat(Format(Fields!EventDateTime.Value, "yyyy-MM-dd HH:00"), "f", Parameters!Culture.Value),
Parameters!ReportStyle.Value = 1, Code.GetDateFormat(Fields!DateTimeGroup.Value, "D", Parameters!Culture.Value),
Parameters!ReportStyle.Value = 2, Code.GetDateFormat(Fields!DateTimeGroup.Value, "Y", Parameters!Culture.Value),
Parameters!ReportStyle.Value = 3, Code.GetDateFormat(Fields!DateTimeGroup.Value, "Y", Parameters!Culture.Value),
Parameters!ReportStyle.Value = 4, Code.GetDateFormat(Fields!DateTimeGroup.Value, "yyyy", Parameters!Culture.Value),
Parameters!ReportStyle.Value = 5, ""))
</Value>
<Style>
<FontSize>9pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#444444</Color>
<Style>Solid</Style>
<Width>2pt</Width>
</Border>
<BackgroundColor>#191919</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>4pt</PaddingTop>
<PaddingBottom>4pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox200">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.LocalizedValue("Successful", Parameters!Culture.Value)</Value>
<Style>
<FontSize>9pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox200</rd:DefaultName>
<Style>
<Border>
<Color>#444444</Color>
<Style>Solid</Style>
<Width>2pt</Width>
</Border>
<BackgroundColor>#191919</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>4pt</PaddingTop>
<PaddingBottom>4pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox201">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Code.LocalizedValue("Failed", Parameters!Culture.Value)</Value>
<Style>
<FontSize>9pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox201</rd:DefaultName>
<Style>
<Border>
<Color>#444444</Color>
<Style>Solid</Style>
<Width>2pt</Width>
</Border>
<BackgroundColor>#191919</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>4pt</PaddingTop>
<PaddingBottom>4pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
