Skip to Content
author's profile photo Former Member
Former Member

WAD printing problem

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Jun 19, 2007 at 12:50 PM

    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/how-to%20guides%20-%20rig%20official/how%20to%20web%20printing%20with%20microsoft%20excel.zip

    There are also some forum threads discussing the same.

    Hope this helps...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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>

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

      <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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2007 at 12:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2007 at 12:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 20, 2007 at 04:43 PM

    Error in the code while implementing print functionality

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 20, 2007 at 06:52 PM

    Solved

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.