cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling an ABAP Report from the Web

Go to solution
chris_hamman
Explorer

on ‎2007 Mar 28 7:24 PM

0 Kudos
122

Hello all,

Is there a way in WAD to have a web link call an ABAP report? I am trying to provide a link in my web template to allow users to launch the BEx Analyzer. When I look at transaction RRMX in the GUI, it appears to be calling the ABAP report RRMX_START_EXCEL. Can I use BSP to accomplish this?

Thanks in advance for any help you can provide,

Chris

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎2007 Mar 28 7:57 PM
0 Kudos

Hi,

sure, in your BSP you would simply call "submit RRMX_START_EXCEL and return". In your webtemplate you have just to call this BSP.

Regards,

Juergen

Show replies
Show replies

Answers (3)

Answers (3)

chris_hamman
Explorer
‎2007 Mar 29 3:17 PM
0 Kudos

Raja,

Thanks for your help!! However, what I want to be able to do is launch the Analyzer in Excel, not the web. Using the code above, IE will try to load the spreadsheet in the browser (if the user has set this option).

Any ideas? Thanks again!!

Show replies
Show replies
chris_hamman
Explorer
‎2007 Mar 28 8:34 PM
0 Kudos

OK, here is the code for my BSP page:

<%@page language="abap"%>

<%@extension name="htmlb" prefix="htmlb"%>

<html>

<% submit RRMX_START_EXCEL and return. %>

</html>

When I attempt to test it, however, I am receiving the following error:

The following error text was processed in the system BWS : Screen output without connection to user.

The error occurred on the application server sapbwsci_BWS_35 and in the work process 5 .

The termination type was: RABAX_STATE

The ABAP call stack was:

Module: SEND_TAB of program SAPLGRAP

Function: GRAPH_RECEIVE of program SAPLGRAP

Function: REGISTRY_GET of program SAPLGRAP

Form: PREPARE_LAUNCHER of program SAPLRSAH

Function: RSAH_LAUNCH_EXCEL of program SAPLRSAH

Form: START_EXCEL of program RRMX_START_EXCEL

START-OF-SELECTION of program RRMX_START_EXCEL

Any ideas??

Thanks again!!

Show replies
Show replies
athavanraja
Active Contributor
‎2007 Mar 29 8:46 AM
0 Kudos

you cannot use RRMX_START_EXCEL in BSP as this program uses OLE

what you need is a link like below in your webtemplate

<a href="file:---C:-Program%20Files-SAP-FrontEnd-Bw-sapbex.xla">
open Bex</a>

in the above code replace '-' with '\'

here the path is hardcoded, instead you can use scripts to read user registry to read the path from

SAP.BusinessExplorer.Analyzer\path

Raja

Message was edited by:

Durairaj Athavan Raja

athavanraja
Active Contributor
‎2007 Mar 29 9:08 AM
0 Kudos

here is the javascript code to get the path dynamically

<script>

var WshShell = new ActiveXObject("WScript.Shell"); 


var bKey =    WshShell.RegRead ("HKCR\SAP.BusinessExplorer.Analyzer\path\");

WScript.Echo (WshShell.RegRead ("HKCR\SAP.BusinessExplorer.Analyzer\path\"));


alert(bKey);

</script>

Regards

Raja

Former Member
‎2007 Mar 28 7:40 PM
0 Kudos

Can you create a jump in transaction RSBBS and jump from report to your ABAP program. You can give the transaction code of the report in RSBBS.

When the report is run, press GOTO and you will see the t code and click that will take yu to te report. Can you try this.

Ravi Thothadri

Show replies
Show replies
Ask a Question