Enhance a UI Pattern to Take Advantage of the New Excel Web Printing Functionality

  • by Derek Johnson, Program Manager
  • August 1, 2005
You now can enhance your user interface (UI) pattern to enable you to print your reports in Microsoft Excel using default print parameters. This solution permits users to specify their default print settings using the BI template wizard. When the Web template is generated, a button is added to the template and the default print parameters are passed to Excel for printing.
Key Concept
The BI template wizard, which was introduced in BW 3.0 and improved for BW 3.5, allows power users to create a wide variety of complex reporting solutions without the need to know any Web programming languages. These templates are configured to allow power users to easily enter their reporting information into a user interface (UI) pattern. While you can create additional UI patterns to further standardize other specific reporting scenarios, you can also enhance a delivered UI pattern.

Have you ever wished your power users could create Web templates that specify how the information should be printed? I’m going to show you how to add Microsoft Excel print settings to a UI pattern so that power users can specify their settings without having to learn any Web programming. Instead of just downloading a report to Excel and adjusting their print settings, they can use a template that specifies how the information should be formatted. For example, wide reports would be set to print in landscape and narrow reports in portrait mode.

To achieve this, you combine two underused functionalities using the BI template wizard:

  • Use of custom UI patterns in a production environment

  • Microsoft Excel printing solution available for BW 3.0+

Derek Johnson

Derek Johnson is a program manager on the Delivery Operations Team with SAP America, Inc. He is responsible for the design and development of analytical and reporting applications to support SAP America’s consulting organization. Formerly a platinum consultant with the National Competency Center (NCC), he has more than 10 years experience working with SAP NetWeaver BW. Besides traditional data modeling and reporting, he also has extensive experience with Yahoo! Widgets, SAP NetWeaver Visual Composer, Web reporting, BW data mining, Xcelsius, ABAP, and JavaScript. He holds a BS degree in engineering from the University of Michigan-Ann Arbor, an MS degree in engineering from Wayne State University-Detroit, and an MS degree in management information systems from Case Western Reserve University-Cleveland.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.