Hi,
I need to develope a webpage or something else, where we need to provide a drop down box for a list of WAD reports we have. If the user selects reports, then each report shud be executed in a separate different sessions ! Please guide me on how to start!
Request clarification before answering.
Hi Rahul,
I sent to you my solution if you have any questions please inform me.
Regards
Erwin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok here you go.
I started by Creating a blank Template in WAD for 3.5
In the Head section of the Web Template add the following Code as Javascript.
Create a Function in Javascript.
fun dropdown( myval )
start with a curly bracket
var surl, smess
surl = web site string
e.g http://server:port/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=
smess = Please Choose a Report to Run
Check if the value in myVal is X
incase it is X then show an alert message to user and then return false
in case it is not X then you have the template to run
append the value in myval to surl and use a open method of the window to run the url
in a separate window
and return true
end with a curly bracket.
In the Body Section of the Web page please create and HTML Drop down box using the select Tags of HTML.
First Option will be X and text for that will be choose a report
Next Option store the Value as Technical Id of the Template and the Description for Dropdown.
Then create an INPUT Button with and onclick to call the function
onclick will then call the javacript function with gourl.value as a parameter.
Since we cannot post the code please google up the syntax for SELECT and INPUT Button incase you don't know that.
You can pretty up the Page by Adding Heading and Logo and Table Etc.
Try with Couple Templates before you add all the Templates in the Dropdown list.
Save the Template and you should be ready to go.
Hope this helps. Not sure why we can preview code and then it won't post. I think some characters of the code are causing it to fail.
Datta.
in 7.0 it is much easier, you don't have to use javascript. Here you can use commands:
at first you need to create dropdown_item. By Data Binding (dropdown_item) you should choose Fixed List of Option. Here you can write names of your web applications. After that you can use command wizard and the command: SET_TEMPLATE for each web template.
By SET_TEMPLATE please choose "Open in New Window"
Regards
Erwin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry my solution is only for 3.5, but read this thread from the beginning I gave some tips for BI7.0 too.
Regards
Erwin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Do you also use WAD 3.5?
Regards
Erwin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul,
sorry but I was yesterday not available.
Thanks for your fast reply. The code works for me, but I need to tweak it a bit for a better look. You can see the format of the output I get in the attchment.I need to change the format like:
...
It would be better if you can provide me material on formatting the Script with colors/lines/font.
Please guide.
You should use CSS (Cascading Style Sheets). Check this link, you can find there a lot of examples:
http://www.w3schools.com/css/css_examples.asp
Regards
Erwin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use something like this,
Start a new Web application in the main window
SAPBWSetOpenerUrl(SAP_BW_URL_Get() + "&CMD=LDOC&TEMPLATE_ID=NewTemplate");
Please go through the link below, its the Web API Ref for WAD 3.5 and this will surely sort out your problem. You can search for dropdowns or search for commands to open up reports in new window.
Even i had some problem in posting a code, pls go through the Web API. Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't know why but I can't send you the code. If you want you can send me an ma-l l: check my Business Card
I will send you per m.
Regards
Erwin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul,
here you have some simple example:
you have to adjust technical names of your web applications
...
...
I have some problems to send a code
Regards
Erwin
Edited by: Erwin Buda on Dec 8, 2008 9:27 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry you can forget it. It refers to WAD 7.0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
at first you need to create dropdown_item. By Data Binding (dropdown_item) you should choose Fixed List of Option. Here you can write names of your web applications. After that you can use command wizard and the command: SET_TEMPLATE for each web template.
By SET_TEMPLATE please choose "Open in New Window"
Regards
Erwin
Edited by: Erwin Buda on Dec 8, 2008 3:49 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Erwin,
Im on 3.5 version.
By following your steps, I could create a Drop Down web item, but we need to assing some query to this before we change any property right! My requirement is to have a list of WAD reports in 1 page, so that we can select which report we want to run! And I didnt understand your steps:
"By Data Binding (dropdown_item) you should choose Fixed List of Option. Here you can write names of your web applications. After that you can use command wizard and the command: SET_TEMPLATE for each web template. "
By SET_TEMPLATE please choose "Open in New Window"
Please guide!
Hi Rahul,
Is creating a simple HTML Page with Dropdown Box an Option ?
If so then using WAD you can create a Page with Java script Drop down box and use URL to Templates by doing window.location = url you should be able to launch the web report in separate window.
I am going to try this will post back.
Hope that gets you started.
Datta.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.