Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Pass parameters from excel to BI Publisher report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pass parameters from excel to BI Publisher report

Received Response
edited Dec 24, 2020 9:59AM in Reporting and Analytics for ERP 4 comments


Pass parameters from excel to BI Publisher report



I run BI publisher report directly from excel by using soap and it works ok as long as i don't use any parameters. how can i add parameter to my soap code ? ( below is the main soap code )


reportBytes = f_execWsSoap("/Custom/Logistics/Inventory/Reports/On Hand Inventory Balance.xdo")

Public Function f_execWsSoap(ByVal reportAbsolutePath As String, Optional ByVal parameterNameValuesXML As String)
    Dim sURL As String
    Dim sEnv As String
    Dim base64reportBytes As String
    Dim reportBytes As String
    Dim httpReq As New XMLHTTP60
    Dim Response As String


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!