HI,
I am trying to pass the values selected in the xcelsius combo box to the webi report.
The user will select Year & Quarter in two separate combo boxes and I want these selected values to be passed to the webi report which has to be generated based on the values. I am using the opendoc function but not able to generate the webi report.
http://opendoc/openDocument.jsp?iDocID=AZ9DWm7h0H9KrbLqX7onDew&sIDType=CUID&sType=wid&sRefresh=Y&lsSEnter+Fiscal+Year="&D8&" &lsSEnter+Fiscal+Quarter= “&E8&”
D8 & E8 are the cells in excel which will have the Year & Quarter values. When I manually enter the values for Year & Quarter in the syntax , it works fine . can someone plz do help me where i am going wrong.
gemini4u (BOB member since 2012-02-07)