cancel
Showing results for 
Search instead for 
Did you mean: 

WAD printing problem

Former Member
0 Kudos

hi all

when I print WAD report using browsers print option . I see only table and the hierarchical filters in the print out. But I also have text element and navigational filter web item on the same pageand I cant see these items on the print out. Can you please advice me on this?. Also my client is not satisfied with printing functionality in WAD, any other alternatives for good printing ?

Thanks in advacne

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Hansa,

Web printing is an issue with BW 3.5. With Bi 7 you can generate the PDF and set print properties for it. But if you are BW 3.5, may be the following will help:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/business_packages/a1-8-4/h...

There are also some forum threads discussing the same.

Hope this helps...

Former Member
0 Kudos

Hi Bhanu,

I did as mentioned in the paper. But I get an error in the code saying "unterminated string constant" . the code is below. Please let me know where I went wrong.

[code]<HTML>

<!-- BW data source object tags -->

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_DATA_PROVIDER"/>

<param name="NAME" value="DATAPROVIDER_1"/>

<param name="QUERY" value="ZMXS_M02_Q0001"/>

<param name="INFOCUBE" value="ZMXS_M02"/>

DATA_PROVIDER: DATAPROVIDER_1

</object>

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_PROPERTIES"/>

<param name="TEMPLATE_ID" value="ZTESTWEBPRINTEXCEL"/>

TEMPLATE PROPERTIES

</object>

<HEAD>

<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">

<TITLE>BW Web Application</TITLE>

<link href="/sap/bw/Mime/BEx/StyleSheets/Meadow_BWReports.css" type="text/css" rel="stylesheet"/>

<link href="/sap/bw/Mime/Customer/StyleSheets/BWReports_Excel_print.css" type="text/css" rel="stylesheet"

media="print"/>

<script language="JavaScript">

SAPBWAddToMenu("Web Printing with Excel","myMenuProcessor","1","","","X","BOTTOM","","");

// Command Processing

function myMenuProcessor(parameter,cell_type,filter,parameter1,parameter2,item,dataprovider,x,y)

{

switch (parameter) {

case "1":

- 25 -

SAPBWOpenURL(SAP_BW_URL_Get()+"&CMD=PROCESS_HELP_WINDOW&

help_service=HELP_SERVICE_PRINT&item=TABLE_1&subcmd=PRINT_EXCEL");

break;

}

}

</script>

</HEAD>

<BODY>

<table><tr><td class="SAPBEXBtnStdBorder" cellspacing="0" cellpadding="0" border="0">

<table><tr><td class="SAPBEXBtnStd" cellspacing="0" cellpadding="0" border="0">

<A href="<sap_bw_url cmd='PROCESS_HELP_WINDOW' help_service='HELP_SERVICE_PRINT'

item='TABLE_1' subcmd='PRINT_EXCEL'>">

Web Printing with Excel</A>

</td></tr></table>

</td></tr></table>

<P><object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="GET_ITEM"/>

<param name="NAME" value="NAVIGATIONBLOCK_1"/>

<param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_NAV_BLOCK"/>

<param name="DATA_PROVIDER" value="DATAPROVIDER_1"/>

ITEM: NAVIGATIONBLOCK_1

</object>

</P>

<P><object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="GET_ITEM"/>

<param name="NAME" value="TABLE_1"/>

<param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_GRID"/>

<param name="DATA_PROVIDER" value="DATAPROVIDER_1"/>

<param name="HELP_SERVICE" value="HELP_SERVICE_PRINT"/>

<param name="HELP_SERVICE_CLASS" value="ZCL_RSR_XLS_HELP_WINDOW_PRINT"/>

ITEM: TABLE_1

</object></P>

<!-- Settings for Web Printing with Excel

// header with logo, footer, page orientation, margin, ...

@page

{

mso-header-data:"&L&\0022Arial\,Fett\0022&12&G&C&\0022Arial\,Fett\0022&14<&[REPTXTLG]> und

<&[DATAPROVIDER_1/REPTXTLG]>";

mso-footer-data:"&R&A";

margin:1.0in .75in 1.0in .75in;

mso-header-margin:.5in;

mso-footer-margin:.5in;

}

// fit to page, grid lines, logo (header picture)

<x:Print>

<x:FitWidth>1</x:FitWidth>

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

<x:ValidPrinterInfo/>

<x:PaperSizeIndex>9</x:PaperSizeIndex>

<x:Scale>86</x:Scale>

<x:HorizontalResolution>600</x:HorizontalResolution>

<x:VerticalResolution>600</x:VerticalResolution>

<x:Gridlines/>

<x:HeaderPicture>

<x:Location>Left</x:Location>

<x:Source>http://www.sap.com/global/images/sap_logo.gif</x:Source>

<x:Height>37</x:Height>

<x:Width>73</x:Width>

<x:LockAspectRatio/>

<x:ColorType>Automatic</x:ColorType>

</x:HeaderPicture>

</x:Print>

// page breaks

<x:PageBreaks>

<x:ColBreaks>

<x:ColBreak>

<x:Column>9</x:Column>

<x:RowEnd>78</x:RowEnd>

</x:ColBreak>

</x:ColBreaks>

<x:RowBreaks>

- 26 -

<x:RowBreak>

<x:Row>42</x:Row>

<x:ColEnd>15</x:ColEnd>

</x:RowBreak>

</x:RowBreaks>

</x:PageBreaks>

// column widths

<x:ColWidths>

<col style='mso-width-source:auto'>

<col style='mso-width-source:auto'>

<col style='mso-width-source:auto'>

<col width=200 style='mso-width-source:userset'>

<col width=100 style='mso-width-source:userset'>

</x:ColWidths>

// Repeated Rows

<x:RepeatedRows>

$2:$2

</x:RepeatedRows>

// Repeated Cols

<x:RepeatedCols>

$B:$B

</x:RepeatedCols>

// BW parameters

<x:BW>

<hierarchy_icons hide=>

</x:BW>

-->

</BODY>

</HTML>

[/code]

Message was edited by:

Hansa

Answers (4)

Answers (4)

Former Member
0 Kudos

Solved

Former Member
0 Kudos

Hansa,

I am having the same problem. Could you please elaborate on how you solved this?

Thanks

Former Member
0 Kudos

Error in the code while implementing print functionality

Former Member
0 Kudos

Hi hansa,

the web items like text element and navigational filter web item normally will not come int the print out. And if your requirement is like that you have to use a good javascripting.

Charts , analysis item etc will normally come in the print out by using the Export to PDF file command option given in WAD.

cheers

Sunil

Former Member
0 Kudos

Hi Sunil

I am using BW 3.5 ...do u have any document on pdf printing? or explain me in detail

Thanks

Former Member
0 Kudos

Hi Karthik I want both the table and text element to be printed. So whats the code for it?

Former Member
0 Kudos

Hello ,

You should have two seperate links , one for printing table and the other for the text elements, but i am not sure it is possible , you can try it.

hope it helps,

Former Member
0 Kudos

Hello ,

In the below given code did you try by giving the textelement name for example

item="TEXTELEMENTS_2" instead of item="TABLE_1"

SAP_BW_URL cmd="PROCESS_HELP_WINDOW"

help_service="ZPRINTING" item="TABLE_1"

hope it helps,

assign points if useful

Message was edited by:

Karthik Egamparam Venkataraman