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.
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+