Wednesday, February 15, 2012

Excel import and german umlaute

I'm still having some issues with report names using "german umlaute".
Attached two small dataless sample reports, originally named "Ärger.rdl" and
"Übersicht.rdl". Both consists of a textbox linking to each other. Tis works
fine and is displayed correctly in HTML. Exporting one report to Excel and
trying to follow the link fails.
Should I avoid german umlaute in report names? I would consider to do so if
we would have 1982. But not today...:)
r.
Ärger.rdl
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<RightMargin>2.5cm</RightMargin>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextDecoration>Underline</TextDecoration>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>6.78968cm</Width>
<Action>
<Drillthrough>
<ReportName>Ãobersicht</ReportName>
</Drillthrough>
</Action>
<CanGrow>true</CanGrow>
<Value>Here is Ã"rger.rdl. Back to Ãobersicht.rdl</Value>
</Textbox>
</ReportItems>
<Style />
<Height>0.63492cm</Height>
<ColumnSpacing>1cm</ColumnSpacing>
</Body>
<TopMargin>2.5cm</TopMargin>
<Width>16cm</Width>
<LeftMargin>2.5cm</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>29.7cm</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<PageWidth>21cm</PageWidth>
<rd:ReportID>52737cce-c0a6-4c5e-b23b-eaeca22bd186</rd:ReportID>
<BottomMargin>2.5cm</BottomMargin>
<Language>de-DE</Language>
</Report>
Übersicht.rdl
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<RightMargin>2.5cm</RightMargin>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextDecoration>Underline</TextDecoration>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Height>0.63492cm</Height>
<Width>7.75cm</Width>
<Action>
<Drillthrough>
<ReportName>Ã"rger</ReportName>
</Drillthrough>
</Action>
<CanGrow>true</CanGrow>
<Value>This way to Ã"rger.rdl</Value>
</Textbox>
</ReportItems>
<Style />
<Height>0.75cm</Height>
<ColumnSpacing>1cm</ColumnSpacing>
</Body>
<TopMargin>2.5cm</TopMargin>
<Width>8cm</Width>
<LeftMargin>2.5cm</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>29.7cm</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<PageWidth>21cm</PageWidth>
<rd:ReportID>b4667abb-f9e5-490e-b3ff-8cca1050a2d1</rd:ReportID>
<BottomMargin>2.5cm</BottomMargin>
<Language>de-DE</Language>
</Report>Yes, we can reproduce the drillthrough issue and we will look into fixing
it. Unfortunately, it's too late for SP1.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roland" <nomail@.spamprotect.com> wrote in message
news:OP%23skQWWEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I'm still having some issues with report names using "german umlaute".
> Attached two small dataless sample reports, originally named "Ärger.rdl"
and
> "Übersicht.rdl". Both consists of a textbox linking to each other. Tis
works
> fine and is displayed correctly in HTML. Exporting one report to Excel and
> trying to follow the link fails.
> Should I avoid german umlaute in report names? I would consider to do so
if
> we would have 1982. But not today...:)
> r.
>
> Ärger.rdl
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <rd:GridSpacing>0.25cm</rd:GridSpacing>
> <RightMargin>2.5cm</RightMargin>
> <Body>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <TextDecoration>Underline</TextDecoration>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Width>6.78968cm</Width>
> <Action>
> <Drillthrough>
> <ReportName>Ãobersicht</ReportName>
> </Drillthrough>
> </Action>
> <CanGrow>true</CanGrow>
> <Value>Here is Ã"rger.rdl. Back to Ãobersicht.rdl</Value>
> </Textbox>
> </ReportItems>
> <Style />
> <Height>0.63492cm</Height>
> <ColumnSpacing>1cm</ColumnSpacing>
> </Body>
> <TopMargin>2.5cm</TopMargin>
> <Width>16cm</Width>
> <LeftMargin>2.5cm</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <PageHeight>29.7cm</PageHeight>
> <rd:DrawGrid>true</rd:DrawGrid>
> <PageWidth>21cm</PageWidth>
> <rd:ReportID>52737cce-c0a6-4c5e-b23b-eaeca22bd186</rd:ReportID>
> <BottomMargin>2.5cm</BottomMargin>
> <Language>de-DE</Language>
> </Report>
>
> Übersicht.rdl
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <rd:GridSpacing>0.25cm</rd:GridSpacing>
> <RightMargin>2.5cm</RightMargin>
> <Body>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <TextDecoration>Underline</TextDecoration>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Height>0.63492cm</Height>
> <Width>7.75cm</Width>
> <Action>
> <Drillthrough>
> <ReportName>Ã"rger</ReportName>
> </Drillthrough>
> </Action>
> <CanGrow>true</CanGrow>
> <Value>This way to Ã"rger.rdl</Value>
> </Textbox>
> </ReportItems>
> <Style />
> <Height>0.75cm</Height>
> <ColumnSpacing>1cm</ColumnSpacing>
> </Body>
> <TopMargin>2.5cm</TopMargin>
> <Width>8cm</Width>
> <LeftMargin>2.5cm</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <PageHeight>29.7cm</PageHeight>
> <rd:DrawGrid>true</rd:DrawGrid>
> <PageWidth>21cm</PageWidth>
> <rd:ReportID>b4667abb-f9e5-490e-b3ff-8cca1050a2d1</rd:ReportID>
> <BottomMargin>2.5cm</BottomMargin>
> <Language>de-DE</Language>
> </Report>
>
>|||Great, Robert. I'll be patient. Meanwhile I'll rename my reports.
Thanks.
r.

No comments:

Post a Comment