Excel Import: named

When a report is exported to Excel, each page in the report becomes a
worksheet. The worksheets are named as 'sheet 1', 'sheet 2' etc. Is there
any way to name the sheets as page headings?Hi Sanjay,
My grouping is exactly the same. However, I also have pagebreakatend set:
<Grouping Name="list1_Country_Name">
<GroupExpressions>
<GroupExpression>=Fields!CountryName.Value</GroupExpression>
</GroupExpressions>
<PageBreakAtEnd>true</PageBreakAtEnd>
</Grouping>
A.
"Sanjay" wrote:
> I have the following grouping element in my report:
> <Grouping Name="list2_Details_Group">
> <GroupExpressions>
> <GroupExpression>=Fields!customer_name.Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> Excel is rendered as each customer in a different sheet but I also need the
> sheet name to be =Fields!customer_name.Value.
> Andrew,
> Can you post the rdl extract where your groupings are named?
> Thanks
> Sanjay
> "Andrew Byrne" wrote:
> > I have seen this whenever I export to Excel and have my report grouped. For
> > example, if I group by country then excel will render with each sheet=a
> > country. In my case the country names were written to the Sheet Name, so
> > maybe you just need to name your groupings in the report?
> >
> > "Sanjay" wrote:
> >
> > > When a report is exported to Excel, each page in the report becomes a
> > > worksheet. The worksheets are named as 'sheet 1', 'sheet 2' etc. Is there
> > > any way to name the sheets as page headings?

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.

Friday, February 17, 2012

Excel Rendering Question

Wednesday, February 15, 2012

Excel import and german umlaute

Excel Import

Blog Archive

About Me