Enhance web printing - fit to page ?

[Former Member]

Hi,

I have implemented the white paper 'Enhance web printing' but I would like to enhance it further to be able to do a fit-to-page when printing so I can see the 12 reports of a report I have built.

Any idea if this can be done and what could be done ?

Thanks

David

[Former Member · Accepted solution]

The Problem with fit-to page and HTML is that it is not working. HTML is not a Pageoriented design like PDF. There are a lot of strange things to take care of, if you want to print html in that way that a Browser recognizes the Layout and prints it correctly. The easiest way is to let a external tool (like Html-toPdf Converters or export to Excel)perform the conversion to achieve a good printing result. Excel has a excelent Print engine. But it is a lot of effort to create the excel format in Office XML Style. I created an external Windows service which can convert HTML to Pdf. Together with 2 new items which offers Pagesetup and Pagebreak options in the WAD. The User can choose print out of the contextmenu, which calls the windows service on the Application server, and returns the PDF file in separate window. Afterwards the user can print with acrobat reader.

FROM my opinion it is really difficult to transform the html in good looking way. for example. You have a large table with more than one Characteristic in the drilldown. If you now want to transform the html, it is difficult, because the Tablecells uses row and colspans, which are not breakable. and so. Also you have a problem with header an footers.

Also you have a problem with printing if you make us of the broadcaster. The user who receives the html-files cannot print them, and also he can't call the helpservice, because he is offline...

best regards.

Kai Wachter

[Former Member]

Hello David,

I am also trying to implement WEB printing on BW templates but having loads of problems doing it.

Is there any chance you could send a copy of your code?

I am trying the "fit to page" but also trying to default the page to landscape.

Any help would be great.

Thanks

Paul Merrigan

Paulmerrigan@ireland.com

[former_member188975]

Hi,

If you have access to BW Expert, the current issue has an article "Provide Easy-to-Use BW Web Print Controls in a Drop-Down Menu". This explains how can provide page layout options in the form of a drop down menu for users. The article also has the code required for doing this.

Hope this helps...

[Former Member]

Hello Bhanu,

I am sorry but I am still having problems with this printing from excel.

When the print function is chosen I just get a bank IE screen. Nothing is displayed.

Here's the URL being used:

http://hola2d65.axa-de.intraxa:8021/sap/bw/BEx?SAP-LANGUAGE=E&PAGENO=1&REQUEST_NO=1&CMD=PROCESS_HELP...

I am assuming that this is a call to my class ZCL_RSR_XLS_HELP_WINDOW_PRINT on BW but this is not working correctly.

I have created this with Superclass CL_RSR_WWW_HELP_WINDOW. Is this correct?

It's strange that the window just goes to blank.

Thanks

Paul.

[Former Member]

Hi Bhanu,

Is the applicable to BW 3.1/3.0?

Did you try the solution? Did that work properly to download the data to excel?

How about downloading hierarchy, Charts and map to excel?

Thank you

AP

[former_member188975]

Sorry...I put in a lot of work on the other web printing solution, so did not try this yet...may be you could implement it and let me know then

[Former Member]

Has the How To paper been released for the web printing with excel? I can't find it but it was meant to be available in February.

[Former Member]

Hi Bhanu Gupta,

Are you reffering to the document in service.sap.com/bw --> Media library --> Guide List SAP BW3.0B/ BW3.1 Content --> How to… Enhance Web Printing

But this document doesn't explain about downloading the content to excel?

Is there any other document available to enable proper download of complete data in the data provider to Excel?

Thank you

AP

[former_member188975]

Hi AP,

I was referring to the Jan 27 2005 webinar: Business Intelligence Web printing with excel.

https://www.sdn.sap.com/sdn/webinar.sdn?res=/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/docum... intelligence web printing with excel.article

[former_member188975]

This morning's webinar: <b>Business Intelligence Web Printing with Excel</b> showed how Excel can be used as a page-oriented tool for printing. A new How To...for this will be out in Feb 2005. It will require implementing a help service and class which will transfer complete content of the web application to excel for printing.