I am working in an environment where sometimes a report will be
run from a VisualBasic interface, and sometimes will be run
straight out of the Business Objects Reporter.
When I run the report from BO, there are cells which display the
response to prompts, i.e.
=UserResponse(“Query 1 with Universe”, “Prompt_Text”)
The VB interface, however, collects the responses and passes
them to BusinessObjects with the same Prompt Text. But the
variables are not then recognized as user responses. Instead,
the formula in the cell needs to be:
=ApplicationValue(“Prompt_Text”)
Hence, if I am running from both BO and VB, I need to change
these formulas every time I swap my front end app.
Is there a way around this? Can I set up the formula based on
the run source, or is there another BO function that will allow me
to see the prompt response independent of the front end app?
I am working in an environment where sometimes a report will be
run from a VisualBasic interface, and sometimes will be run
straight out of the Business Objects Reporter.
When I run the report from BO, there are cells which display the
response to prompts, i.e.
=UserResponse(“Query 1 with Universe”, “Prompt_Text”)
The VB interface, however, collects the responses and passes
them to BusinessObjects with the same Prompt Text. But the
variables are not then recognized as user responses. Instead,
the formula in the cell needs to be:
=ApplicationValue(“Prompt_Text”)
Hence, if I am running from both BO and VB, I need to change
these formulas every time I swap my front end app.
Is there a way around this? Can I set up the formula based on
the run source, or is there another BO function that will allow me
to see the prompt response independent of the front end app?
Hi Romona:
Try using the following and see if it helps.
=If Length(UserResponse(DataProvider(),“Prompt”)) > 0 Then
UserResponse(DataProvider(),“Prompt”)) Else
ApplicationValue(“Varname”)
P.S. Please check to see if the syntax is correct since I havn’t checked it!
Hope it helps.
Regards,
Chander Aggarwal
COMPUEXCEL http://www.compuexcel.com
The home of BusinessObjects Essentials - the Worlds First and Leading Full
Multimedia Computer Based Training For BusinessObjects, with over 15,000
users world-wide!