How to build a "Report"

[Former Member]

I want to build a report.

I found a reference to building a report but cant find any simple examples to work through.

I know how to setup a grid but how do i setup labels, Headers etc so that they are sourced from a query?

Basically I want to have a report that looks like this (all items in <> are from the database)

<RepotName> - <ReportDate>

<RepotNotes>

Table Header Row

<LineItems>

Table Foooter Row

[Former Member]

Hi Chris,

You can also use a servlet call, which uses a query template and a xsl stylesheet in lieu of a display template to build your report. I'm not sure what version of MII you are using, but the Wizards in the 12.1 Workbench (or a separate download from the SDN for 12.0) have a Report tool to assist you in generating the proper code for the servlet.

This was a little intimidating for me at first, but I used one of the stylesheets included in the product as a model for creating my own stylesheet, and it worked beautifully. Please let me know if you would like a bit more information on doing this.

Kind Regards,

Diana Hoppe

[Former Member]

Hi Diana

This sounds like exactly what I need

I am using 12.0 and we are moving to 12.1 soon (waiting on a new server)

Can you send me more info and a link to the download, I just had a look and cant find it

A "visual designer" would solve so many of my problems.

Chris

[Former Member]

Chris,

you can download the Productivity Wizards for MII 12.0 from the following link:

[http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/webcontent/uuid/c0f1fdb7-b080-2a10-3ba4-ac0bd069ce41 [original link is broken]].

After installing, open the Content Generation Wizard. There you can use the Create HTML for your needs. For more info see the [SAP Help on Wizards|http://help.sap.com/saphelp_xmii120/helpdata/en/45/90abe2f82140bfe10000000a1553f7/frameset.htm].

Michael