Web Printing

[Former Member]

Hi Gurus,

I'm having issues with Web Printing. I recently implemented Enhancing Web Printing with Excel, but the main problem is I cant generate charts in excel using it.

1) is it possible to generate charts using excel printing?

2) Is there anyway, i can enhance web printing, so that my reports fit to one page even tho, it has scroll bar?

3) is it possible to change the layout of the page while printing depending on the width of the table?

4) When does SAP delivers us with New Printing Capablities with Charts and different Web Items ?

Any help will be great.

regards,

Deepak

[Former Member]

Hello Deepak!

Here are my answers to your questions...

1) is it possible to generate charts using excel printing?

-> It is currently not possible. It is technial possible but up to now, I had no time to implement. Please contact me for further details.

2) Is there anyway, i can enhance web printing, so that my reports fit to one page even tho, it has scroll bar?

-> Please use the FitWidth and FitHeight parameter of Excel...

<!-- print settings for Web Printing with Excel

<x:Print>

<x:FitWidth>2</x:FitWidth>

<x:FitHeight>2</x:FitHeight>

<!-- … add more print settings here … - remove this line -->

</x:Print>

-->

3) is it possible to change the layout of the page while printing depending on the width of the table?

-> What do you mean? Switching from portrait to landscape dynamically?

4) When does SAP delivers us with New Printing Capablities with Charts and different Web Items ?

-> Charts (see above). What other Web Items do you mean?

Yours,

Tobias

[Former Member]

Hi Tobias,

Thanks for your help. I changed the parameters <x:print>..</x:print>.

1) is it possible to generate charts using excel printing?

-> It is currently not possible. It is technial possible but up to now, I had no time to implement. Please contact me for further details

--> Can you tell me, which classes need to be enhanced to achieve the functionality for generating charts using excel.

3) is it possible to change the layout of the page while printing depending on the width of the table?

-> What do you mean? Switching from portrait to landscape dynamically?

--> I mean, switching between portrait and landscape dyanmically. I tried using Stylesheets but our reports are have many columns, I was unable to fit all the columns in a page. ( either in portrait or landscape)

4) When does SAP delivers us with New Printing Capablities with Charts and different Web Items ?

-> Charts (see above). What other Web Items do you mean?

--> Our main foucs is only charts.

I think, web printing is always an issue, if there is any easy way using Stylesheets and javascript it would be great.

Any Help with web printing or excel base printing will be a great help for me.

Thanks,

deepak

[Former Member]

Hello Deepak!

1. Chart

I'm sorry, I cannot describe you the implementation for printing charts step by step. It's quite difficult and requires internal knowlegde. Believe me, if it would be easy, I would have already implemented it...

2. Passing parameters dynamically

First, you have to add the parameter in the <SAP_BW_URL>-tag in the Web Template (like the SUBCMD command).

Second, you have to pass the parameter to the framework by adding it to the XLS-specific URL (this in done in ZCL_RSR_XLS_HELP_WINDOW_PRINT->PROCESS_CMD)

Third, the passed parameter must be interpreted in ZCL_RSR_XLS_ITEM_TEMPLATE->PROCESS_CMD (it's in I_R_PARAMETER). Based on this parameter the setting can be modified. The settings specified in the Web Template are read in the method ZCL_RSR_XLS_ITEM_TEMPLATE->SET_ITEM and put into private attributes of the class.

I will add such an example to the next version - but currently, I cannot give you a date for the next version...

Yours,

Tobias

[Former Member]

Hi Deepak,

are you now asking about web printing or printing with excel?

if you want to print web reporting pages id'd might have a solution for you.

Covered functionalities:

• selection of portrait / landscape; A4 / A3

• custom header / footer (pictures allowed)

• repeating header lines of the report (fixed number of data lines per page are not required)

• zoom functionality (make the report fit to one page with)

• print preview

• style sheets selection

Michael

[Former Member]

Hi Michael,

Thanks, I would really appreciate if you can help me with Web Printing.

I was tryind different options for printing, I have implemented Print with Excel but, I was unable to achieve what our users want. If you can please send me more info or sample code it would be a great help for me.

Thanks,

Deepak

[Former Member]

If you haven't seen the attached link, it has some options for enhancing web printing.

https://websmp102.sap-ag.de/~sapdownload/011000358700001853752005E/HowToWebPrintingWithExcel.zip