Table(Column Headers)on each page f excel print(Webi to Exel

building reports webintelligence
1

Hello All,

I’m a newbie to WEBI. I’m working on a report which needs to exported to Excel. I’m having few issues with

1)The column headers ( I mean the table Header) -I have set the properties to report on Every Page and when i see in the Info View I can see the Header on Each Page
but the problem is when i download to excel , i see all the records(I have 500 Records ) and i see the Column Header , but the real problem is when the user want to print the content will be at least 10 pages on each page she needs to see the column header ( On 10 Pages) .

I guess they have setting in excel itself to repeat Header on Each Page but the user don’t want to do that.

I have attached the Screen Shots of Table properties

I would appreciate the experts to weigh on this

Thanks in advance
[/img]
screenshot.5.jpg
screenshot.4.jpg

venki_bo (BOB member since 2013-02-28)

2

Welcome to B:bob:B!

That’s how export from WebI to XLS works.

And that’s the solution :slight_smile:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks Marek.
Also i have couple more question and i guess i know the answe but wanted to make sure.

Question1)
I have page numbers on Webi Report on one window cell -Then Entrie report is exported to Excel and then when we print we cannot the Page numbers Right.

Question2)

I know the WEBI Page Header and Footer when exported to excel will not be displayed, So what i did is i have a window cell in main body and used for that title and similarly another window cell for Company Logo -When exported to excel, i get the Title but not the Logo any particular reason or is that a limitation as well.

Thanks
Venkat

venki_bo (BOB member since 2013-02-28)

4

Another alternative is to have two report tabs in the Webi document. First report tab would be as is and the second report tab would be formatted/optimized for excel export.

I have noticed that when exporting to excel the images do not get exported.

BO)_User :us: (BOB member since 2010-03-01)

5

Venkat,

All the page settings are about printing/saving as PDF.

Save as Excel saves the report contents excluding headers and footers as an Excel-formatted file. If you are scheduling reports for distribution as Excel, then the user will have to tweak their print options, that’s just how it works, certainly in XI3 and below.

You may want to consider creating an Enhancement Request in the SAP Ideas Place if you feel that it is worth doing so.