topic Re: Web reporting template in Application Development and Automation Discussions

Web reporting template

Former Member — Mon, 12 Jun 2006 03:26:53 GMT

Hi All.

Where can I find the web reporting template?

I mean, if you see the FM : WWW_HTML_FROM_LISTOBJECT, it is using a template WEBREPORTING_REPORT.

Where is it defined? If I want to define my own template, how and where do I do it?

Thanks in adv.

Samant

Re: Web reporting template

Former Member — Mon, 12 Jun 2006 04:11:09 GMT

Hi Samant,

The following link from help gives a detail idea of all web templates and the one you asked.

http://help.sap.com/saphelp_47x200/helpdata/en/2b/d922ee4b8a11d1894c0000e8323c4f/frameset.htm

ALso for defining web templates you can check the following link.

http://help.sap.com/saphelp_nw04/helpdata/en/9e/9f653ade969f4de10000000a114084/content.htm

Please reward for the same.

Re: Web reporting template

ashok_kumar24 — Mon, 12 Jun 2006 05:00:13 GMT

Hi Samanth Kumar,

Go through these links

http://help.sap.com/saphelp_nw04/helpdata/en/9e/9f653ade969f4de10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/0d/af12403dbedd5fe10000000a155106/content.htm

http://www.sapgenie.com/its/webreport.htm

http://www.claraview.com/practice_areas_pdfs/Claraview_Reporting_Issues_of_SAPBW_Part_One_By_PS.pdf

Please reward me for the same

Thanks and Regards

Ashok

Re: Web reporting template

athavanraja — Mon, 12 Jun 2006 08:26:10 GMT

these templates are stored in transaction SMW0 (zero at the end)

go to this transaction , choose radiobutton

"HTML templates for WEBRFC applications" and hit F8

in the object name field enter WEBREPORTING_REPORT and click execute.

to see the contents of this page choose the line and click F8

Regards

Raja

Re: Web reporting template

Former Member — Tue, 13 Jun 2006 08:14:40 GMT

Hi Raja.

When I do as said by you, on selectin WEBREPORTING_REPORT, and clicking on Display, I get a message : For selected object type text/html, no application has been defined. Maintain the settings.

Where and what settings do I have to define ?

tks.

Re: Web reporting template

athavanraja — Tue, 13 Jun 2006 08:41:07 GMT

ok, before clicking on display,

from the same screen

settings->maintain MIME types and see whether text/html is there if its there leave the next step.

if not

(click on create

for MIME type field enter text/html

for name extension field enter .htm/.html

)

go to settings->Assign MIME editor

choose text/html from the dropdown of MIME type

in the editor field enter "C:\Program Files\Internet Explorer\IEXPLORE.EXE" or the appropriate path and hit save.

Now click the display button.

(why do you want to look at it? what do you want to do with that?)

Regards

Raja

Re: Web reporting template

Former Member — Tue, 13 Jun 2006 08:45:55 GMT

I already did that, but what I get in the IE is :

"!charset! "

that's all... I can't see any template.

I want to understand how the WWW_HTML_FROM_LISTOBJECT is generating the HTML content from it. What role has the template got to do with converting list to HTML?

What is the diff if I use WWW_LIST_TO_HTML.

WWW_I_LIST_TO_HTML also seems to be using this template.

Thanks again.

Re: Web reporting template

athavanraja — Tue, 13 Jun 2006 08:59:47 GMT

right click on the html page and click view source.

you will see the following.

<html !direction!><head>!charset!<title>!title!</title>
<!style!>
</head>
<!script!>
<body background="!mimepath!background.gif" bgcolor="#E8EAD8">
<blockquote>
<p align=left><font size=+2><b><!listname!></b></font></p>
<p align=left>
<!listbody!>
</p>
</blockquote>
</body>
</html>

in the source are all just place holders. if you look at the source code of the function module WWW_HTML_FROM_LISTOBJECT

you will see code like

l_merge_table-name = '!charset!'.

l_merge_table-command = 'R'.

append l_charset to l_merge_table-html.

append l_merge_table.

which means where ever the system find '!charset!' Replace it with (command eq R - there are different commands availalbe) actual value to come in that place.

to understand more about it check these links.

http://help.sap.com/saphelp_40b/helpdata/es/2b/d921034b8a11d1894c0000e8323c4f/content.htm

http://www.sapgenie.com/its/webreport.htm

Regards

Raja

Re: Web reporting template

Former Member — Tue, 13 Jun 2006 09:05:47 GMT

Thanks So much. Will chk out the links given by you.